Coordinating Sheets...
 

Below is my origianl question with a response I received. My problem with
that answer is I need the action to be automatic. Multiple people use the
spreadsheet and I can't expect to them all remember (or know how) to select
both the worksheets to get the information to transfer. Any other
suggestions anyone??

"cbaughn" wrote:

I have 2 sheets in a workbook. One sheet shows our cost and sell for a
service, the other is a copy of the first sheet but only shows cost. Is it
possible to type information in the first sheet and have it automatically
transfer to the second sheet?

Thank you!

If the data is to be in exactly the same location on both worksheets this is
a simple task. Just select both worksheet tabs and the data will be entered
on both worksheets.

Coordinating Sheets...
 

Group sheets. For example press Ctrl and select Sheet1 tab and sheet2 tab.
Actions performed in Sheet1 will be reflected in Sheet2 also

If this post helps click Yes
---------------
Jacob Skaria


"cbaughn" wrote:

Below is my origianl question with a response I received. My problem with
that answer is I need the action to be automatic. Multiple people use the
spreadsheet and I can't expect to them all remember (or know how) to select
both the worksheets to get the information to transfer. Any other
suggestions anyone??

"cbaughn" wrote:

I have 2 sheets in a workbook. One sheet shows our cost and sell for a
service, the other is a copy of the first sheet but only shows cost. Is it
possible to type information in the first sheet and have it automatically
transfer to the second sheet?

Thank you!

If the data is to be in exactly the same location on both worksheets this is
a simple task. Just select both worksheet tabs and the data will be entered
on both worksheets.