Creating a macro
I am a new macro user. I have read the tutorials but cannot get the macro to
work. I use Excel 2000. Each time I run the macro it wipes out earlier
data. Part of the problem is trying of use the relative reference function
that my help guide says I get to by clicking on the Stop Reconding button.
However, I don't see any reference to Relative Reference. I am trying to use
the macro to take data (a long list of names and addresses) that is listed
vertically in excel and re-set it horizontally in separate cells. Are macros
the way to do this or is there a different way?
|