Transferring a cell value to another sheet
Is it possible to input a formula to transfer a cell value from one sheet
to another within a spreadsheet eg to make C7 in sheet 1 equal C7 in sheet 2 ? -- Regards John |
Transferring a cell value to another sheet
John
Using a formula in Sheet1 C7 =Sheet2!C7 If you mean just make it magically appear without a formula, no, except with some code -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html "John" wrote in message ... Is it possible to input a formula to transfer a cell value from one sheet to another within a spreadsheet eg to make C7 in sheet 1 equal C7 in sheet 2 ? -- Regards John |
All times are GMT +1. The time now is 06:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com