I download data from a web site on weekly basis and break information down by branch location and employees assigned to each branch--

Data source will fluctuate depending on new hire employees and those that quit or get laid off.

I used macro recorder to help create this section of VBA to help automate the PivotTable process.

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= "Data!R1C1:R134C4"

Two worksheets exist in this workbook; my data source named "Data" and the new worksheet for PivotTable data that I create in the beginning of the macro named "PT" for the location of PivotTable.

The "R1C1:R134C4" of this code will not always represent the data source each time I download data from the web site. It may contain less rows than the previous week or more depending on how many people we hire. What code can I insert to replace this section of code to include this fluctuation of data rows?

Should I replace code for "TableDestination:="Sheet10!R3C1"" with "TableDestination:="PT!R3C1""?