I have spent weeks creating a table and it finally works. I need some help
in conpying over the formulas from the test sheet I worked on into the real
document. See below for a synopsis of what I did and what I need to do.

I get a report with a bunch of data. Some I don't need.
I am creating a macro to pare down the data to just what I need.
For this purpose in the macro, I import a table from a pre-existing
worksheet to do a vlookup and then just paste the values into a a new cell.

what I am trying to do is import the table I created (complete with
formulas) into the report and have everything line up.

Maybe I didn'e make it clear enough, if you have questions, pleas post back.

Thanks
Jeremy