Hi Amy

Best beginning is to record a macro while doing the process manually.

Best wishes Harald

"massa" wrote in message
...
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