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

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" <(E-Mail Removed)> wrote in message
news:CA68FB0A-7A0F-4AF3-A9EF-(E-Mail Removed)...
>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
>