How do I replicate an area of a SS onto another sheet in same wkbk

[Dave]

--
Dave

[Spreadsheet]

Dave,

If you want cell A1 on Sheet2 to be the same as cell A1 on Sheet1 simpy use A1=Sheet1!A1. Do this for as many cells as you want to replicate.

[Dave]

The A1=Sheet1!A1 formula was just the thing! Thanks!
--
Dave


"Spreadsheet" wrote:

>
> Dave,
>
> If you want cell A1 on Sheet2 to be the same as cell A1 on Sheet1 simpy
> use A1=Sheet1!A1. Do this for as many cells as you want to replicate.
>
>
> --
> Spreadsheet
> ------------------------------------------------------------------------
> Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
> View this thread: http://www.excelforum.com/showthread...hreadid=554981
>
>