I am trying to create a Pivot Table that uses data that is in a different sized Range every day. For example the range may be 1000 rows long and 25 columns wide one day and then be 1100 rows long and 26 columns the next day. I want the pivot table to update automatically without me having to amnually redo the Pivot Table every day. I know that there is a way to do this and it involves using the functions "counta" and "offset" but I have not been able to piece them together. Any suggestions.
Thanks
Bookmarks