Hi All,
I have created a Macro to for below.
A)I have Codes on Sheet 2
B) Source data on Sheet1
C) Set filter in Sheet1, filter the data in sheet1 based on the codes on sheet2, copy data and paste it in Sheet3
However, am facing following problems.
A) Header row is not copied and pasted
B)Initially it has to filter the data for the first code in Sheet2 and paste it in Sheet3 and later it has to set filter for second code and copy past so on.
Could you please check the code and make changes.
Please Login or Register to view this content.
Bookmarks