Tony,

It sounds like all you want to do is filter the data by each office (show only the actions for a particular office), one office per
sheet? Is this correct?

If this is the case, I wouldn't even bother with the other sheets. I would use AutoFilter. You can do this by selecting your range
of data (you can even include the column headers if you want), then select DataFilterAutoFilter. Then each column header will
have its own dropdown menu. Then you can click the drop-down in Office and select the one you want. All the data will remain in
the sheet, but only the ones that match your filter criteria will be shown (the rest will be hidden).

Hope this helps,

Conan




"tonystowe" wrote in message
...

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