Required Column and Filtered data to be copied in a new sheet

Hi Team,

Need your help on this !!!

I would like to copy the selected columns and the filtered data to be coplied into a new sheet.

let me explain in detail, i have attached my "working sheet".

1. In the attached "working sheet" : i have the complete data contains 10 columns (sheet name: "Details") which i copy from a different source manualy.
2. i want to copy the selected columns data by having some data level filter and copy the data in to a new sheet
A. Following are the selected 8 columns data to be copied in a new sheet:
ITEM#
ITEM TRACK
ITEM DESCRIPTION
PLAN DETAILS
ITEM READY FOR ST
ITEM READY FOR GO LIVE DATE
ITEM CURRENT DETAILS STATUS
REMARKS

B. while copying the above 8 columns details into a new sheet , following are the filters i have to apply:

ITEM TRACK column -- Do not consider "INTERNAL"
PLAN DETAILS column -- Consider only (Baselin , Actual , Plan)
ITEM CURRENT DETAILS STATUS column -- Do not consider "06.Cancelled Request"

3. The resulted data i have copied into a new sheet "Filter Data" .

Can you please help me in automating this activity, as my data set is huge and i always do this manually. would help if you can use macro and get this automated.

Kindly let me know if you need any additional information from my end.

Regards,
Kamal.

Hi Sktneer,

i was trying to modify the code shared by you but i am getting success in copying the data in to "Filter Data" sheet by applying the required filters.

but i am unable to copy the required columns data from "Detail" sheet to "Filter Data" .

i am attaching my final columns in "Detail" Sheet and required columns in the "Filter Data" sheet. Can you please help me on this.

your help would really help me in automating this manual activity.

Regards,
Kamal

Thanks a ton Sktneer.

Your solution is picture perfect to my requirement. it helped me in learning new things from your end.

Thanks once again.

Kamal.

Hi sktneer,

i am new to this site, so not sure how to mark this thread as SOLVED. if you can help me in this then i am happy to mark this thread as SOLVED.