Ger
07-20-2011, 04:28 AM
Hello,
i'm using excell 2003 dutch version.
I want to make a list of the data from page 1 (wk 27-52) on page 3 (blad2).
On page 3 (blad2) i want the name & number or code.
There are 3 categories (roosterdiensten), afwezig, activiteiten.
For each category the codes are listed in column B.
The code or number can occur more than 1 time
The category "roosterdiensten" are numbers or "res" or starts with an "E" or "I"
The source data is in (wk27-52) cells I205 to GH284. Target = "blad2"
Please see the example.
Thx in advance
Ger
i'm using excell 2003 dutch version.
I want to make a list of the data from page 1 (wk 27-52) on page 3 (blad2).
On page 3 (blad2) i want the name & number or code.
There are 3 categories (roosterdiensten), afwezig, activiteiten.
For each category the codes are listed in column B.
The code or number can occur more than 1 time
The category "roosterdiensten" are numbers or "res" or starts with an "E" or "I"
The source data is in (wk27-52) cells I205 to GH284. Target = "blad2"
Please see the example.
Thx in advance
Ger