Hi,
Iím pretty new to programming and VBA, would appreciate any help on the problem I am trying to solve.
I have two spreadsheets and I want to find a number which is located in the A column in one spreadsheet and to copy the line from A to J then paste it into the other spreadsheet in the cells that I want.
After It has been pasted I then want to then lookup the number which is located in another worksheet and copy the line across to the location where I copied the A-J cells.

Cheers