I've got a project where I need to combine data from several Excel spreadsheets, and generate multiple files from that combined data. Every month, about 10 or so people email me their monthly reports in Excel. This is a simple spreadsheet with identical columns. Some people would have more rows of data than others. I'd like to take each of those monthly reports and simply drag them from the email to an icon, and drop in the icon, and have the program import those spreadsheet entries into another Excel spreadsheet that is the "Master" spreadsheet for that month. After I finished editing the master Excel file, then I'd like to go back to the application, and create individual excel files from that master monthly excel file, for each value in a particular column called "Principal". The "Principal" field will have one of about 12 different 2 or 3 letter values, such as XIL, CIC, ABC, etc. Each file should have a standard naming convention, such as [url removed, login to view] (for the master roll-up) [url removed, login to view] [url removed, login to view] [url removed, login to view] etc... Thanks, Bob Sorrells *** Updated *** Added zip file with examples
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.