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
Bookmarks