Hi

the Relative Reference button is on the Stop Recording TOOLBAR which should
come up when you press OK after entering the macro name into the dialog box.
If the toolbar doesn't come up (only two buttons on it, the stop recording
one and the relative reference one), then choose view / toolbars / stop
recording and then you will see it.

macros are probably the way to go to do what you want ... there have been
questions on this topic in the past and people have posted sample code .. so
you might like to do a search at groups.google.com and see if you can find
these past posts.

Cheers
JulieD

"Macro Insite" <Macro wrote in message
...
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?