Hi - I have an export that exports a report into excel sub-grouped into weekly buckets.
I need to put a calculation in where the "1/01/1900" date appears to calculate the percent of the two subtotals before it like it does daily. So instead of "1/01/1900" i would need to say =(23.21/101.25) for the "1st Week" and follow suit for the "2nd Week" and so on.
I would also like to clean up the repetitive data in the first 2 columns. This can vary by number of dates that exist with a possibility of 1-5 consecutive groups of dates. Ultimately i would like it to look like the following:
I have multiple worksheets on my export with the same format, so i would like to run the macro across all worksheets.
Any help would be much appreciated
Thanks for reading!