Hi,

I have a workbook with 20 worksheets. I would like to set up the worksheets
so that if I change a value in a cell in any worksheet, the same cell will
change to the new value in all the other worksheets.

To make matters more complicated, the value within each cell is selected
from a drop-down list that I have already created.

Any help would be appreciated! Thanks!

you can do what you want but not from ANY worksheet.You can change all cells
on all other worksheets from only one worksheet
--
paul

remove nospam for email addy!



"ursobutfo2me" wrote:

Hi,

I have a workbook with 20 worksheets. I would like to set up the worksheets
so that if I change a value in a cell in any worksheet, the same cell will
change to the new value in all the other worksheets.

To make matters more complicated, the value within each cell is selected
from a drop-down list that I have already created.

Any help would be appreciated! Thanks!

Say the cell that holds the drop-down list value is cell A1 on sheet 1.

Then on sheet 2 enter:
=Sheet1!A1

Copy and paste this formula to cell A1 on all other sheets (sheet 3 to
sheet 20).


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531795

I believe it is possible under VBA to setup an Event code that will
detect a change within a range, copy the .value from the active cell,
and paste that to the same cell on all 20 worksheets (including the
current). This code could then be copied to (and would apply to) all 20
sheets, but performance might not be great.

Is this what you would want?

--

paul Wrote:
you can do what you want but not from ANY worksheet.You can change all
cells
on all other worksheets from only one worksheet
--
paul

remove nospam for email addy!



"ursobutfo2me" wrote:

Hi,

I have a workbook with 20 worksheets. I would like to set up the
worksheets
so that if I change a value in a cell in any worksheet, the same cell
will
change to the new value in all the other worksheets.

To make matters more complicated, the value within each cell is
selected
from a drop-down list that I have already created.

Any help would be appreciated! Thanks!



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=531795