One way is to use Excel's Autofilter (Data/Filter/Autofilter). Filter the
Finish Good column for "YES". Then copy the filtered list to a new sheet.


"Vedad" wrote:

Hello everyone

I have a following problem:

- Two processes, which are recorded on two different sheets
- Some of the designs need to be worked on once, twice or several times
before they are finished goods.

SHEET 1 (Proces1)
Design nr. Name Finish good Time finish

1 Name1 07:00
2 Name2 08:00
3 Name3 09:00
1 Name1 YES 10:00
4 Name4 11:00
2 Name2 YES 12:00
4 Name4 13:00
3 Name3 14:00
3 Name3 YES 15:00
4 Name4 YES 16:00


SHEET 2 (Proces2)
Design nr. Name Finish good Time finish

5 Name5 08:00
6 Name6 09:00
7 Name7 YES 10:00
6 Name6 11:00
8 Name8 12:00
6 Name6 YES 13:00
5 Name5 YES 14:00
8 Name8 15:00
8 Name8 YES 16:00


What I would like to construct is third sheet which is updated automatically
with the overview of times of finished goods. I made a very simple example
above, where in reality the sheets contain many more designs and information
which I would like to eliminate by making a new and simple list. Something
that looks like this:

1 Name1 YES 10:00
7 Name7 YES 10:00
2 Name2 YES 12:00
6 Name6 YES 13:00
5 Name5 YES 14:00
3 Name3 YES 15:00
4 Name4 YES 16:00
8 Name8 YES 16:00

The sequence of finished goods coming at the same time has no importance.
The finish times are important in order to plan the processes to follow.

If the function of combining data from two sheets into one list is two
difficult to do, I could live with two separate lists for Proces1 and
Proces2.

The way I see it is to €œsearch€� for YES and copy the line or specific cells
into a new arc, but I dont have an idea for how to do it.

Any ideas are highly appreciated.

Regards
Vedad