+ Reply to Thread
Results 1 to 2 of 2

Find value from sheet 1, cell A1 in sheet(s) 2 (3, 4?), copy, paste row to sheet 8

  1. #1
    Registered User
    Join Date
    05-04-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    5

    Find value from sheet 1, cell A1 in sheet(s) 2 (3, 4?), copy, paste row to sheet 8

    Okay, I know zero VBA (but small amounts of other languages) and after browsing through a bunch of find/copy/paste code, I think my situation is unique enough to require its own question. Not sure if this is possible, but I would like a function that:

    Takes a value from a cell (say A1) in sheet 1.
    Finds any occurrences of that value in sheet 2, column 1,
    Cuts (or copies then deletes) that entire row,
    and pastes it into sheet 8.
    Then -
    Loop, except use value from sheet 1, cell A2 for the search, and when pasting into sheet 8, use a new line, don't erase what's already there.
    Loop until I hit specified row in sheet 1, or the end of the data, whatever.

    Any chance? It would be even better if I could search sheets 2 through 7 instead of just 2.

    Thanks for reading!

  2. #2
    Registered User
    Join Date
    05-04-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Find value from sheet 1, cell A1 in sheet(s) 2 (3, 4?), copy, paste row to sheet

    Got around this using filters and COUNTIF, probably quicker in the end, but if anyone is bored and wants to point me in the right direction, I'm still curious about find and cut.

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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