move to a specific cell based on different value in column A

[sunny88]

i have three columns : department id, names , holiday hours

> 10 different department id
>n number for names and at the end has a 'total'
> holiday hours need to be put in the same row as the total of the department

what i need help for?

i need a macro in which it looks for the department id and then go to the 'holiday hours cell' depending where the 'total' is under name column for that department. Repeat it untill all the department are done.

EXAMPLE:

if department_id = 100(A7)
go to holiday hour cell value(C18) based on Total(B18)

if department_id = 200(A39)
go to holiday hour cell value(C58) based on Total(B58)


if department_id = 500(A135)
go to holiday hour cell value(C181) based on Total(B181)

 

[DanteAmor]

And why do you need to go to the cell where the word "total" is?