Subtotal copy down data

[jlang11]

Hello, I did search but didnt really find what I am looking for. I have a sheet that I am writing several macros for. I am subtotaling the sheet, and need to fill in the empty cells from above in columns A and B down to the empty "Total" line. Ultimately I will be deleting any rows where the word Total does not appear in column C as I just need the total line for a pivot table. Attached is a sample but it will be much longer. sorry I cannot download the XL2BB

 

[awoohaw]

What version of excel are you using? (Please update your profile with your version. This will help the forum give you the best solution - as well as not waste anyone's time.)

Do you require a VBA solution? Can you use formulas on a different worksheet or area of your workbook?

What do you want to fill in the blank cells? You can Select columns A and B, press F5, Find Special Cells, Find Blanks, Click OK, don't click any where, but type your formula you want in each cell If it is a consistent value and press Cntrl Enter. And it will populate those blank cells.

 

[jlang11]

What version of excel are you using? (Please update your profile with your version. This will help the forum give you the best solution - as well as not waste anyone's time.)

Do you require a VBA solution? Can you use formulas on a different worksheet or area of your workbook?

What do you want to fill in the blank cells? You can Select columns A and B, press F5, Find Special Cells, Find Blanks, Click OK, don't click any where, but type your formula you want in each cell If it is a consistent value and press Cntrl Enter. And it will populate those blank cells.

Thank you! (Version 365) I prefer VBA because as mentioned I am incorporating this macro with several others to format the report into the final product to save myself and others time. I am already moving columns right, deleting unneeded columns, formatting, subtotaling, then this code will be there, deleting rows without the word "Total" and then a pivot table.

I would like to fill the blank cells in A and B with the data above. A3:B3 should contain what is in A2:B2. A5:B5 with the contents of A4:B4. When there are more than 1 row of data as in rows 5 and 6, the data is the same so copy down row 7 to row 8.

Im just drawing a blank with this one as its been a long day.

 

[awoohaw]

Well, record a macro with the F5 procedure I outline above and you can edit it to be redundant.
I'm not a VBA guru at all.