View Data on Multiple Sheets

[huwmc]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello All,

I am a VERY inexperienced excel user so I fear my question is embarassingly simple, but at least that means it will be easy for someone to answer.

I have a workbook with 25 to 30 sheets. When I enter data on the first sheet I would like it to appear on all the other sheets so I can then apply different filters to it on each different sheet. I think I know how to apply the filters, but I can't work out how to make my data appear on multiple sheets. I know it can be done, I just don't know how.

Any help is greatly apreciated.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello All,

I am a VERY inexperienced excel user so I fear my question is embarassingly
simple, but at least that means it will be easy for someone to answer.

I have a workbook with 25 to 30 sheets. When I enter data on the first sheet I
would like it to appear on all the other sheets so I can then apply different
filters to it on each different sheet. I think I know how to apply the
filters, but I can't work out how to make my data appear on multiple sheets. I
know it can be done, I just don't know how.

Any help is greatly apreciated.

Simply select the sheet tabs. Then enter data into a cell. It will appear in
the same cell in all selected sheets.

 

[huwmc]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello All,

I am a VERY inexperienced excel user so I fear my question is embarassingly
simple, but at least that means it will be easy for someone to answer.

I have a workbook with 25 to 30 sheets. When I enter data on the first sheet I
would like it to appear on all the other sheets so I can then apply different
filters to it on each different sheet. I think I know how to apply the
filters, but I can't work out how to make my data appear on multiple sheets. I
know it can be done, I just don't know how.

Any help is greatly apreciated.

Simply select the sheet tabs. Then enter data into a cell. It will appear in
the same cell in all selected sheets.
[/QUOTE]
Ahhh...Bob, thankyou...very simple

However, your answer was so simple that it made me realise the flaws in my question. So here is my question revised and clarified,

What I want to set up is something to help me schedule deliveries. So I have one worksheet where I enter all my orders and several others which pertain to certain dates. What I would like to be able to do is enter the orders on the 'All Orders' worksheet and then be able to turn to the November 13th (for eg) worksheet and be able to see all the orders entered for November 13th. The only way I can see to do this is to have all the sheets able to show all the data from the main sheet and then apply filters to the various date sheets to allow me to see only the dates I need. If I follow your advice and select all the sheet tabs it does indeed allow me to enter data on all the sheets at once but it means that a change to one is a change to all where what I actually want is my 'All Orders' sheet dictating the content of all the other sheets.
I hope this makes sense, and I REALLY hope someone can help.

 

[Bob Greenblatt]

Ahhh...Bob, thankyou...very simple

However, your answer was so simple that it made me realise the flaws in my
question. So here is my question revised and clarified,

What I want to set up is something to help me schedule deliveries. So I have
one worksheet where I enter all my orders and several others which pertain to
certain dates. What I would like to be able to do is enter the orders on the
'All Orders' worksheet and then be able to turn to the November 13th (for eg)
worksheet and be able to see all the orders entered for November 13th. The
only way I can see to do this is to have all the sheets able to show all the
data from the main sheet and then apply filters to the various date sheets to
allow me to see only the dates I need. If I follow your advice and select all
the sheet tabs it does indeed allow me to enter data on all the sheets at once
but it means that a change to one is a change to all where what I actually
want is my 'All Orders' sheet dictating the content of all the other sheets.
I hope this makes sense, and I REALLY hope someone can help.

You don't have to select ALL the sheet tabs, but need only select the ones
where you want the same data. It looks to me like what you really need is a
single sheet for each day (or week, or month) and a summary sheet. You can
copy and paste, or use formulas to consolidate to the summary sheet.