Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring data from one sheet to another if criteria are met. | Excel Worksheet Functions | |||
transferring Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
transferring total sheet from one workbook to another | Excel Worksheet Functions | |||
vlookup...transferring info from 1 sheet to another.... | Excel Worksheet Functions | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |