Spreadsheet Function
 

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

Spreadsheet Function
 

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

Spreadsheet Function
 

And if you still want to have separate sheets for each office, then you
can highlight all the visible cells after applying the filter, click
<copy and then paste to a new sheet - only the cells which were
visible will be copied to the new sheet, i.e. one for each office.

Hope this helps.

Pete

Spreadsheet Function
 

Conan Kelly Wrote:
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


Conan,

Thanks for your help. That was far too easy (now that I know) and that
will work even better as now I can do everything on a single sheet and
be done with it. Again, 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