Dynamic Duplicate Worksheets

Is it possible to create a duplicate of a worksheet which is also dynamic, i.e. when one the master worksheet is updated, the changes propogate to the duplicate worksheet?

I know its possible to do it using vlookup but trying to avoid that path if possible as it could get extremely messy.

Thanks in advance.

A1=Sheet1!A1

copied to the end of space

??

CC

Doesnt seem to be working unfortunately.

Did you mean A1 (in new workbook) = A1 (in old workbook) and then copy down and across?

Alot of the values in the old workbook are derived from formulas and also have formats that I will need to carry across. Using the = function to reference just returns a value of '0'.

You can't create a live link for formats without quite a lot of messy VBA. You can copy and paste formats once if the layout doesn't change, then A1=A1 to keep teh values up to date.

Most people use the same worksheet if they want the same information...

CC

Originally Posted by Cheeky Charlie

You can't create a live link for formats without quite a lot of messy VBA. You can copy and paste formats once if the layout doesn't change, then A1=A1 to keep teh values up to date.

Most people use the same worksheet if they want the same information...

CC

Ok. I might just give that a go then. A little bit of manual formatting never hurt anyone I guess.

Regarding just using the same sheet, bit of a long story on that one. If it were up to me then we would but I have been given a directive so I have to follow that.