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