Anne Troy
asked on
Put Totals / Grand Totals data in adjacent columns.
I have code that pulls data into a file from CSVs. That data contains rows of Totals and Grand Totals.
For instance:
Total for Mixed Drinks A-L
Total for Mixed Drinks M-Z
Grand Total for Mixed Drinks
And:
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.
For instance:
Total for Mixed Drinks A-L
Total for Mixed Drinks M-Z
Grand Total for Mixed Drinks
And:
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.
ASKER
I'm so sorry! www.annetroy.com/eeq
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
O
M
G
I thought this was going to be really tough to get. I cannot thank you enough!
M
G
I thought this was going to be really tough to get. I cannot thank you enough!
404
Not found