Suppose I have Workbook(Report.xlsx) and in that workbook I have different worksheet. In every sheet I have a column name B_Code. Using filter in B_Code I want a separate workbook with every sheet in it.
Just like in Picture 1 you can see Sheet 1 has B_Code.
Similarly in Sheet 2 also I have B_Code in it.
Now I want the data of 001 i.e. Ram in Sheet 1 as well as in Sheet 2 in same workbook as file name 001 and 002 i.e. Hari in Sheet 1 as well as in Sheet 2 in another workbook as file name 002 and so on.
Can anyone help me out to solve this problem using VBA.