Hi I have inherited some files that will need to be updated monthly. The data is sales information. The problem is it has gaps in columns and rows that need populating. I have tried using a DO/Loop statement with ActiveCell to do this but can't get the logic right. I have attached a spreadsheet with a dummy example of before and after. Accomplishing this with code will save me hours of work each month.
As you can see my code is flawed but hopefully you can see what I am trying to accomplish.
If anyone can help I would be really grateful.
Bookmarks