Hi,
I got 2 sheets. (1 called "Revenue", the other "101")
in the sheet revenue are department codes (variable 100 to 999)
they are situated in row "B". the corresponding data in row "D".
this data needs to be transported to the sheet "101"
in the sheet "101" are put the numbers 100 to 999 in row "A"
in row "B" we need the data from the revenue sheet that is corresponding with the department code.
could somebody help me?
kind regards
Robert
I got 2 sheets. (1 called "Revenue", the other "101")
in the sheet revenue are department codes (variable 100 to 999)
they are situated in row "B". the corresponding data in row "D".
this data needs to be transported to the sheet "101"
in the sheet "101" are put the numbers 100 to 999 in row "A"
in row "B" we need the data from the revenue sheet that is corresponding with the department code.
could somebody help me?
kind regards
Robert