henryvii99
New Member
- Joined
- Apr 22, 2011
- Messages
- 32
Suppose I have a master workbook with 3 tabs
"Master", "Quotation" and "Order"
When I fill information in "Master" tab, forms will generate in the two tab.
After that, I have to copy tabs to another workbooks,
say "Quotation 2018.xlsx" and "Order form 2018.xlsx" (they are in the same folder as in master workbook)
And rename the tab as date (e.g. 20180907)
Also, I have to copy and paste as values in the destination worksheets to remove the formulas.
Is there a VBA script to do this? Create a button in the "master" tab and BOOM
I can enter filepaths and the new tab name in the "master" tab.
BTW workbooks for quotation and order form are password protected, but I can open them beforehand.
Many thanks for your help!
"Master", "Quotation" and "Order"
When I fill information in "Master" tab, forms will generate in the two tab.
After that, I have to copy tabs to another workbooks,
say "Quotation 2018.xlsx" and "Order form 2018.xlsx" (they are in the same folder as in master workbook)
And rename the tab as date (e.g. 20180907)
Also, I have to copy and paste as values in the destination worksheets to remove the formulas.
Is there a VBA script to do this? Create a button in the "master" tab and BOOM
I can enter filepaths and the new tab name in the "master" tab.
BTW workbooks for quotation and order form are password protected, but I can open them beforehand.
Many thanks for your help!
Last edited: