Copy cells if match in separate files

[MAButler]

I have two files: 'Aa' and 'Address'
From file 'Aa' i need to look at each individual Account number in column I (Account) then open file 'Address' and match with column C (Account)....... then copy that rows cells in column D, E, F, G, H, I, J and K then paste into file 'A' column J, K, L, M, N, O, and P.

So the code i have been trying is below, but i dont understand it enough to change it correctly.....

Please Login or Register  to view this content.

I have attached the two files.......

[TonyS]

Hi,

Try this

Please Login or Register  to view this content.

Tony

[MAButler]

It sort of works.... But at each cell and line it asks for path to file 'Address', I have tried to type it into code but then i get an error....

Please Login or Register  to view this content.

The files are not stored in the same folder. The data in the files could be any number of rows.

[MAButler]

Both files need to be open at same time.....

Is there a way of just having the data in the cell not the formula???

Is there away of bringing over the titles from 'Address' row A??

[TonyS]

Hi,

Try this one

Please Login or Register  to view this content.

Tony

[MAButler]

Thanks for that will try it when i get in...... and let you know