BullseyeThor
Board Regular
- Joined
- Dec 23, 2010
- Messages
- 84
- Office Version
- 365
Hi All
Please can someone help me with a VBA if it exists.
I have a workbook with 10 tabs for different suppliers. I have the main page as so that the supplier tabs populate I have a page where I can add a full order and it automatically sorts to the correct supplier.
Now to make it easier for me and so I don't have to keep copying a tab to a nex book and sending with all of them. Is there a way that I can input a code into each tab linked to a main button on the first page which can send each tab to the suppliers?? I understand that this sounds complicated but it would really make it easier for my team.
So for the summary.
10 Tabs, indiviual suppliers, main tab/first page, main button on first page embedded with code to send each order to suppliers.
Thanks in advance if this is possible.
Please can someone help me with a VBA if it exists.
I have a workbook with 10 tabs for different suppliers. I have the main page as so that the supplier tabs populate I have a page where I can add a full order and it automatically sorts to the correct supplier.
Now to make it easier for me and so I don't have to keep copying a tab to a nex book and sending with all of them. Is there a way that I can input a code into each tab linked to a main button on the first page which can send each tab to the suppliers?? I understand that this sounds complicated but it would really make it easier for my team.
So for the summary.
10 Tabs, indiviual suppliers, main tab/first page, main button on first page embedded with code to send each order to suppliers.
Thanks in advance if this is possible.
