Multi tab Workbooks

  • Thread starter Thread starter MBozeman
  • Start date Start date
M

MBozeman

I have a workbook with several tabs that feed data from tab 1{Data Entry}.
Tab 5 needs to be sent to the supplier and needs to be a spreadsheet that is
in their specific format so that they can upload it without additional data
entry . I need to be able to send "orders" to that vendor by sending them
their spreadsheet with my data.

The Dilemma: If I place formulas in my Tab 5 and it fills in the Data from
my Tab 1 and I try to send just a sheet that is now my Tab 5 to my vendor the
"data" does not send; only the formulas send that refer to a sheet that their
system cannot deal with. Is their a way for me to build another tab or sheet
that is nothing but the literal result of the formulas from my tab 5? I only
need to send them the data in their format, I cannot send them my formulas or
lookups that placed it on Tab 5.
 
Either manually, or setup a macro, copy all the data in Tab 5 and paste
special - values only.

Alternatively:
Copy tab 5 to a new workbook, and then goto Edit - Links - break links.
 
Hi
Click on your tab and choose move or copy then click create a copy and OK.
Then highlight all cells in your new sheet, click copy then paste special
=>values.
You can send this tab and it is not linked to anything.



--
Please click "yes" if this post helped you!

Greatly appreciated

Eva
 
Back
Top