+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

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

    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
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,143

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

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

  3. #3
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

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

    Hi Davesexcel,

    Thanks for the reply!

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

    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. move data from sheet1 to sheet2 based on date in column1 of sheet1
    By pcaldwell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-10-2014, 03:20 PM
  2. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  3. [SOLVED] Move data from SHEET1 to SHEET2 based on Selected criteria...like an adv filter
    By gspivey79 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-03-2012, 02:06 PM
  4. Replies: 3
    Last Post: 06-06-2012, 05:36 AM
  5. [SOLVED] Copy and Paste Entire Row from Sheet1->Sheet2 based on text string match in Sheet1 Row
    By dmlovic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-17-2012, 08:42 AM
  6. [SOLVED] Copying Data from Sheet1 to sheet2 based on criteria for copy
    By pprane in forum Excel General
    Replies: 1
    Last Post: 04-22-2012, 02:32 AM
  7. Copying Data from Sheet1 to sheet2 based on criteria for copy
    By pprane in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2012, 02:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1