Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Links / December 2003

Tip: Looking for answers? Try searching our database.

Help in linking between Workbooks

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jerry Litt - 01 Dec 2003 16:14 GMT
I need to know how to link one or two fields in Excel so that
the info in the primary worksheet is automatically copied into
the second worksheet.

Unfortunately, I don't have a book on Excel! I'd appreciate any
help.

Thanks in advance,
Jerry Litt
g.litt@comcast.net
Bill Manville - 02 Dec 2003 09:54 GMT
> I need to know how to link one or two fields in Excel so that
> the info in the primary worksheet is automatically copied into
> the second worksheet.

In the cell in the second worksheet type =
Then select the cell you want to take the information from.
Then press the Enter key.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
Lonnie - 02 Dec 2003 15:21 GMT
Jerry, if you are working within a single file you can simply do this:
='sheet'!cell
I.E. ='Trades'!J7

> I need to know how to link one or two fields in Excel so that
> the info in the primary worksheet is automatically copied into
[quoted text clipped - 6 lines]
> Jerry Litt
> g.litt@comcast.net
Jerry Litt - 02 Dec 2003 15:37 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.