A looping question

[thewebmaster]

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]

This is what I have at the moment:

Please Login or Register  to view this content.

[thewebmaster]

OK I managed to fix the loop but it doesn't want to copy the contents of the cells.

Have a look at this please: