[mso] Re: linking worksheets in Excel
- From: "Elise Miller" <emiller@xxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 6 Jan 2003 10:55:00 -0500
That's a good start! I will try that and let you know if I more
questions come up. Thanks.
> -----Original Message-----
> From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]
> Sent: Sunday, January 05, 2003 11:53 PM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Re: linking worksheets in Excel
>=20
>=20
> Well....maybe I have jet lag and I'm tired, so I'm not sure exactly
what
> you
> want to do. So, I'm gonna give you some tips and see if this gets you
> started, then I'm heading off to bed.
>=20
> Let's say you have an entry in cell B10 on a sheet called Properties
and
> you
> want whatever is put in that cell to also show up in cell A1 on a
sheet
> named Savings.....so, in the sheet named Savings, click in cell A1 and
> type
> this:
>=20
> =3DProperties!B10
>=20
> Now, whatever you put in B10 in the Properties sheet will also be
shown in
> A1 in the Savings sheet.
>=20
> Or, if you wanted cell A2 in the Savings sheet to show what was in B10
in
> the Properties sheet, minus 100, for example, click in cell A2 in the
> Savings sheet and enter this formula
>=20
> =3DProperties!B10-100
>=20
> I'm not sure if this is close to what you are looking for, so let me
know
> if
> this doesn't help you at all and I'll take another stab at it tomorrow
> when
> I'm more awake...LOL
>=20
> Nitey nite
>=20
> 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
>=20
>=20
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf
> Of Elise Miller
> Sent: Sunday, January 05, 2003 11:38 PM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Re: linking worksheets in Excel
>=20
>=20
>=20
>=20
> Well sort of both. But also I'm wondering if there is a way to get a
> line item to duplicate itself from the bank account worksheet, which
is
> where I will do the data entry, into the worksheet about the specific
> property. One of the "fields" in the bank account worksheet is the
> property the transaction pertains to, so I wanted to see if that field
> entry could trigger an automatic entry into another worksheet about
that
> property only, so I could have a separate list of all the transactions
> related to each property. Does that make sense?
>=20
>=20
> *************************************************************
> You are receiving this mail because you subscribed to
mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>=20
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>=20
> To Unsubscribe from this group, send an email to
> mso-request@xxxxxxxxxxxxx?Subject=3Dunsubscribe
>=20
> 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
>=20
> 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:
>=20
> 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:
