I have code that pulls data into a file from CSVs. That data contains rows of Totals and Grand Totals.
Total for Mixed Drinks A-L
Total for Mixed Drinks M-Z
Grand Total for Mixed Drinks
Total For Draft Beer
Total For Bottled Beer
Grand Total For Beer
After my import macro runs, I want to take all the "Total for" rows and put into Column C, adjacent to each record. I want to take all the "Grand Total for" rows and put into Column B, adjacent to each record.
I will be deleting the text "Total for" and "Grand Total For", so if this can be removed within the macro, that would be great. I do not need the actual totals values--just the text, i.e., "Mixed Drinks" and "Beer". These labels may change, so they can't be defined.
After these are moved, all "totals" and "grand totals" rows and all blank rows should be deleted. I can do that myself unless it is simple enough to incorporate into this macro.
Files are at www.annetroy.com/ee
and the file that has data imported is revandcats.xlsm.