Hello, I am hoping that someone might be able to give me some guidance here today.
Would something like this even be possible now with VBA, or am I dreaming when I think that this could be done....
First, on my sheet Summary delete all rows active rows on this sheet after last row in PivotTable1
Next, the same sheet Summary determine the first available empty row (skip 3 more)
Then look in cell B1 on sheet Summary, and in this blank row from above below copy over all rows from sheet AllData where B1 = same value in Column C on AllData sheet (also copy over header row 1)
Would something like this even be possible now with VBA, or am I dreaming when I think that this could be done....
First, on my sheet Summary delete all rows active rows on this sheet after last row in PivotTable1
Next, the same sheet Summary determine the first available empty row (skip 3 more)
Then look in cell B1 on sheet Summary, and in this blank row from above below copy over all rows from sheet AllData where B1 = same value in Column C on AllData sheet (also copy over header row 1)