search in multiple cells and sheets

**martinlall** · 09-24-2008, 05:44 AM

Hello,

I'm trying to make vba, that takes one value(special code, up to 13 car long) from sheet4 column i1 and searches the match from sheet2 columns E:M. And when match is found, copies from sheet4 column K1 value(the same row where the code was taken from) to found match sheet(in this case sheet2) in column Q (the row must be the same where match was found)
If this maters, columns E:M may be hidden on sheet4, or E1 may be only one that's shown.

And has to loop until the end of the sheets.
By the way - i've got up to 150000 rows..

Can anybody help?

**arthurbr** · 09-24-2008, 05:55 AM

Hi
are you using XL2007?

**martinlall** · 09-24-2008, 06:07 AM

Originally Posted by arthurbr

Hi
are you using XL2007?

Yes, of course

**martinlall** · 09-24-2008, 08:05 AM

E:M may be hidden on sheet2. my bad.

**martinlall** · 09-25-2008, 12:34 AM

come on guys..really no one?

**martinlall** · 10-01-2008, 12:42 AM

Maybe i just try to explain little simpler.

On sheet4 i have lots of data in columns. And i'm interested in two of them:
col. i and col. k.

In column i i have code (12-13 char). And in column k i have count numbers.

I need macro, that takes the code from sheet4(column i), searches match on sheet2 (columns c; e:m) and copies the count number (in columns k on sheet4) on the same row, where the match was found in column Q (from sheet4 column K to sheet2 column Q)