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