Project Anyone?
Can a macro do this for me?
On my database sheet in Col F5:down I have sheet names listed. Can a macro copy data from other columns and insert it into the specific sheets listed in column F but only if B is blank:
I'll need:
col C:D copied to B:C on specific sheet
Col H:M copied to D:I on specific sheet
Then,
col O copied to either J,K,L,M
depending if col N in database sheet = 1,2,3,4
Then filldown the formula in Col O on specific sheet.
Other things that make this seem impossible.
I need to have the data inserted in blue before the total line on each sheet.
I need to record the date when the data moved in col B on the database sheet. So that next time I run the macro It will only move data that has not been moved.
I attached a before and after.
Thank you for any help.
Bookmarks