Coordinating Sheets...

[cbaughn]

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??

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.

 

[Sheeloo]

Select the cells in the first sheet...
Go to the other sheet (to the cell which has the same address as the first
cell in your copied cells. So if you selected A10:F100 to A10 on the other
sheet)
Right-click, choose Paste Special and click on Paste Link...

Now wheneever someone changes those cells in the first the change will be
reflected on the other sheet.

Why do you want to do this?

 

[cbaughn]

Our installer doesn't need to see our sell price to his cost, so I wanted an
individual cost sheet to print for him. Now, is there a print setting I can
choose to make it print the entire workbook every time? I'd like those 2
sheets to always print.

 

[Sheeloo]

No, not without using macros or manual selection...

 

[Jacob Skaria]

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

Minimize the column width in the second sheet for columns which are not to
be seen. When you print everytime this will print both sheets..Please try and
feedback

If this post helps click Yes