Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel processing
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel processing
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 -- Gary''s Student - gsnu200731 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Processing Data | Excel Worksheet Functions | |||
Excel limit that stops pivot table processing at column IV?? | Excel Worksheet Functions | |||
Reduce processing load in Excel | Excel Discussion (Misc queries) | |||
data processing | Excel Discussion (Misc queries) | |||
Conditional Processing | Excel Discussion (Misc queries) |