Hello Experts,
I need help on the below
Lets say there are 2 different workbooks :
1 is Raw data workbook with only 1 tab or worksheet called Main Data
1 more workbook where i have or want the code and has only 1 worksheet named Mail Info
Requirement 1 :
In Mail Info workbook Column A ( A2:A50) i have a list of names like Bob, Jack, John, Sibu etc and Cell C7 has a drop down list with reference to column A (A2:A50)
In Raw data file, say i have columns Plan A, Plan B, Email, Plan C, Notes etc., Column Email has different names ( Bob, Jack, John etc)
In Mail Info file, Cell value C7 says Bob, then data related to Bob in the Raw data should be filtered along with formatting (as few of the cells will be colored) and should create a new folder called Bob ( with value in cell C7) and save as a new workbook ( raw data file has only 1 worksheet/tab) in that folder. If folder already exists only file should be saved in the respective folder.
Requirement 2:
In Mail Info file, cell value C7 says ALL, then what ever unique names available under Column Email of the Raw data file ( say there are 10 unique names) data to be filtered for all the unique names accordingly and 10 unique files and folders to created and saved accordingly.
Save as each file or workbook with unique name given under email column
I tried to put requirements as clearer as i can.
Apologies for not able to share the sample file.
Thank you so much for the support.
I need help on the below
Lets say there are 2 different workbooks :
1 is Raw data workbook with only 1 tab or worksheet called Main Data
1 more workbook where i have or want the code and has only 1 worksheet named Mail Info
Requirement 1 :
In Mail Info workbook Column A ( A2:A50) i have a list of names like Bob, Jack, John, Sibu etc and Cell C7 has a drop down list with reference to column A (A2:A50)
In Raw data file, say i have columns Plan A, Plan B, Email, Plan C, Notes etc., Column Email has different names ( Bob, Jack, John etc)
In Mail Info file, Cell value C7 says Bob, then data related to Bob in the Raw data should be filtered along with formatting (as few of the cells will be colored) and should create a new folder called Bob ( with value in cell C7) and save as a new workbook ( raw data file has only 1 worksheet/tab) in that folder. If folder already exists only file should be saved in the respective folder.
Requirement 2:
In Mail Info file, cell value C7 says ALL, then what ever unique names available under Column Email of the Raw data file ( say there are 10 unique names) data to be filtered for all the unique names accordingly and 10 unique files and folders to created and saved accordingly.
Save as each file or workbook with unique name given under email column
I tried to put requirements as clearer as i can.
Apologies for not able to share the sample file.
Thank you so much for the support.