[mso] FW: Excel Formula-If Cell Contains a date, put the rows contents into another doc.

From: "Scott, Tiffani D." <TScott@xxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Date: Wed, 11 May 2005 10:31:43 -0600

This is what I have tried to do for this but it is not working
correctly:

=3DIF(2nd Requal Sheet.xls]requal'!$C$8=3D(Year(Summary!A3:A7)),2nd =
Requal
Sheet.xls]requal'!$C8,"")

I know where it says Year it is set up incorrectly.

I would be so very grateful if some one could assist me with the
following formula.  I am stuck on how to accomplish it but if I could be
shown how to do this here I will be able to modify and apply it to other
documents.
=20
If the date (Doesn't matter what day of month- just the year) in the=20
document 2nd requal sheet  column C, is between the years listed on=20
document 3 yr plan in Progress Tab Summary A3 through A7=20

THEN  put the row of information from  2nd requal sheet  that
corresponds to that C cell  which is (A:F) that had the date that fit
the requirements into 3 yr plan in Progress starting on A4:F4 then just
listing them down.


*Note:
The name of the two documents I am working with is
2nd requal sheet=20
            Has information on columns A:F

3 yr plan progress

            Contains a tab titled "Summary"

            It will now contain information on Column A:F

=20

Thank you-THANK YOU,

T. Scott


*************************************************************
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 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
*************************************************************

[mso] FW: Excel Formula-If Cell Contains a date, put the rows contents into another doc.

Other related posts: