Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a pivot table from different sets of data using a macro
Hi,
I'm trying to create a pivot table from an external text file using a macro. The data always has the same number of colums (12), but the number of rows varies. This is a problem - when I record the original macro the data range for the pivot table is stored in it. When I try to run the same macro on a data set with a larger number of rows, all data after the final row indicated by the original data set is ignored. Any suggestions greatly appreciated. Thanks in advance...... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a pivot table from different sets of data using a macro
instead of
worksheets("Sheet1").Range("A1:Z200") use Worksheets("Sheet1").Range("A1").CurrentRegion -- Regards, Tom Ogilvy "Éidhne in Ireland" wrote in message ... Hi, I'm trying to create a pivot table from an external text file using a macro. The data always has the same number of colums (12), but the number of rows varies. This is a problem - when I record the original macro the data range for the pivot table is stored in it. When I try to run the same macro on a data set with a larger number of rows, all data after the final row indicated by the original data set is ignored. Any suggestions greatly appreciated. Thanks in advance...... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I detail Pivot Table data without creating a table (Excel2007) | Excel Discussion (Misc queries) | |||
How can I detail Pivot Table data without creating a table (Excel2007) | Excel Discussion (Misc queries) | |||
Why do I get invalid data source when creating a pivot table? | Excel Discussion (Misc queries) | |||
Creating a Pivot Table with data in more than one worksheet | Excel Worksheet Functions | |||
I am having problems creating pivot table of data | Charts and Charting in Excel |