I have a Main Workbook with multiple worksheets. After certain cells are completed on the "Set-Up" worksheet, I would like to do the following: (A) automatically move out three (3) different sheets to new individual workbooks and save them in a specific location, (B) Copy five (5) sheets to a new workbook and save them in a specific location and then delete only three (3) of them from the original workbook, (C)
__________
(A) The first three workbooks are named "Doc List", "Quals", "RFI Log". I would like for these to be moved, saved to individual workbooks and deleted from the Main Workbook.
I would like to create a VBA that allows me to create a checkbox on the Set-Up Tab of the Main Workbook that the user can click on to move each of these files out of the Main Workbook only if cells C6, C7 and C10 are not blank.
I would like an individual checkbox for each of the three (3) tabs.
I would like the like the files to be saved with the following name on the user's desktop (C:/):
(1) Doc List
(2) Assumptions and Qualifications
(3) Turner Precon RFI Log - Current
______________
(B) The next five workbooks are named "DO NOT EDIT or DELETE", "BID LIST - To be Copied", "Gen. Project Info", "Trade Scope", "Scopesheet". I would like for these to be copied, saved to one workbook and then delete only the sheets named "Gen. Project Info", "Trade Scope", "Scopesheet" from the Main Workbook.
I would like to create a VBA that allows me to create a checkbox on the Set-Up Tab of the Main Workbook that the user can click on to perfom the action above only if cells C6, C7, C10, C12, C13, C15, C16, C17, C18, C21, C44, C46, C50, C51, C52, C53, C59, C110 are not blank.
I would like an single checkbox for this action.
I would like the like the files to be saved with the following name on the user's desktop (C:/):
(1) Scopesheet - Template
Please help!
Bookmarks