I've got several spreadsheets where I have a list of dates and balances in Columns A & B, however column A doesn't contain all the dates. I need a macro where I can insert additional rows between cell where there is a value in Column A. In addition to this I also need these inserted rows to be populated with date in Column A (Target Data V1 - so that column A runs sequentially from start to finish with no omissions or gaps), and the balance value in Column B to the populate any blanks with the value from the previous row (Target Data V2).
I can figure out how to insert rows, but not the correct number based on the differences in the value between 2 cells.
Anyone offer any suggestions?
Bookmarks