Adding new data columns in pivot table

[happyzap]

Greetings,
My first question in the great fourm. I have a pivot table, excel 2007, with four columns of data. The table was generated with the macro recorder and it works fine. What I want to do is generate the pivot table after I add more columns in the sheet where the data is pulled from when I click on the button that runs the pivot table macro. When I add the columns the range data in the macro needs to change accordingly. Any ideas? Thanks.

Happyzap

 

[Jerry Sullivan]

In general, you'll want to change source data reference from a specific range of cells, to a dynamic reference.

You can do that by :
1. using the .CurrentRegion property; or
2. using the data range (A1:LastRow,LastColumn) found with .Find method; or
3. using a named range for your Pivot Table source data

If you post your macro, that will make it easier to help you with suggest edits.

 

[happyzap]

JS411,
Thanks for the help. I am not sure what the procedure is to post my recorded macro so being aware of proper protocol I will post it if you would explain the process. Again, thanks for the reply

Happyzap

 

[Jerry Sullivan]

I am not sure what the procedure is to post my recorded macro so being aware of proper protocol I will post it if you would explain the process.

The Formum Posting Guidelines explains how to post your code.
http://www.mrexcel.com/forum/showthread.php?t=515787

Tip #6 in particular explains how to put "code tags" around your code so that it is more readable.

With Code Tags around your code 
   It will look like this
End With 
 
If you indent your code Then
    it will be more readable and _
        you might get more responses
End If