Extracting specific data from a planning

[Mike1994]

Hello guys,

I hope you can help me or push me in the right direction with my question. I have an Excel planning per week (all in the same tab, week under week. In the file only 1 week is shown) with different processes, batches and types.

What i need is the following: i need a macro or script that is searching for all cells where 'oogst' is found and return in a list: batch, type and date. So for example:

On cel K18 'oogst 640 rcb' is found, what i need in a list is:

Batch 01 - type 3 - date 07-jan-21

On cel K24 'oogst 450 rcb' is found, what i need in a list is:

Batch 01 - Type 4 - date 07-jan-21

and so on. I tried to play something with VBA but i am not an expert.. hope you can help a bit

[jindon]

List?

This creates new sheet for the result

Please Login or Register  to view this content.

[Mike1994]

List?

This creates new sheet for the result

Please Login or Register  to view this content.

Thanks!! This looks great, can somehow also for example the 'oogst 640 RCB' added to the list? so the column above the batch

[jindon]

1)
Please don't quote whole posts -- it's just clutter.*If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

2) change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.