Hello,
I'm new here and this is my 1st time, so be gentle!I need help with a formula to automatically populate data from Sheet1 onto the respective date on my calendar on Sheet2.
On Sheet1, Column A, I have group names for some parts I send out.
Column D is the date they are due to return to my facility.
SHEET1
group color code out due
1730a ja 12/28/15 1/1/16
1730b ca 12/29/15 1/4/16
1731a aa 12/30/15 1/5/16
1731b ea 12/31/15 1/6/16
SHEET2
On Sheet2 is my calendar. I am looking for a formula or way to
have the name of the group on Sheet1 to automatically populate
in the appropriate date/cell on Sheet2.
January-16
FRI 01 1730a
MON 04 1730b
TUE 05 1731a
WED 06 1731b
I thought it would be an easy IF function but I am having trouble making it work. Any help would be greatly appreciated and thanks in advance!
Bookmarks