ExcelBanter - Linking Spreadsheets in Excel.

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

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

- - Linking Spreadsheets in Excel. (https://www.excelbanter.com/excel-discussion-misc-queries/57121-linking-spreadsheets-excel.html)

BradleyLawrence

Linking Spreadsheets in Excel.

Is there any way to link spreadsheets in Excel, so that a value entered in
Sheet 1 is automatically transferred to Sheet 2?

keithl816

Linking Spreadsheets in Excel.

Hi Bradley,

You could use a formula like =Sheet1!a1

Change cell and sheet name to fit

Larry

--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=487944

All times are GMT +1. The time now is 08:39 PM.