PDA

View Full Version : Solved: making a list of the datasheet



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

parttime_guy
07-20-2011, 08:13 PM
Hi Ger,

This is going to be one major exercise....

But try this for starters.

Maybe once you get a Master right the next time it should be easy.

Best Regards

Ger
07-20-2011, 10:44 PM
Thx for the reply, but the problem with vlookup is that only the first value is found. If there are more of a kind is doesn't work.

Ger

parttime_guy
07-21-2011, 02:48 AM
Could you point out the cells (with examples) will relook at them again.

Ger
07-21-2011, 03:10 AM
I found a macro that fits. The only problem is the wildcard (*).
These are not recognized. See sheet "wk 27 tm 52" I227 and I228.

Ger

Ger
07-21-2011, 06:18 AM
I'm on holiday for the next 3 weeks, so i can't reply.

Ger