Coordinating Sheets...
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?
--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.
"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.
|