Thanks harald,
Once I record the macro as I am creating the spreadsheets, how do I automate
this process? Please help. Thanks..

"massa" wrote:

I have a spreadsheet that I update on a weekly basis and I am trying to
automate this process. It consists of 3 sheets of reference data and a pivot
table based on the data. Each week I get additional data and would like to
create a macros that will automate this process. Can someone advise where
too begin?
Thanks!
Amy