Do those steps in Excel with the macro recorder on, you will get the code.

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