Andrew Kedem
New Member
My name is Andrew. It’s been about 5 years since I’ve had a question for this awesome user group. Since then, I’ve moved from the Middle East and landed in the Pacific Northwest in the USA. And from high tech to a firm helping the elderly with their finances.
I pull an invoice report in Excel from proprietary software that I need to manipulate before importing into QuickBooks.
Please help me create a macro to do the following (sample file attached):
For any row in which cells in column E, L and M are blank, I need to copy the data from the cells in the row directly below, also of cells in column E, L and M.
Looking at the attached file, Rows 2, 11, 26, 37, 87 and 107 have no data in cells in columns E, L or M.
These rows where those cells are empty are highlighted in (blue/gray).
Example:
Row 2, column E should have Row 3, column E’s data: Crowe, Misae
Row 2, column L should have Row 3, column L’s data: 26
Row 2, column M should have Row 3, column M’s data: Administrative – Client – time
Who could write a macro that will copy and paste the data in the empty cells (column E, L and M) into the empty cells directly above?
More detail:
If 2E (Row 2, column E) is blank, then copy 3E and paste in 2E
If 2L is blank, then copy 3L and paste in 2L
If 2M is blank, then copy 3M and paste in 2M
etc., doing the copy-and-pasting for all blank cells in columns E, L and M.
I appreciate any and all help.
Warmly,
Andrew
Short Example:
I pull an invoice report in Excel from proprietary software that I need to manipulate before importing into QuickBooks.
Please help me create a macro to do the following (sample file attached):
For any row in which cells in column E, L and M are blank, I need to copy the data from the cells in the row directly below, also of cells in column E, L and M.
Looking at the attached file, Rows 2, 11, 26, 37, 87 and 107 have no data in cells in columns E, L or M.
These rows where those cells are empty are highlighted in (blue/gray).
Example:
Row 2, column E should have Row 3, column E’s data: Crowe, Misae
Row 2, column L should have Row 3, column L’s data: 26
Row 2, column M should have Row 3, column M’s data: Administrative – Client – time
Who could write a macro that will copy and paste the data in the empty cells (column E, L and M) into the empty cells directly above?
More detail:
If 2E (Row 2, column E) is blank, then copy 3E and paste in 2E
If 2L is blank, then copy 3L and paste in 2L
If 2M is blank, then copy 3M and paste in 2M
etc., doing the copy-and-pasting for all blank cells in columns E, L and M.
I appreciate any and all help.
Warmly,
Andrew
Short Example: