Hello,
I am looking for some help to make a macro that will look at cell B1 in workbook1 which will contain a 5 digit number (Job Number) and then go to the same file directory ( 'S:\Job Files\18594.xlsm ) and open the file then from
workbook1 copy data from cells sheets ("Sheet1").Range ("B2") and cells ("Sheet1").Range ("C763") then paste that data in workbook2 in sheets ("Hours & Cost Input").Range("E6:F62") then close and save workbook2.
After completing the 1st Job Number repeat the same process on the next Job Number in cell B65 and offset for the copy cells will always be the same and the paste location will always be the same.
This repeat could happen up to 24 time and I will set up the so the job number has the same offset from the last number.
The data in Cell B2 is a date and Cells C763 are numbers.
Any help would be appriciated.
Thanks
Jeffrey