Some data changes
Hey NoSparks,
I tested the code and although it ran perfectly against the example data that I provided, the actual data file has a few subtle differences that seem to effect how the code runs.
1) The merged headers are not merged anymore (merge happens later in the code after all editing is completed)
2) Data contains negative values, not just positive values
3) All month columns now contain values, blanks are now zeros.
4) I've added helper data to all actuals rows in column AD as part of my report build so no need for your code to add the "A"s to actuals rows.
I've attached a better example file, can you take a look and see what needs to be updated in the code as a result of these changes? Thanks so much for your continued help. I feel like we're really close to a solve here.
|