Automatically copying information between sheets in excel. - Microsoft Community

-

hello

i use excel track when item loan out due returned.  using a calendar template calendar below. we imputing client information separate sheet in same book looks sheet below calendar.  function automatically copies information first 2 columns date on calendar listed in last column.  is possible?  thanks.   

january 2017          
sunday monday tuesday wednesday thursday friday saturday
1 2 3 4 5 6 7
8 9 10 11 12 13 14
             
15 16 17 18 19 20 21
22 23 24 25 26 27 28
             
29 30 31 1 2 3 4
5 6 notes  
   
patient name  car seat number date loaned out follow date
jimmy hipper cs-10 15-nov 1/15/2017
       
       
       
       
       
       
       
       
       
       
       
       
       

yes here's link: https://1drv.ms/x/s!aiuzuhiqtf3fgroe-4b3vgh2grssla

the formula helper column : 

=day(e2)

the formula calendar is: 

=if(vlookup(day(h8),sheet1!$a$2:$e$7,1,false)=day(h8),concatenate(vlookup(day(h8),sheet1!$a$2:$e$7,2,false)," ",vlookup(day(h8),sheet1!$a$2:$e$7,3,false)),"")



Office / Excel / Other/unknown / Unknown/other



Comments

Post a Comment

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

-
split thread. hi, we 've got user exact same issue: "ce mot de passe été utilisé trop souvent dans le passé. choisissez une chaîne plus difficile à deviner. (which means: " we've seen password many times before. choose harder guess. ") errorcode: 120018 correlationid: 4ab3a486-a11a-4ead-983c-c1c391c3e7d5" it happens when tries update password "login.microsoftonline.com" portal. we tested more 5 different new passwords (passwords never seen before). office 365 synchronized ad; user's account not locked or whatsoever, account set able change password cannot reset it. thanks in advance. ***post moved moderator appropriate forum category.*** hi all,   thanks replies.   generally, password length greater 10 characters. understand users may want have longer passwords. please submit feedback improve our products , services. understandi
Read more

The message was sent to a distribution list ‎(DL)‎ - Microsoft Community

-
hi all, i posting question have faced issue last week, migration done exchange 2007 o365. there 1 distribution list in on prem & in o365 group (synced aadc). 1 migrated user send email dl before & after migration, strange thing that, before migration ok, after migration user got message as " delivery has failed these recipients or distribution lists: *** email address removed privacy ***   this message has many recipients. microsoft exchange not try redeliver message you. please try resending fewer recipients, or provide following diagnostic text system administrator". *** email address removed privacy *** #550 5.5.3 resolver.adr.reciplimit; many recipients ## i have checked same message id in o365 message trace & found following... 8/16/2017 11:17:55 am receive message received by: db4pr05mb397 message received by: db4pr05mb397 8/16/2017 11:17:56 am expand dl the message sent distrib
Read more

Activation Error 0x8004FE93 - Microsoft Community

-
not able activate licence of microsoft 365 getting error 0x8004fe93 moved from:      windows / windows 10 / install, upgrade, & activate hi vinit, this issue may have occurred due internet connection issues. activate software, we'd clarify few things. kindly answer following: are trying activate windows 10 license or microsoft office 365? are able access microsoft account ? we'll waiting reply. Office / Install, upgrade and activate / Windows 10 / Office 365 Home
Read more