Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
Can I create a checklist that changes color as items are checked? | Excel Discussion (Misc queries) | |||
How to create a checklist with check mark boxes. | Setting up and Configuration of Excel | |||
Using Excel Auto Fill | Excel Discussion (Misc queries) | |||
how do i create a completion of task checklist | Charts and Charting in Excel |