If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multi tab Workbooks
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 |
#2
|
|||
|
|||
Multi tab Workbooks
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 |
#3
|
|||
|
|||
Multi tab Workbooks
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 |
Thread Tools | |
Display Modes | |
|
|