P
Paula
Everyday I have to clean up an excel import (deleting blank cells and row and
moving data from one cell to another).
My 1st challenge is "how to automatically delete blank cells in any given
row" (this is spermatic throughout the worksheet)
Example: when cells in columns A and B are blank then delete that
row.
My 2nd challenge is "how to move data from once cell to it's adjacent cell"
(this is also spermatic throughout the worksheet)
Example: Move cell Data ONLY from column C into column B of the
same row
If anyone one can help me with this it would be a great start to preparing
this daily document for import into a financial system that I need to work
with.
Thanks,
moving data from one cell to another).
My 1st challenge is "how to automatically delete blank cells in any given
row" (this is spermatic throughout the worksheet)
Example: when cells in columns A and B are blank then delete that
row.
My 2nd challenge is "how to move data from once cell to it's adjacent cell"
(this is also spermatic throughout the worksheet)
Example: Move cell Data ONLY from column C into column B of the
same row
If anyone one can help me with this it would be a great start to preparing
this daily document for import into a financial system that I need to work
with.
Thanks,