[login to view URL]
I want to create a program that will update two excel lists in a particular way. You can see the program layout in the link I provided above.
Data files:
Two excel files (or one with two tabs). Each spreadsheet contains 3 columns: Last First Names(given), some Date(given), and a last column that will be updated by this program.
Main Program Window and List Window:
Will include three buttons: List1, List2, Update Lists.
Clicking on List1 or List2 will open a window that will show all the info in that spreadsheet. The data can be edited and thus we have a "Save" and "Cancel" buttons that will either save and close or not save but still close this window.
Update Window:
Clicking on "Update Lists" button will open this Update Window. The main features of this program are in this window.
This window has several stages:
1. It's has no data when it's opened.
2. You enter the data into the manual list either by typing or by copy-paste.
3. You click on "Find" button. The program will check if there is a row in any of the lists that has the first and last names that match to the manual list. In other words, we check to see if we have the names from the manual list in any of our given two lists.
Example of successful and unsuccessful matches:
John Smith = John Smith
Smith John = John Smith
Smith John = john smith
Smith-John = John Smith
Johny Smith != Smith John
John Smith Y != Smith John
John Smith != John Smith Y
John Doe Smith != John Doe
John Doe Smith != John Smith
John Doe Smith = John Smith Doe
When a match is found in some list (or both), it should be displayed in its column. The same name in manual column should change its color to be the same color as the color of the title above each list column. If the person from the manual list was found on both lists, then it will be colored in some third different color (blue).
4."Find" button disappears (or disabled). We now have the "Update" button. We now enter some string into the Date input box. This string (including comma) will be appended to the THIRD column of each list and only to the rows of the found names.
5."Update" button disappears (or disabled), Date input box becomes un-editable, but still holds the string. We now have the "Save All" and "Print" buttons. Save All button will save List1 and List2 to the same location where they were read from. The manual list will get saved to a new excel file. The program will ask the user where to save it and by what name.
6."Print" this function will print the manual list and the two partial lists of names that were found in list1 and list2. Because the size of the lists may vary, the proper way would be two print each list separately.
Note:
Only "Save" and "Save All" buttons can modify permanently the contents of list1 and list2 excel files.
If you have any suggestions or recommendations on how to improve or make this program better, please let me know.