[mso] Re: linking spreadsheets in Excel
- From: "Thomas N. Chan" <thomasnathan@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 2 Sep 2002 20:29:03 +1000
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.
=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: Monday, September 02, 2002 8:56 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: linking spreadsheets in Excel
Ok Thomas....you lost me, my friend. Can you ask me that question
again, a little more slowly?
Are you asking the difference between absolute and relative references?
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: Sunday, September 01, 2002 6:48 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: linking spreadsheets in Excel
Can I jump in, so overall for such task, you have to make something
called absolute cell or worksheet so that the formula can refer to that
particualr area??
Sorry for such stupid question as I'm just starting to learn Excel in my
course here, I mean the formula like =3D3Dif and vlookup etc.
So I'm learning over here too.[
*************************************************************
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: