Macro to refresh pivot tables

[mzspazchick]

Hi All,
I need to create a macro that will allow a user to click a button that says "Refresh Data". When that button is clicked I need two worksheets of pivot tables to refresh. Is this possible? I have never created a macro before, or a button.
The user will be entering data into a certain place on a worksheet, then they will be going to another worksheet, clicking the button and waiting to see results. Everything is in the same workbook and all the cell references, formulas, etc are set up, I am just stuck on the button.
I would greatly appreciate any help you can offer.
Thanks,
Michelle

 

[Legacy 51064]

I use this code to refresh all pivot tables in my workbook

Sub Update()

'Refresh all pivot tables
ActiveWorkbook.RefreshAll

End Sub

In the forms toolbar, select the "button" button. Then draw the button on your sheet and select new. Paste the code above into the vba module and press ok. Right click on the button and select Assign Macro and press ok. This should set up your button to use.

 

[mzspazchick]

Thanks 98illini!!! That was simple and painless. I will test it tomorrow when I get my new data.
Michelle