I have a database formatted as the attached spreadsheet. What I would like to do is to run a macro (if possible) that takes each cell with a value and duplicates it below itself, if the following cell is blank. There are some instances where there are multiple blank cells, and I'd rather not have one cell duplicated in each 4 blank cells, which is what has been happening when I've been using a copy/paste method. I've been using "=B3" in B4 to refer to the cell above it, and just copying and pasting that in all blank cells, which I've filtered out. I have to do this in column B, and then move over and do this in columns F, G, etc., to duplicate all the data that was in the cells above. This works for the most part, but takes longer than I'd like it to when some workbooks have 3,000 rows of data. It also causes the problem of duplicating data in more than one cell, which should not take place. (Does that make sense?)
I've run a macro already that will add the second row after each row already present. Is there a way to simply duplicate each row after this stage, thus resulting in a blank row after every row?
Hope that make sense!
Thank you,
Ashley
Bookmarks