Lonnie,
Sorry I do not understand. Worksheet1 and Worksheet2 are two worksheets in
one Workbook.
What do you mean when you say =:".......simply do this, ='sheet'!cell
......I.E.='Trades'!J7?
Sorry to be so dumb about this.
Jerry litt
g.litt@comcast.net
J.E. McGimpsey - 02 Dec 2003 18:54 GMT
The easiest way to see how this works is to click in cell you want
to contain the link, type "=" (without quotes), navigate to the
second sheet, and click in the cell you want to link to. Hit Enter.
XL will take you back to the sheet containing the link, and you can
see that the formula will have been automatically entered as
something like:
=Worksheet1!A1
Of course, you could type the above in directly, too.
> Lonnie,
>
> Sorry I do not understand. Worksheet1 and Worksheet2 are two worksheets in
> one Workbook.
> What do you mean when you say =:".......simply do this, ='sheet'!cell
> ......I.E.='Trades'!J7?
Lonnie - 03 Dec 2003 14:05 GMT
Jerry, no problem.
Within the cell you want to place the link type in the information
using the following convention:
='sheet1'!cell
1) "=" this lets excel know that you are entering a function and not
just text.
2)"'sheet1'" place in single quotes the sheet name that appears on the
bottum tab that you are linking to; this could be sheet1, sheet2,
sheet3, or any name that you give to a sheet(you can change a sheet
name by double clicking on the sheet's tab at the bottum) In my
previous example I was linking to a sheet that I had named Trades.
3)"!cell" Place the cell that you are linking to after the exclamtion
point. I.E. !A1, !D5, or !J332...
So yours might look something like this:
='sheet1'!A3
I hope this helps out.
Good Luck!
> Lonnie,
>
[quoted text clipped - 6 lines]
> Jerry litt
> g.litt@comcast.net