+ Reply to Thread
Results 1 to 3 of 3

Find cell value and copy that row into new sheet

  1. #1
    Registered User
    Join Date
    08-18-2013
    Location
    canberra, australia
    MS-Off Ver
    Excel 2007
    Posts
    17

    Find cell value and copy that row into new sheet

    I have sheets 1, 2 & 3.

    Sheet 1 has a column of values, e.g. C123, D2333, C4500 etc. They are all excel cell coordinates.

    Sheet 2 is rows of data.

    How can I match the column of data in sheet 1 (cell values) with their rows in sheet 2 and copy all matching rows into a empty new 3rd sheet?

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

    Re: Find cell value and copy that row into new sheet

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    08-18-2013
    Location
    canberra, australia
    MS-Off Ver
    Excel 2007
    Posts
    17

    Lightbulb Re: Find cell value and copy that row into new sheet

    post question.xlsx


    I hope now the attachment can put meaning to the post, 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. Find cell content and copy row onto new sheet
    By cmd105 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-16-2014, 05:11 PM
  2. [SOLVED] Find cell value in column and copy to other sheet
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-18-2013, 12:52 PM
  3. copy a specif cell value, find another like that in sheet copy adjacent cell and pate
    By smwaqas89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2013, 10:00 AM
  4. [SOLVED] VBA to find cell value and copy entire row to next available row on another sheet
    By BBen in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-02-2012, 04:59 PM
  5. Find value from sheet 1, cell A1 in sheet(s) 2 (3, 4?), copy, paste row to sheet 8
    By fleeting in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2011, 03:31 PM

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