Start of by using the macro recorder to record the steps done manually. Then
change to relative addressing.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"L Hill" wrote in message
...
I need help creating a macro that reformats my data in excel and places it
on
a new worksheet within the same workbook. It will use relative addressing
so
that it can convert new lines of data. Data must be reorganized before it
can be imported into a database. Thanks for your help