[mso] Re: linking worksheets in Excel
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sun, 05 Jan 2003 23:29:24 -0500
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
-----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.
Thanks,
Elise
*************************************************************
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
*************************************************************
*************************************************************
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:
