Look up value on one sheet, copy other information, look up same value on other sheet and paste information

[ednis]

Hi
I have a multisheet workbook, on sheet "Import Data" I have a list of Job details with a number of columns , 4 of which are:

Job number Time 1 Time 2 Time 3 Time 4

This data is imported from an Access database which is updated daily

Within the workbook I also have a sheet "Schedule" also with the same information ( but from an earlier import ) which is formatted differently ( i.e. data on 4 rows across 2 columns ) i.e.

Job number Time 1
Time 2
Time 3
Time 4

I would like to:
Run down the list of job numbers on the "Import Data" sheet, pick up the Job Number value and copy the Time 1 - 4 values

Then open the "Scedule" sheet find the matching Job Number value and paste the new Time 1-4 values over the old values

I would need the loop to run down the full list on the "import Data" sheet.

Job Number is in C column on "import data" , Time 1 -4 are in K-N

Job Number is in A column on "import data" , Time 1 -4 are in D

I have tried sorting both sheets the same and then just simply running down the job numbers to copy and paste the time values but as each individual job data is stored on 4 rows of the schedule sheet I cannot get the sort to work, it would seem much easier if you could sort by groups of rows in Excel.
Any help would be greatly appreciated
Regards

Ted

 

[JLGWhiz]

brilliant it works a treat , thanks very much

Ted

Happy to help
Regards, JLG