This is a complex question and hope I can explain well enough to get an answer.
I need to be able to enter certain information on "Worksheet" and have it also enter information to on the worksheet called "Basic" or "Intermediate" (not shown here)
Some criteria is the following:
1. Only copy the start_date once for each Discipline once.
Ex: Discipline = "Other" for Start_date = "1/21/2011" and Discipline =
"Health" for Start_date = "1/21/2011", should only have 2 entries in the WS "Basic"
2. Also be able to over certain other fields that apply to those lines.
I guess the first thing it needs to do is determine whether to but the information on the "Basic" or "Intermediate" worksheet.
Am I asking to much? Do you need more explanation?
I hope this makes sense to you all and thanks again for the help.
Jim
<title>Excel Jeanie HTML</title>
<title>Excel Jeanie HTML</title>
I need to be able to enter certain information on "Worksheet" and have it also enter information to on the worksheet called "Basic" or "Intermediate" (not shown here)
Some criteria is the following:
1. Only copy the start_date once for each Discipline once.
Ex: Discipline = "Other" for Start_date = "1/21/2011" and Discipline =
"Health" for Start_date = "1/21/2011", should only have 2 entries in the WS "Basic"
2. Also be able to over certain other fields that apply to those lines.
I guess the first thing it needs to do is determine whether to but the information on the "Basic" or "Intermediate" worksheet.
Am I asking to much? Do you need more explanation?
I hope this makes sense to you all and thanks again for the help.
Jim
<title>Excel Jeanie HTML</title>
Excel Workbook | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
1 | EMA_Num | Status | COST | Last_Name | First_Name | Agency | Discipline | Course | Course_Loc | Start_Date | Sponsor | Given Name | OT | Backfill | Total | ||
2 | 09-13850 | Pending | Smith1 | Steve1 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 600 | 600 | ||||
3 | 09-13850 | Completed | Smith2 | Steve2 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 0 | 0 | ||||
4 | 09-13850 | Completed | Smith3 | Steve3 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 0 | 0 | ||||
5 | 09-13850 | Pending | Smith4 | Steve4 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 600 | 600 | ||||
6 | 09-13850 | Pending | Smith5 | Steve5 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 0 | 0 | ||||
7 | 09-13850 | Pending | Smith6 | Steve6 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 600 | 600 | ||||
8 | 09-13850 | Pending | Smith7 | Steve7 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 600 | 600 | ||||
9 | 09-13850 | Pending | Smith8 | Steve8 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 600 | 600 | ||||
10 | 09-13850 | Pending | Smith9 | Steve9 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 600 | 600 | ||||
11 | 09-13850 | Pending | Smith10 | Steve10 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 600 | 600 | ||||
12 | 09-13850 | Pending | Smith11 | Steve11 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 0 | 0 | ||||
13 | 09-13850 | Pending | Smith12 | Steve12 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 600 | 600 | ||||
14 | 09-13850 | Pending | Smith13 | Steve13 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 0 | 0 | ||||
15 | 09-13850 | Pending | Smith14 | Steve14 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 600 | 600 | ||||
16 | 09-13850 | Completed | Smith15 | Steve15 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 0 | 0 | ||||
17 | 09-13850 | Pending | Smith16 | Steve16 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 600 | 600 | ||||
18 | 09-13850 | Pending | Smith17 | Steve17 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 600 | 600 | ||||
19 | 09-13850 | Pending | Smith18 | Steve18 | XYZ | Other | Basic | NA | 1/21/2011 | None | NA | 0 | 0 | ||||
20 | 11-23149 | Pending | Smith19 | Steve19 | XYZ | Other | Basic | NA | 8/26/2011 | None | NA | 600 | 600 | ||||
21 | TOTAL | 7,200 | |||||||||||||||
Worksheet |
<title>Excel Jeanie HTML</title>
Excel Workbook | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | M | N | |||
3 | BASIC | ||||||||||||||
4 | DATE | HOURS | AGENCY TYPE | LOCATION | TOPIC | EVENT TYPE | GIVEN BY(NAME) | STUDENTS TRAINED (#) | DELIVERY COST | B/O | OT | COST | NOTES | ||
5 | |||||||||||||||
6 | 2 | 16.0 | Pull Down | 34 | $3,600 | Pull Down | |||||||||
7 | |||||||||||||||
8 | 1/21/2011 | 8.0 | Other | Santa Ana | Basic | 2 | 400 | ||||||||
9 | 1/21/2011 | 8.0 | Other | Santa Ana | Basic | 3 | 400 | ||||||||
10 | 1/21/2011 | 8.0 | Other | Santa Ana | Basic | 4 | 400 | ||||||||
11 | 1/21/2011 | 8.0 | Other | Santa Ana | Basic | 5 | 400 | ||||||||
12 | 1/21/2011 | 8.0 | Other | Santa Ana | Basic | 6 | 400 | ||||||||
13 | 2/21/2011 | 8.0 | Other | Santa Ana | Basic | 2 | 400 | ||||||||
14 | 2/21/2011 | 8.0 | Other | Santa Ana | Basic | 3 | 400 | ||||||||
15 | 2/21/2011 | 8.0 | Other | Santa Ana | Basic | 4 | 400 | ||||||||
16 | 2/21/2011 | 8.0 | Health | Santa Ana | Basic | 5 | 400 | ||||||||
Basic |