thriller_1981
New Member
- Joined
- Sep 20, 2006
- Messages
- 2
Good morning..!
Can anybody help?
We collect data from some databases into Excel, the source Excel files are transferred out to a local folder with the macros for creating pivot tables sitting in a separate Excel workbook.
I need the source data range in the macro to be dynamic so it will create the pivot tables successfully regardless of the fact there may be different amounts of rows each time. Will I need to be changing this section..?
(SourceType:=xlDatabase, SourceData:= _
"Q_MySpreadsheet!R1C1:R4723C10")
Help would be greatly appreciated, thanks
Can anybody help?
We collect data from some databases into Excel, the source Excel files are transferred out to a local folder with the macros for creating pivot tables sitting in a separate Excel workbook.
I need the source data range in the macro to be dynamic so it will create the pivot tables successfully regardless of the fact there may be different amounts of rows each time. Will I need to be changing this section..?
(SourceType:=xlDatabase, SourceData:= _
"Q_MySpreadsheet!R1C1:R4723C10")
Help would be greatly appreciated, thanks