I saw the tutorial at
http://www.exceltip.com/st/Using_Loo...Excel/628.html
for looping but I need something a litle bit diffrent.

I want it to look in a file called subject.xls for the first name, go
to main.xls move 3 columns accross i.e. if I start at A it goes to D.

Get the value and paste it in subject.xls at the row of the same
person.

How can I do that?

Thank you for your help in advance.


--
thewebmaster
------------------------------------------------------------------------
thewebmaster's Profile: http://www.excelforum.com/member.php...o&userid=36601
View this thread: http://www.excelforum.com/showthread...hreadid=563428