Copying New Sheet with Same Cell References and Formatting (With a Twist)

[JimS]

I want to make an exact copy of a spreadsheet within the same
workbook. I want this new sheet to have the same formatting and cell
references as an existing sheet.

Then, I want to tweak a formula or two in the new sheet.

Final result would be that when I input data into the old sheet it
automatically goes into the new sheet which then reflects the changes
I made to some of the formulas.

I have ASAP utilities if that helps, but I can't quite figure out how
to do this other than one cell at a time.

 

[ShaneDevenshire]

Hi,

The easiest way to copy a sheet is to hold down the Ctrl key and drag the
sheet to a new position.

However, if you expect to enter data in the old sheet and have it go into
the new sheet, nothing in the new sheet would be the same because there would
be formulas linked to the old sheet.

You could put the two sheets in Group mode and type into either one and both
would get the same entries.