Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I send a cell value to another worksheet?
I want to enter the value of a cell to a cell on another worksheet
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I send a cell value to another worksheet?
Deb
Without using VBA code you cannot "send" a value. Using a formula you can "receive" a value. Assume you have a value in A1 of Sheet1 In Sheet2 in any cell enter =Sheet1!A1 OR..........if just a one-time operation you can select Sheet1 and CTRL + click on Sheet2 to select it also. Enter the value in a cell on Sheet1 and will be entered on Sheet2 at same cell address. DO NOT FORGET to ungroup the sheets when done.....right-click and "ungroup" or just click on any non-active sheet. Gord Dibben MS Excel MVP On Sat, 26 Aug 2006 14:04:01 -0700, Deb wrote: I want to enter the value of a cell to a cell on another worksheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How:Add New Worksheet that copies the cell of the previous sheet | Excel Worksheet Functions | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
fill cell with color from other worksheet | Excel Discussion (Misc queries) | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) |