Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging data
Sheet1 contains a list of course codes and the dates the courses are running
eg. CSB00 09-Jan-2006 CSB00 10-Jan-2006 CSB01 09-Jan-2006 CSB02 10-Jan-2006 Sheet2 contains a list of students and the courses assigned to the students eg. James CSB00 Dep1 Jones CSB00 Dept1 Sam CSB00 Dept2 John CSB00 Dept2 (Data in different cells for name, course, Dept) Please a macro or VB to assign students (max say 2 per course date) to course dates and distribute across department ie one fron Dept1 and the other from Dept2. Please make it as general as possible as I wish to apply to a large database Thanks in advance -- JA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging data
Hi
Your input is clear but what do you want your output to look like? You say "Please a macro or VB to assign students (max say 2 per course date) to course dates and distribute across department ie one fron Dept1 and the other from Dept2." What should that look like? Give a few lines of example output. What does "max say..." mean? What decides if there are 2, 1 or 0? Spell out the decision clearly. What does "as general as possible" mean? regards Paul asante_za wrote: Sheet1 contains a list of course codes and the dates the courses are running eg. CSB00 09-Jan-2006 CSB00 10-Jan-2006 CSB01 09-Jan-2006 CSB02 10-Jan-2006 Sheet2 contains a list of students and the courses assigned to the students eg. James CSB00 Dep1 Jones CSB00 Dept1 Sam CSB00 Dept2 John CSB00 Dept2 (Data in different cells for name, course, Dept) Please a macro or VB to assign students (max say 2 per course date) to course dates and distribute across department ie one fron Dept1 and the other from Dept2. Please make it as general as possible as I wish to apply to a large database Thanks in advance -- JA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging data
Further to Paul's note, are there only ever two departments? What are the
maximums - courses, attendees,departments etc. What happems in there are more potential attendees than places (number of potential attendees max(courses planned) * max(attendees per course)? " wrote: Hi Your input is clear but what do you want your output to look like? You say "Please a macro or VB to assign students (max say 2 per course date) to course dates and distribute across department ie one fron Dept1 and the other from Dept2." What should that look like? Give a few lines of example output. What does "max say..." mean? What decides if there are 2, 1 or 0? Spell out the decision clearly. What does "as general as possible" mean? regards Paul asante_za wrote: Sheet1 contains a list of course codes and the dates the courses are running eg. CSB00 09-Jan-2006 CSB00 10-Jan-2006 CSB01 09-Jan-2006 CSB02 10-Jan-2006 Sheet2 contains a list of students and the courses assigned to the students eg. James CSB00 Dep1 Jones CSB00 Dept1 Sam CSB00 Dept2 John CSB00 Dept2 (Data in different cells for name, course, Dept) Please a macro or VB to assign students (max say 2 per course date) to course dates and distribute across department ie one fron Dept1 and the other from Dept2. Please make it as general as possible as I wish to apply to a large database Thanks in advance -- JA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging data from 2 data excel sheets | Excel Discussion (Misc queries) | |||
Merging multiple columns of data into one column of data | Excel Discussion (Misc queries) | |||
Merging data | Excel Programming | |||
Should Merging workbooks pick up new data or only edited data? | Excel Worksheet Functions | |||
Scanning for Duplicate Data in a Column, Merging Data and Finally Removing All Duplicates...? | Excel Programming |