I receive a daily spreadsheet (see attached - Received tab) where some of the cells have a combination of a column header and the headers value all in once cell. There are cells that contain the header called "Rep" along with the Sales Rep name all in once cell. I need to when this situation is found is to fill in the value of the Sales Rep forward until a non-blank cell is found within that column.
Also I would like to fill in 2 columns with the report date and report time in columns that would be next to "REP", "Invoice#", and "Amt". Currently the Report Date and Report time is always found at the upper corner of the report.
See the tab called "Post-Macro" which is what my hopeful output would be...
I know how to loop thru excel, I just don't know how to within a loop take a value from a prior cell and fill down to a non-blank cell. If you at minimum could reference me to a similar post that would be great as I assume this type of situation must happen all the time.