Thread: Need a Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Need a Formula

Hi Jon,

In Sheet3, cell B4:

=Sheet1!A3

To make it work both ways is difficult and not recommended

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JonWardellBuilders" wrote in message
...
| What do i use to make a cell ('sheet1'!A3) link with ('sheet3'!B4)?
|
| Basically i want what ever gets entered into sheet 1 cell A3 to be
| autimatically entered in Sheet 3 cell B4. Even better would be if i change
| something in either cell it will change the other with the same information.
| --
| Jon Robershaw
| Wardell Builders, Inc