(Get Answer) – Step 1: write a macro that can create one file for
Step 1: write a macro that can create one file for each tab located in workbook “Budget Request Form.xls”. First file would be named “Budget Request Form – Drama.xls”, second file “Budget Request Form – English.xls” etc (I want flexibility if adding tabs or changing tab names, the macro should be able to create one file for each of the tabs located in the main workbook.Step2: after the different files are created, I would like to collect information from these files (let’ say “Budget Request Form – Drama.xls” and “Budget Request Form – English.xls”) into workbook “Submissions – Final.xls”. The data collected is currently in GREEN. One line will be added for each source file in this case we have 2 here. All source files will be located in the same folder. the folder’s name is “Budget – Submissions”.