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

[anchuri_chaitanya]

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...

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Autofilter in Multiple sheets - copy to new workbook - save workbook by field name
and Autofilter in Multiple sheets - copy sheets to new workbook - save workbook with a field
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[anchuri_chaitanya]

Hi Fluff,

Thank you and my apologies for not following the rule. I have updated in other places and missed here updating those links.

For sure will follow the rules and once again thank you for correcting here.