This Formula seems to work with numbers, but not with Words. I have a master
sheet with basic information on it, then i have individual sheets with
detailed info for each item. I want the basic info on the first sheet to be
automatically entered into each individual sheet.

Maybe =sheet1!A3 should work for all it, but due to my formatting
differently in each sheet it doesn't? Any Ideas?

--
Jon Robershaw
Wardell Builders, Inc


"Niek Otten" wrote:

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

--
Jon Robershaw
Wardell Builders, Inc

Specific examples of formulas and formatting.??

--
Don Guillett
SalesAid Software

"JonWardellBuilders" wrote in
message ...
This Formula seems to work with numbers, but not with Words. I have a
master
sheet with basic information on it, then i have individual sheets with
detailed info for each item. I want the basic info on the first sheet to
be
automatically entered into each individual sheet.

Maybe =sheet1!A3 should work for all it, but due to my formatting
differently in each sheet it doesn't? Any Ideas?

--
Jon Robershaw
Wardell Builders, Inc


"Niek Otten" wrote:

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

--
Jon Robershaw
Wardell Builders, Inc