Excel Live Sheet Duplication / Copy

Hi All,

I need to create a live duplication of one excel sheet to another inside the same workbook. For example if data is entered into sheet 1 it appears in sheet 2 in the same cell!

If anyone has an idea on how to do this please email me on [email protected]


Kind regards

Trevor

Hi,

Always best to share the knowledge rather than privately e-mail...

The best way would be to, in the sheet producing the copy, in A1 enter into the formula bar (assuming your original sheet is the default name 'Sheet1' - change as need be):

=Sheet1!A1

Then drag to the dimension of your original worksheet. Use the format painter to bring the format over.

HTH,

SamuelT

SamuelT,

Many thanks for your help with this. You are correct it always is better to share the information.

The ability to search these forums to find answers and tips is priceless.

Many thanks for your help.

Trev