Thread: update a Pivot Table with new data added to the base data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graham Y Graham Y is offline
external usenet poster
  
Posts: 66
Default update a Pivot Table with new data added to the base data
I have a macro that collects lots of data from four sheets and re-arranges it
so it is suitable for a pivot table. I have the pivot table, but I want to
make sure if my data grows that the new rows are picked up by the pivot
table. How can I set the data range used by the pivot table from my macro?
Reply With QuoteReply With Quote