I need to add a new column following each time "Total_Billed" appears in the first row. The new column needs to be named "Store Ref" and the 4 digit number that appears in each of the 3 column headers that appear to the left of the new column needs to be filled into the new column up until the last active row. This needs to be dynamic as the size will change with different files.
Then the first 3 rows need to be appended 21 times (not including the column headers). Each set of count, applied amount, total billed, store ref need to be appended to the first set (not including the column headers).
When it is finished the final product will have a total of 7 columns. It will have 20*20 = 400 rows + 1 header row.
The appending of the columns need to be dynamic as the # of discounts vary frequently.
Please take a look at the sample as its much easier to visualize. Basically I need to create a table that has a better format.
This needs to be completed with a macro!
Solved by E. S. in 30 mins