Cut and paste data from raw data to sheet1 and sheet2. based on criteria

[xlhelp7]

Hi All,

Please help!

In sheet raw data i have raw data based on criteria I want to cut and paste data from raw data to sheet1 and sheet2.
criteria1-From raw data to sheet1- data having City(in column o of raw data)- Delhi Central, Delhi Dwarka, Delhi East, Delhi North, Delhi South, Delhi West, Ghaziabad, Greater Noida, Gurgaon & Noida
having property value(in column i of raw data) greater than equal to 40000 and RENT_SELL_LEASE is "R" (in column H of raw data) should copy cut and paste to sheet1.
criteria2-From raw data to sheet2- data having City(in column o of raw data)- Delhi Central, Delhi Dwarka, Delhi East, Delhi North, Delhi South, Delhi West, Ghaziabad, Greater Noida, Gurgaon & Noida
having property value(in column i of raw data) greater than equal to 5000000 and RENT_SELL_LEASE is "S" (in column H of raw data) should copy cut and paste to sheet2.

Please find the attached

Thanks

[davesexcel]

Use your macro recorder and use autofilter to filter the columns you want

[xlhelp7]

Hi Davesexcel,

Thanks for the reply!

I want to automate the process so i required vba code.

thanks