reference-one cell to another
I would like to set a function for a cell,that displays the cell on another
page. |
Hi Heath
if you mean that you want cell A27 on sheet 2 to display what ever is in A3 on sheet 1, the "easiest" way to do it is click in cell A27 on sheet 2, type an = then click on A3 on sheet 1 and press enter. The formula =Sheet1!A27 will be put into the cell for you. You could, of course, just type this yourself. However, you need to remember, if the sheet name contains spaces you need to put ' ' around the sheet name, e.g. ='Jan Figs'!A27 Regards JulieD "Heath" wrote in message ... I would like to set a function for a cell,that displays the cell on another page. |
All times are GMT +1. The time now is 08:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com