I am novice in VBA.

Can someone please help me do the following.

I have 2 sheets

Sheet1 - contains all the information
Sheet2 - where I want the code to put some of the information

I would like the code to start in Sheet1 - A2:A100. If the cell = 61538
then
put the corresponding B column value {offset (0,1)} in Sheet2 A2.

Go through all 100 rows and do the same....

So if it finds the first occurence of 61538 in Sheet1 - A7 it will put
the offset(o,1).value in Sheet2 - A2.

Then if the next occurence is Sheet1 - A55 it will put the
offset(0,1).value in Sheet2 - A3 *** the next open cell***

Thank you for any help on this matter.....

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=544439