| Problem You generate data month-over-month, day-over-day. How do you know the data is right. If you make changes to your process how do you know you didn't break anything? Solution Compare 2 spreadsheets and tell me if they're the same or where they are different. The system should work with multiple sheets. I have to tell the system the name of the two files, the sheets to compare and other stats. I want to select the report from a drop-down. Based on the report I select system will know what I want to do. I press "Run" button to start the process. This system will open the two files and compare column by column. I must tell it where the column headers are so it can check the two files column by column. So for each column, I want to compare the sum and the unique count. While the program is running I want to give status to the user of % done. If any changes are > 20% I want to highlight the row in yellow. if the file is ok (no yellow) it will have the name ...-ok If there is yellow the filename should have the name ...-please-check. |