I am trying to create a pivot table on a workbook that I add a new worksheet to everyday. Each worksheet needs this pivot table added to it. What is the best way to to start the code and how do I make sure that I can use this code on future workbooks?
I have attached a new workbook I created for the next batch of information.
I have just started experimenting with VBA and the Macro record in Excel helps a little but still a little confused on how to incorporate the fact that each worksheet could vary in the number of records. Any help or pointing in the right direction would be greatly appreciated!!!
Thanks!!!
Bookmarks