Hello,

Sheet1 has three columns labelled| Date : Office : Action | in
Row1

Sheet1 is where I intend to enter each event that occurs that
affects the course of the day's production.

THE PROBLEM

I am wanting to set Sheet2, and subsequent sheets, to pick up on
the information put into the column labelled OFFICE and then display
only the ACTIONS that are referenced on sheet1.

Overall I intend to simply enter the data one on Sheet1 and then
select the corresponding Sheet Tab to see the collective ACTIONS. I
have had incidents that affected production that I could not give an
OFFICE attachment. I will have to consider those as well.

I am new to excel so keep any suggestions in laymans terms and thanks
ahead of time for those interested in helping me with this issue.

Thanks,

Tony


--
tonystowe
------------------------------------------------------------------------
tonystowe's Profile: http://www.excelforum.com/member.php...o&userid=33162
View this thread: http://www.excelforum.com/showthread...hreadid=529792