Hello all,

I am hopeless when it comes to macros and so would request your kind assistance.

I am not sure how to attach a workbook in this board so have resort to the text method. There are 4 worksheets namely; Delhi, Jaipur, Delhi -Core & Jaipur Core. Column A contains - Ref, Col. B contains - Product Name, Col. C contains - Product Category, Col D & E contain Dates for Last Dispatched and the next disp. date respectively. All sheets contain the similar data.

I am doing a project which requires me to :
1/ filter data on the 2 seperate worksheets named Delhi & Delhi-Core on basis of one criteria of col. c e.g. Metals in my example.
2/Copy the filtered data into a new excel file and name the sheet as say "TEXT 1". Delete columns D & E
3/ Repeat the points 1 & 2 for the sheets named Jaipur & Jaipur-Core for the same criteria and paste into the next worksheet of the new created one as per point 2 and rename it as "Text 2". Again delete columns D &R

Can any of you techies out there help me please

Heavily relying on you folks for a solution to this please.

Thanks