| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use the same macro for different sets of data?
Hi,
I am trying to use a macro at the moment to order data i retrieve off of a database. I can run the macro for the data i used to record the macro, but not when i try to use a new piece of data. It just reverts back to the data i originally recorded. I would be very grateful if anybody could help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I use the same macro for different sets of data?
You will need to edit the macro that you recorded to make it generic. Look at the code using ALT-F11 to start with. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=560796 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro pulling data from 2 worksheets | Excel Discussion (Misc queries) | |||
| How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Linear Mode
