Multi tab Workbooks
in [Functions]
|
Prev: Can I have the right formula to list all my agencies under country
Next: Offset to ignore hidden cells not working in 2007
From: MBozeman on 8 Mar 2010 12:55 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
From: Luke M on 8 Mar 2010 13:06 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" <Contractor(a)elmore.rr.com> wrote in message news:5E93DF22-B312-4055-9190-D3E109D75504(a)microsoft.com... >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
From: Eva on 8 Mar 2010 13:22
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 |