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
|
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 |
All times are GMT +1. The time now is 04:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com