Hi,
I am trying to create a macro to move worksheets in a main workbook to sub-workbooks (divisions within the country). My master workbook has all the individual sheets and the hierarchy sheet with column F listing the worksheet names (some names are duplicated numerous times even though there is only one worksheet with that name which is needed for formulas) and Column E listing what workbook they need to be put in (either West A,West B, Southeast, Central A, Central B, East). I would like the files to be named and saved in a location in my documents. The file name should be the name from column E and Cell n5 (quarter) and cell n2(year) from the hierarchy sheet and then the column E division. Any help on this would be wonderful as this is past my knowledge of macros. Thanks in advance.
Josh
Bookmarks