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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I replicate an area of a SS onto another sheet in same wkbk (https://www.excelbanter.com/excel-discussion-misc-queries/95688-how-do-i-replicate-area-ss-onto-another-sheet-same-wkbk.html)

Dave

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

--
Dave

Spreadsheet

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

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

Dave

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

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

All times are GMT +1. The time now is 08:36 AM.