How can I use the same macro for different sets of data?

D

Dean

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?
 
M

mrice

You will need to edit the macro that you recorded to make it generic
Look at the code using ALT-F11 to start with
 
Top