Results 1 to 2 of 2

Find Value over multiple sheets in one cell then paste to new sheet the prev. 2 cells

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2010
    Location
    Colorado
    MS-Off Ver
    Excel 2008 Mac
    Posts
    1

    Find Value over multiple sheets in one cell then paste to new sheet the prev. 2 cells

    Hello Everyone.

    Been doing this manually for a while and going crazy (try doing this for 700+ values at a time).

    Basically, I am given a bunch of values ABCD00001234, ABCD00001235 etc...
    What I need is to find all those values which are located in Cell "C" over multiple sheets (40000+ rows per sheet over 4 sheets) and then copy/paste the values in Cell "A" & "B" in the same row then paste those values into a new sheet so that I now have in one row "A" "B" "C".

    Example: I am given:
    ABCD00001234
    ABCD00001235
    ABCD00001236
    ABCD00001250
    ABCD00001251
    ABCD00001288

    I could copy, then find, then paste then copy cells A and B in that row then paste into the sheet with the values I was given so that I now have all the info like this in cells A-C

    AAA55 C02 ABCD00001234
    AAA55 C03 ABCD00001235
    AAA55 C04 ABCD00001236
    AAE45 H12 ABCD00001250
    AAE46 A01 ABCD00001251
    AAE87 D12 ABCD00001288

    Etc.

    So, if I could just get a function etc.. that would allow me to have all values C in one sheet get searched for in all columns C of the other sheets and when found have their A&B cells copied then pasted into the originating sheet as A&B so I have a finished format as above, that would be great.

    I hope this makes sense

    TIA

    D.
    Last edited by db.1; 11-11-2010 at 06:14 PM.

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