Posted: 8/12/2009 8:22:33 AM EDT
|
I am looking and asking for a little bit of help. I am hoping I can create a macro in Excel (2007) that can let me compare two spreadsheets from different books. What I have is a book, I will call it 1, that all of our results go into that have identifiers attached to them. The spreadsheet is filtered, so I can look for specific information. This spreadsheet is not changeable in that I cannot change the order in which the fields are laid out. On a daily basis I will be going to a website that these results are entered into. I can export the results into another spreadsheet, I will call it 2, and I can alter the fields to be in the same order as 1. I would like to be able to run a macro that compares the two spreadsheets against each other and have it generate a report that tells me what disparities they have from each other. Is there a way to do this? Or is that clear as mud? |
|
What kind of disparities do you want reported? Do you just want an indication that Book1 Cell_A1 is different than Book2 Cell_A1 Or do you need to perform any mathematical functions on cells that differ from eachother? Below is a basic framework for what I think you're going for. Please tell me if I am wrong: Master Workbook Downloaded Values Result Workbook or WorkSheet Have you every considered moving to a database? This would simplify things greatly. |
|
That is very close to what I am looking for. I can't do the database as the book we have on hand is provided by our customer and is for their benefit. A better idea of what I am dealing with: Test requirement Test Type Result BTR-XXXX XXXX Pass/Fail/NA/No Run/Blocked Each field has its own BTR number with the test type that corresponds with it. There are 3 different columns in book 1 that we put our results in based on passing, failing, or remaining (which is left for blocked, NA, or no run. The spreadsheet that I export from the website will give me those areas listed above. ETA: I found this tool, but I must be retarded because I can't figure out exactly what to do. When I do what I think is the right thing, it takes forever for it to run. I canceled it at a little over an hour of it comparing the two spreadsheets. |