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
