Looping thru cells on two different sheets

[MoonWeazel]

Hey,

This is a little similar to

http://www.excelforum.com/excel-prog...each-time.html

I have a list and i want to be able to move down the list in column c looking for a particular value (set via a userform). When the value is reached, I would like to copy some of the information from that line into the A1 on sheet2. When the next occurance of the value is reached, I would like to copy some info (same as before) into A2 on sheet 2.

So far I have:

Please Login or Register  to view this content.

But I can't get the looping through to work. I have been trying to incorporate the rowcount into the offset function.

Thanks In Advance.

MoonWeazel

[Domski]

Not tested but maybe:

Please Login or Register  to view this content.

Dom

[MoonWeazel]

Thanks!!!

Totally excellent and it works like a dream!