Importing ever changing data to be used in a pivot table
Posted by Naomi on April 12, 2000 12:29 PM
I am trying to create a pivot table out of imported data, via a macro. My problem: the data is always changing. There will always be three columns, but the number of rows varies from 50 to 2000. Once the data is imported into Excel, how can I automatically have the range of data selected so that the pivot table wizard recognizes what data to use and doesn't ask me for a range?