software

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 lt;Entergt;.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Treasur2quot; gt; wrote in message
...
gt; How do (or what function) do I link worksheets or specific cells in
different
gt; worksheets.Select a quot;sendingquot; cell.
Edit|copy

select the quot;receivingquot; 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 quot;receivingquot; 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=quot;quot;,quot;quot;,sheet2!a1)Treasur2 wrote:
gt;
gt; How do (or what function) do I link worksheets or specific cells in different
gt; 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. edIf 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:
gt;
gt; And if it's in a different workbook add [WORKBOOK1.xls] in front of the
gt; sheet2!a1. Excel will automatically add any directory referrences when
gt; the WORKBOOK1 is closed and leave the directores off when the WORKBOOK1
gt; is open. ed

--

Dave Peterson

Ok, thanks.

This is what I was looking for.

quot;Dave Petersonquot; wrote:

gt; If it's in a different workbook, I'd make sure I let excel do the heavy
gt; lifting--either by pasting link or typing the = and pointing at the other cell.
gt;
gt; Let excel worry about the brackets, apostrophes, exclamation points...
gt;
gt; wrote:
gt; gt;
gt; gt; And if it's in a different workbook add [WORKBOOK1.xls] in front of the
gt; gt; sheet2!a1. Excel will automatically add any directory referrences when
gt; gt; the WORKBOOK1 is closed and leave the directores off when the WORKBOOK1
gt; gt; is open. ed
gt;
gt; --
gt;
gt; Dave Peterson
gt;