Spreadsheet Function

T

tonystowe

Hello,

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

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

THE PROBLEM

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

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

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

Thanks,

Ton
 
C

Conan Kelly

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 Data>Filter>AutoFilter. 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
 
P

Pete_UK

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
 
T

tonystowe

Conan said:
Tony,

It sounds like all you want to do is filter the data by each offic
(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.
would use AutoFilter. You can do this by selecting your range
of data (you can even include the column headers if you want), the
select Data>Filter>AutoFilter. Then each column header will
have its own dropdown menu. Then you can click the drop-down in Offic
and select the one you want. All the data will remain in
the sheet, but only the ones that match your filter criteria will b
shown (the rest will be hidden).

Hope this helps,

Conan
Click to expand...


Conan,

Thanks for your help. That was far too easy (now that I know) and tha
will work even better as now I can do everything on a single sheet an
be done with it. Again, Thanks.

Ton
 
Top