Dear all and JBM
I posted my problem two days ago, but I didn't have chance to check the
answer until now. In the mean while the topic is already on the 3-4 page.
Therefore I copied it once again at the end of this post. JBM answered me,
but this is not exactly what I need. First of all, I would need to copy data
in order to put it in the new sheet and I would like to have a “real time”
update over the situation from the two processes; in case that an order is
delayed or the sequence is altered.
Secondly, I would like to combine it with the data from second sheet
(“Process 2”, please see below) into a list.
I'm not very experienced Excel user, so I have no idea what this would
require. Please ask more question if my explanation below is not clear and I
will try to be more often online.
Cheers
Vedad
"JMB" wrote:
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 don’t have an idea for how to do it.
>
> Any ideas are highly appreciated.
>
> Regards
> Vedad
|
Similar Threads
