How do I create a checklist to auto-fill another doc using excel?
I am trying to create a course catalog for online learning. I have created a
matrix where I have courses listed down the left hand side and job titles accross the top. I want to be able to click in the boxes under the job titles to assign courses and have the information for each course auto-populate / auto-fill into another document or spreadsheet. Any suggestions? Thanks in advance! |
How do I create a checklist to auto-fill another doc using excel?
One way is INDEX/MATCH
Illustrated in this sample: http://cjoint.com/?jAbJsgtWDZ Index match example.xls Source table assumed in X, courses listed in A2 down, titles in B1 across Then in Y, In C2, copied down: =IF(COUNTA(A2:B2)<2,"",INDEX(X!$A$1:$D$6,MATCH(B2, X!$A:$A,0),MATCH(A2,X!$1:$1,0))) where in A2 down are Titles, in B2 down are Courses -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jim" wrote: I am trying to create a course catalog for online learning. I have created a matrix where I have courses listed down the left hand side and job titles accross the top. I want to be able to click in the boxes under the job titles to assign courses and have the information for each course auto-populate / auto-fill into another document or spreadsheet. Any suggestions? Thanks in advance! |
All times are GMT +1. The time now is 06:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com