Hi,
I have created a spreadsheet (sheet 1) which i would now like to duplicate (sheet 2) in the same workbook . That is the easy part,
once it has been duplicated i want to use the = function so any changes made on sheet 1, also change on sheet 2 - that is also easy,
the hard part is, sheet 1 is huge with thousands of fields, i do not have the time to to enter the formula =sheet1... into every field.
Is there a way to duplicate the sheet 1 but also make it so that it will have the formula to duplicate each field from sheet 1 and if changes are made on sheet 1 the same changes will be made on sheet 2.
Thankyou in advance to the expert that can assist.
thankyou
Bookmarks