Hello, I' m new here and my question is about creating new excel file and sheets in it from existing list in other excel sheet. Macro has to create new file always when it finds letter "A" in the left column, beside that list. Also first sheet in that new excel file has the table which has to be coppied from another excel file, and all next sheets have the table which is different from the first one, but also must be coppied from another excel file. Some cells in new excel files have to be connected with cells in first excel file (file with the list). Then some information and data have to be entered in that new files and sheets and when that job is being finished, all of data have to be coppied back in excel file which contains list (first mentioned), in dropdown of that list (with order like in list).
Create new excel file and name sheets in it from existing list