[mso] Re: linking worksheets in Excel
- From: "Elise Miller" <emiller@xxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sun, 5 Jan 2003 23:37:38 -0500
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?
-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]=20
Sent: Sunday, January 05, 2003 11:29 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: linking worksheets in Excel
Hi Elise....what exactly do you mean by "linking"? Do you mean
hyperlinking so when you click on a cell, you go directly to another
sheet in the workbook? Or do you mean you want a value to change on one
sheet when you change it on another?
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 Elise Miller
Sent: Sunday, January 05, 2003 8:08 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] linking worksheets in Excel
Hi folks,
I'm trying putting together an Excel workbook for a small property
management business. I want to use one worksheet to list itemized
transactions in the checking account and one sheet for the same kind of
thing from the savings account. My question is, many of the
transactions are related directly to one specific property (i.e. deposit
for November rent from House A, or a check for fixing the roof on House
B), and I'd like to be able to link the transactions to additional,
property-specific sheets within the same workbook. Is there a way to do
that in Excel, either with simple linking or with some kind of macro or
VB coding? The goal of course is to not make any entries twice.
=20
Thanks,
Elise
=20
*************************************************************
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=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:
