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