exitsing table copying into new workbook
 

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

exitsing table copying into new workbook
 

If i understand you correctly, you can copy the sheet to the new workbook but
all of the formulas will reference the old workbook. If this is your issue
select Edit from the menu bar, go to Links and you should see where the links
are to the other workbook, you want to update the links, when it asks you
what to update them to, point to the new workbook and as long as sheet names
are the same etc all should work just fine.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Jeremy" wrote:

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

exitsing table copying into new workbook
 

i copied everything over, anbd the links option is greyed out?

"John Bundy" wrote:

If i understand you correctly, you can copy the sheet to the new workbook but
all of the formulas will reference the old workbook. If this is your issue
select Edit from the menu bar, go to Links and you should see where the links
are to the other workbook, you want to update the links, when it asks you
what to update them to, point to the new workbook and as long as sheet names
are the same etc all should work just fine.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Jeremy" wrote:

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