excel processing

[Guest]

I am describing what I am doing weekly since I would like to automate the
following process. is there some kind of a script that can be saved that
would remember my key strokes and/or some other way to automate this process/

Right now I run queries on sql server and copy and paste the results into
excel spreadsheets. I copy the detail information from sql server into the
excel spreadsheets and I also right click on lots of pivot taboles so that
the data is updated in the pivot tables.

Thus let me know if this can be automated and how to automate this process.

Thanks!

 

[Guest]

Very easy:

1. turn on the Macro Recorder
Tools > Macro > Record New Macro

2. perform your tasks once manually

3. turn off the Macro Recorder
Tools > Macro > Stop Recording

The Recorder will record your actions. The resulting macro may require a
tiny bit of tweaking.

For more information on macros, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm