[mso] Re: linking spreadsheets in Excel
- From: "Thomas N. Chan" <thomasnathan@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 3 Sep 2002 03:28:05 +1000
Hmmm, sorry, I'm really new at Excel, and picking up bit by bit each
day.
The only thing I will be good at is to troubleshoot problems and not
making spreadsheet......
Geee, new everyday and I will be starting data base in a week time.....
So let's hope my whole course will be smooth as I wanted.
Thanks Linda!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!11
=20
The everlasting dilemma is, if you choke a smurf, what colour does it
turned?
Best and regards,
Thomas Nathan Chan
Webpage: http://www.heartwarmers4u.com/members/?thomas
ICQ: 70375853
MSN Messager: thomasnathan2001@xxxxxxxxxxx
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Linda F. Johnson
Sent: Tuesday, September 03, 2002 12:17 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: linking spreadsheets in Excel
Sorry Thomas...I think we are talking apples and oranges here. Linking
spreadsheets and making formula references absolute or relative are
totally different things.
Linking worksheets simply means the formula in one workbook refers to a
cell or range of cells in another workbook. This reference to these
cells can be either absolute or relative. Absolute means that the cell
references will never change, relative means that the cell references
will change, relative to where the formula is copied on the page.
Here's a link that explains absolute and relative:
http://www.isu.edu:8000/kb/disppage.php?doc_id=3D410&sec_id=3D34
Hope this helps some
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
=20
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Thomas N. Chan
Sent: Monday, September 02, 2002 6:29 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: linking spreadsheets in Excel
Well, I'm just asking if you link the worksheet that way, isn't that the
same as putting a vlookup formular for a table, and making that table
absolute or even named it. I'm just trying to understand the concept on
how to work on formular as I can't see well enough to determine the
visual table and cells.
So in simple, I make this area of cells to be absolute so that the
formular I'm making on my spreadsheet will be always refer by the
formula for entering info just like what you try to help to put on the
same data on different worksheet.
I hope its not making anymore confuse then how I made to myself.
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx?Subject=3Dunsubscribe
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts: