[vicsireland] Re: Any advanced EXCEL users on this list?
- From: "Cearbhall O'Meadhra" <omeadhrac@xxxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Fri, 18 Jan 2013 16:20:18 -0000
Donal,
To show values in sheet 2 that are entered in a cell in sheet 1, you need to
set up a reference cell in sheet 2. Then when you put a value in the cell in
sheet 1 it will appear automatically in the cell in sheet 2
You can get help on this if you put the word "reference" in the help search
window.
Let us say that you enter a grade for an assignment in column C in sheet 1
and set column f in sheet 2 to show the value in sheet 1 for the same
person. For clarity let's take the person at row 3 in sheet 1 who appears in
row 6 in sheet 2.
The procedure is this:
In cell f6 in sheet2 type "=Sheet1!C3".
When you sort sheet 2 by alpah and end up with a different sequence of
records, the relationship will remain intact and the correct grade will
still accompany the original name.
I hope this is what you needed.
All the best,
Cearbhall
T: +353 (0)1 2864623 m: 08333 23487 E: omeadhrac@xxxxxxx
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Dónal Fitzpatrick
Sent: 18 January 2013 14:40
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Any advanced EXCEL users on this list?
Hi all,
This is a tricky one. I have an Excel 2010 workbook with two sheets. they
both contain the same data but each is sorted differently. the first by an
ID for assignment groups, the second alphabetically.
What I want to do is to enter a grade for an assignment in sheet 1, and have
the appropriate cell in sheet 2 updated. I'm sure it's possible to do this
I just don't know how.
Any help appreciated.
Dónal
Dr. Dónal Fitzpatrick,
School of Computing,
Dublin City University,
Glasnevin,
Dublin 9, Ireland
Tel. +353-(0)1-700-8929
fax: +353-(0)1-700-5442
email: dfitzpat (at) computing.dcu.ie
Email Disclaimer
"This e-mail and any files transmitted with it are confidential and are
intended solely for use by the addressee. Any unauthorised dissemination,
distribution or copying of this message and any attachments is strictly
prohibited. If you have received this e-mail in error, please notify the
sender and delete the message. Any views or opinions presented in this
e-mail may solely be the views of the author and cannot be relied upon as
being those of Dublin City University. E-mail communications such as this
cannot be guaranteed to be virus-free, timely, secure or error-free and
Dublin City University does not accept liability for any such matters or
their consequences. Please consider the environment before printing this
e-mail."
====================
The vicsireland mailing list
To unsubscribe at any time send a mail to:
vicsireland-request@xxxxxxxxxxxxx
with the word "unsubscribe", without the quotes in the subject of the
message.
To contact the moderator send mail to:
tim.j.culhane@xxxxxxxxx
For mor information on the Visually Impaired Computer Society visit:
http://www.vicsireland.org
==========================================================The vicsireland
mailing list
To unsubscribe at any time send a mail to:
vicsireland-request@xxxxxxxxxxxxx
with the word "unsubscribe", without the quotes in the subject of the message.
To contact the moderator send mail to:
tim.j.culhane@xxxxxxxxx
For mor information on the Visually Impaired Computer Society visit:
http://www.vicsireland.org
Other related posts: