My workbook has 4 tabs - its a master workbook.
In Tab 1 - user inputs 6 fields, based on which, tab 2, 3 or 4 populates.
My Macro should do the following:
If cell G6 in Tab 1 says "Regus",i want the macro to copy & paste tab 2 to a new sheet in a folder New Offices, naming it "Regus_Office_[today's date]"
If cell G6 in Tab 1 says "Small", copy & paste tab 3 to a given folder, naming it "Small_Office_[today's date]"
If cell G6 in Tab 1 says "Medium", copy & paste tab 4 to a folder, naming the new workbook "Medium_Office_[today's date]"
Is it possible that once the user opens copy of this workbook, a print macro is available for them to chose, if they want to quick print?
Ranges for the worktabs content i need to be C&P:
Tab 2 ( called REGUS) C2:F20
Tab 3 ( Small) C3:F69
Tab 4 (Medium) C3:F81
Thanks for you suggestions in advance!!!!!
^_^
In Tab 1 - user inputs 6 fields, based on which, tab 2, 3 or 4 populates.
My Macro should do the following:
If cell G6 in Tab 1 says "Regus",i want the macro to copy & paste tab 2 to a new sheet in a folder New Offices, naming it "Regus_Office_[today's date]"
If cell G6 in Tab 1 says "Small", copy & paste tab 3 to a given folder, naming it "Small_Office_[today's date]"
If cell G6 in Tab 1 says "Medium", copy & paste tab 4 to a folder, naming the new workbook "Medium_Office_[today's date]"
Is it possible that once the user opens copy of this workbook, a print macro is available for them to chose, if they want to quick print?
Ranges for the worktabs content i need to be C&P:
Tab 2 ( called REGUS) C2:F20
Tab 3 ( Small) C3:F69
Tab 4 (Medium) C3:F81
Thanks for you suggestions in advance!!!!!
^_^
