[mso] Re: linking worksheets in Excel
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sun, 05 Jan 2003 23:52:57 -0500
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.
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:
=Properties!B10
Now, whatever you put in B10 in the Properties sheet will also be shown in
A1 in the Savings sheet.
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
=Properties!B10-100
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
Nitey nite
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
-----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
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?
*************************************************************
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:
