Collate data from 2 spread sheet and enter into master template

[nancymary34]

Hi Team,

I need your help here.

1. I have 2 spread sheet with some data in it which requires some filtering and formatting. i.e. in both spread sheet
a) Delete row A1 to A12
b) Filter col CW and select only "Unprocessed"
c) Filter Col CV and select text filter and choose contain "FX"
d) copy the selected data after above filtering and paste in master template saved in a particular path with file name as "Processed to Unprocessed_currentdate.xls"

Can you please help me to write a VBA code for above.

Thanks and Regards,
Vinni Prasad

 

[nancymary34]

Hi Team,

Can someone please help me as this is urgent request.