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.


--
Mike @ Contractors

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.

--
Best Regards,

Luke M
"MBozeman" wrote in message
...
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.


--
Mike @ Contractors

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


"MBozeman" wrote:

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.


--
Mike @ Contractors