Quote:
|
On the Original Grocery List tab, is it wise that I added borders all the way to row 20,000
|
Nope. better make your existing range an
Excel Table (using PQ this will already have been done) and use it as source for your Pivot Table.
Each time you add data, just refresh your PT, and it will adapt
Quote:
|
I added the date entry (9/2/24), but not sure what I did wrong. It's not in ascending date order on Original Grocery List tab and I inserted rows above 9/9/24.
|
This should have been taken care of with the above
Quote:
|
Should I delete the sub totals tab? I don't need that now that I have the pivot table, right?
|
Yes