Hi

I have multiple Projects Spresheets, which has a page of data within in that I want to copy into a control sheet along with many others in a single line.

How do I do a loop macro that moves the cursor down as the ones I have tried appear to go through eveything but the active cell doesn't change.

So basically I put the path & file name in a cell, it then goes and gets that data from the worksheet, then goes to the next line and does the same.


Thanks

Stuart