Hi
I have a worksheet which I populate using drop down boxes, direct
typing and formulaes (depending on the column). I want to produce a
replica of this sheet where I can then adjust some columns to suit
another user. However, some of the columns will still be identical to
the original sheet and so I want to populate the new sheet using the
old one (if you see what i mean!)
For the straightforward 'direct typing' columns, I know using eg
=SUM('Sheet1'!C16) will populate the column correctly on the 2nd sheet,
but how can I replicate the column where the cells use drop down boxes
so that if I change the drop down selection on sheet 1, it will change
on sheet 2 as well?
Any help would be appreciated. Hopefully the question is clear!
Thanks
--
Joni
------------------------------------------------------------------------
Joni's Profile:
http://www.excelforum.com/member.php...o&userid=13596
View this thread:
http://www.excelforum.com/showthread...hreadid=556967