Autofilter in Multiple sheets - copy sheets to new workbook - save workbook with a field

Hi,

I have gone through many posts and could not make it on own on the below for what i am looking for.
looking for help in the below...

Having three sheets in a workbook,
> Filter Emp IDs in each sheet - Emp IDs in each sheet will be in different column
> Copy visible data of all sheets to a new workbook - sheets should be same from the working file to new workbook
> Save the file with the EMP ID from the First sheet
> iterate the above for all the emp ids in the first sheet.

Appreciate on your help...

My apologies for not able to attach file and would request if some one can help me with the attaching file.

Also, posted in the below forum
https://www.mrexcel.com/board/thread...-name.1164852/
http://www.vbaexpress.com/forum/show...ht=#post408000

Put macro in Module of a backup of main file and run.

Please Login or Register  to view this content.

Hi Kenneth,
Thanks a ton for the code and help.
As guided, i have put the code in a module and ran. However, it thrown me an error at line

Please Login or Register  to view this content.

vba run-time error 2146232576 (80131700)

Any help on this please... do i need to enable any references from Tools.

Hi Kenneth,

Searched the error code and find that .NET wireframe to update. after download and installing .NET wireframe the below error is gone and the code is just worked fine.

vba run-time error 2146232576 (80131700)

https://www.microsoft.com/en-in/down...lforq1r6k1yg00

Thank you so much for the code!

Hi Jindon,

Your code too worked perfect and thanks for the needful.

Hi,

My apologies for another ask in this filtering out and creating individual sheets.

Is it possible to have multiple filter in the sheets based on the selections in from another sheet and generate the individual files.

Here, instead of only Emp ID now have to filter on other columns/fields as well. These filters will be same in all the three sheets but different columns numbers.

Attaching here with the excel file and First sheet i have mentioned the need.

Would request for help.

Hi Jindon,

Code working fine without any issues. Generating all EMP files.

My need of generating files individually based on the filters in the sheet4 and save the files with EMP ID+MonthName+Department.
Attached here with few files and as per the selection in filters is only Department as IT.
For IT department - all Months - Emp ID ALL -
1. Files to generate as - in the summary sheet data only IT department records to filter - for all months (as monthwise is selected as ALL in sheet4) - files to generate for each EMP in IT department.
2. likewise, if selected 3/15/2021 in month wise - and - ALL in department - then - filter 3/15/2021 records in summary sheet - department filter will not take any value as the value for department in sheet4 is ALL and generate files for each EMP
3. similarly, the combination of the three fields in sheet4.
Am sorry if the above is not clear and would request you to let me know in case of anywhere that i am not clear.
Thank you.

Hi Jindon,

That is because of more than one month - this is due to the selections as below in Sheet4 for
Monthwise = ALL
Department wise = IT
EMP ID = ALL
as per the above selections in sheet4, having two employees for IT department and for all months - 11111 has two records for all months in summary sheet column E and similarly for 55555.

If the above is confused and is it possible as per the below scenario to generate files...
Monthwise = ALL
Departmentwise = ALL
EMP ID = ALL

then for each month and department wise emp id in the filtered to generate files
EX:
there are two values in the month column = so two times filter
month column filter followed by department column having 4 values = four times filter
and for each employee filter - generate files

if the sheet4 values selected instead of ALL as below then only to generate the selected values related file
Monthwise = 3/15/2021
Departmentwise = IT
EMP ID = 11111 - generates only 11111 related file for the month record 3/15/2021 and department is IT
or EMP ID = ALL - then all the emp id files related to monthwise 3/15/2021 and department IT will only to generate.

Extremely sorry for the confusion you had with my queries as i am not that good at writing. Please consider.

Hi Jindon,

Thank you so much and yes, will be careful while posting.

Any support please...

i have posted as a separate thread for looping through data validation filters and filtering multiple sheets to generate individual files and would request for any help please.
http://www.vbaexpress.com/forum/show...files&p=408131

i am closing this thread with solved as Kenneth and Jindon had helped out for the initial requirement i posted.

Thank you so much for the needful in helping out on the initial ask.

Any guidance on iterating dropdown values to filter multiple sheets will help.