Copy sheet within workbook and make cells equal to original

[westend9876]

I copied Sheet 1. The new sheet is Sheet 1(1). I want all of the cells in the copied Sheet1(1) to =Sheet 1. So cell A1 in Sheet 1(1) = the value in Sheet 1.

Can I do this without actually making the = to cell reference in every cell of the copied sheet?

 

[xlstime]

You can use paste special link -

1. Copy data from sheet1
2. go to sheet 1(1) and at A1 paste as (Alt+E+S+L) and enter

I copied Sheet 1. The new sheet is Sheet 1(1). I want all of the cells in the copied Sheet1(1) to =Sheet 1. So cell A1 in Sheet 1(1) = the value in Sheet 1.

Can I do this without actually making the = to cell reference in every cell of the copied sheet?

 

[xlstime]

+
and for formatting

3. without moving cells (A1) press Alt+E+S+T and enter

You can use paste special link -

1. Copy data from sheet1
2. go to sheet 1(1) and at A1 paste as (Alt+E+S+L) and enter