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
Bookmarks