enter text in cell and have value change in all worksheets; with l

[ursobutfo2me]

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!

[paul]

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
paul.shepherd@nospamparadise.net.nz
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!
>

[John James]

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).

[Bryan Hessey]

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?

--

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
paul.shepherd@nospamparadise.net.nz
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!
>