How do (or what function) do I link worksheets or specific cells in different
worksheets.

You can have XL create the link for you automatically.
Then you can copy/revise that syntax to suit your needs.

Click in the target cell of a sheet and hit the equal sign,
Click on the tab of the origin sheet,
Click in the cell containing the data,
Hit <Enter.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Treasur2" wrote in message
...
How do (or what function) do I link worksheets or specific cells in
different
worksheets.

Select a "sending" cell.
Edit|copy

select the "receiving" cell
edit|paste special|paste link

You'll end up with a formula that looks like:
=sheet2!a1

You could type that directly or even let excel help.

Select the "receiving" cell
type = (just the equal sign)
use the mouse to select the cell on the other sheet and then hit enter.

=======
If the sending cell is empty, this formula will return a 0.

You may want to ammend the formula to look more like:

=if(sheet2!a1="","",sheet2!a1)





Treasur2 wrote:

How do (or what function) do I link worksheets or specific cells in different
worksheets.

--

Dave Peterson

And if it's in a different workbook add [WORKBOOK1.xls] in front of the
sheet2!a1. Excel will automatically add any directory referrences when
the WORKBOOK1 is closed and leave the directores off when the WORKBOOK1
is open. ed

If it's in a different workbook, I'd make sure I let excel do the heavy
lifting--either by pasting link or typing the = and pointing at the other cell.

Let excel worry about the brackets, apostrophes, exclamation points...

wrote:

And if it's in a different workbook add [WORKBOOK1.xls] in front of the
sheet2!a1. Excel will automatically add any directory referrences when
the WORKBOOK1 is closed and leave the directores off when the WORKBOOK1
is open. ed

--

Dave Peterson

Ok, thanks.

This is what I was looking for.

"Dave Peterson" wrote:

If it's in a different workbook, I'd make sure I let excel do the heavy
lifting--either by pasting link or typing the = and pointing at the other cell.

Let excel worry about the brackets, apostrophes, exclamation points...

wrote:

And if it's in a different workbook add [WORKBOOK1.xls] in front of the
sheet2!a1. Excel will automatically add any directory referrences when
the WORKBOOK1 is closed and leave the directores off when the WORKBOOK1
is open. ed

--

Dave Peterson