[mso] Re: Is this possible?
- From: "Scott-Johnson, Tiffani D." <TScott-Johnson@xxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Tue, 17 Aug 2004 08:51:36 -0500
I want it to look to our requalification matrix. In here there is a list of
jobs at the top row, first column is peoples names, mixed in the middle is
dates (MM-YY) if they apply to the person for when they need to requalify
for a particular job.
I want this information to go into our 3 year plan sheet. In here there is
names on the first column, the jobs on the top row, and on the second under
each job is split. One side of the split says YEAR/Quarter and the next one
says complete.
So I am trying to look into each job in the first sheet and grab cell and
link it to the corresponding name and job in the second sheet. I am still
trying to figure out how I can get the format to change the date to
YEAR/QUARTER. Then if the date is changed at all in the first sheet the
COMPLETE column needs to be marked in the second sheet. The complete mark
needs to stay there until the next year when this all starts over.
It is pretty complicated so I have been trying to figure this out for a long
time.
-----Original Message-----
From: Chuck Balogh-Core [mailto:cbalogh@xxxxxxxx]
Sent: Monday, August 16, 2004 8:42 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Is this possible?
If you create a link between the two sheets, it should work automatically.
Have you tried this?
What is the formula or condition that you are trying to execute against?
Chuck
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
> Behalf Of Scott-Johnson, Tiffani D.
> Sent: Monday, August 16, 2004 8:20 AM
> To: Formula help (E-mail)
> Subject: [mso] Is this possible?
>
>
> I would like to know if there is a way that I can write a formula where I
> can look into a completely different Excel Spreadsheet for
> information that
> I would like to put in another sheet? This will keep me from having to
> update multiple sheets.
> Thank you,
> Tiffani
>
>
>
> Tiffani Scott-Johnson
> Administrative Assistant
> Tesoro Refining and Marketing Company
> Phone: 801-521-4870
> Fax: 801-521-4803
> TScott-Johnson@xxxxxxxxxxxxxxxxxxx
>
>
>
> *************************************************************
> 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 with the word "unsubscribe" (without
> the quotes) in the subject line.
>
> 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 with the word "unsubscribe" (without the quotes)
in the subject line.
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 with the word "unsubscribe" (without the quotes) in
the subject line.
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: