VBA Code to Open Workbook and copy data

[Howardc]

Hi

Thanks for the reply. I clicked on debug and hovered over N and it gives me N= 1 , J = 0

It would be appreciated if you would test your code on the attached files & let me know