a_chaitanya
03-14-2021, 02:10 AM
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...28101
https://www.excelforum.com/excel-programming-vba-macros/1344030-autofilter-in-multiple-sheets-copy-sheets-to-new-workbook-save-workbook-with-a-field.html#post5487310
https://www.mrexcel.com/board/threads/autofilter-in-multiple-sheets-copy-sheets-to-new-workbook-save-workbook-with-a-field-name.1164852/
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...28101
https://www.excelforum.com/excel-programming-vba-macros/1344030-autofilter-in-multiple-sheets-copy-sheets-to-new-workbook-save-workbook-with-a-field.html#post5487310
https://www.mrexcel.com/board/threads/autofilter-in-multiple-sheets-copy-sheets-to-new-workbook-save-workbook-with-a-field-name.1164852/