[vicsireland] Re: Any advanced EXCEL users on this list?
- From: Dónal Fitzpatrick <dfitzpat@xxxxxxxxxxxxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Fri, 18 Jan 2013 15:02:49 -0000
Hi Ronan,
You're probably right on that one to be honest. I need to find a web-based
way of doing this job but haven't done so as yet.
Tónal
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Ronan McGuirk
Sent: Friday, January 18, 2013 2:59 PM
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Re: Any advanced EXCEL users on this list?
Hi Donal,
Without knowing all your needs, here is my first suggestion!
If the two sheets contain the same data and are only sorted
differently, would it be safer to just have one sheet and enter all
your data in that and re-sort as necessary, given that re-sorting is
usually simplanks for the quick response,
e?
The reason I suggest this, is that I have found that if try to keep
two different things in sync, there is always a danger of them
drifting apart.
On 18/01/2013, Dónal Fitzpatrick <dfitzpat@xxxxxxxxxxxxxxxx> wrote:
> 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
==========================================================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: