Hail and well met to all you Excel masters. I am search of thy great wisdom for I am a meager peasant in comparison.
Now that I have done my groveling let me get down to business.
I have a series of workbooks that are used as checklists for various projects. Each of these projects is set up with the same format and I need to be able to pull reports on areas that fail, pass, or are pending. I can go through and cut and paste this info out of each of them by hand, but is very slow and time consuming. So what I am looking for is to have a report Excel page created that I can list what I am searching for and the location of the file. It would then pull the information and create a report of it in the Workbook I am in. I hope I explained that well enough, but here are the details of the documents below.
The Checklists have the following data.
Col A – Heading of Section
Col B- Tasks to be tested
Col C – Pass/Fail/Pending drop down list
Col D – Bug #
Col E – Tested By
Col F – Version Tested
Col G – Notes
Next is an example of the summary workbook. It is designed to be modular in case the checklist isn’t in the same format as all the others. It also includes the expected results based on the first example.
Edited by Nate: Removed 2nd Table, causing a problem, missing ending HTML tags...
Now that I have done my groveling let me get down to business.
I have a series of workbooks that are used as checklists for various projects. Each of these projects is set up with the same format and I need to be able to pull reports on areas that fail, pass, or are pending. I can go through and cut and paste this info out of each of them by hand, but is very slow and time consuming. So what I am looking for is to have a report Excel page created that I can list what I am searching for and the location of the file. It would then pull the information and create a report of it in the Workbook I am in. I hope I explained that well enough, but here are the details of the documents below.
The Checklists have the following data.
Col A – Heading of Section
Col B- Tasks to be tested
Col C – Pass/Fail/Pending drop down list
Col D – Bug #
Col E – Tested By
Col F – Version Tested
Col G – Notes
| UL2_8.03.05_V.1.xls | ||||||||
|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | |||
| 8 | Task | Pass/Fail | DevTrack# | Tested By | Version Tested | Notes | ||
| 9 | ||||||||
| 10 | Heading 1 | |||||||
| 11 | Task 1 | Pass | Tester 1 | 4 | ||||
| 12 | Task 2 | Pass | Tester 1 | 4 | ||||
| 13 | Task 3 | Fail | 12 | Tester 1 | 5 | Huge Fail | ||
| 14 | Task 4 | Pending | Tester 1 | 4 | ||||
| 15 | Task 5 | Fail | 23 | Tester 2 | 4 | Doesn't Work | ||
| 16 | Task 6 | Pass | Tester 1 | 6 | ||||
| 17 | Task 7 | Pass | Tester 1 | 4 | ||||
| 18 | Heading 2 | |||||||
| 19 | Task 1 | Pass | Tester 2 | 4 | ||||
| 20 | Task 2 | Pass | Tester 1 | 4 | ||||
| 21 | Task 3 | Pass | Tester 1 | 4 | ||||
| 22 | Task 4 | Pass | Tester 1 | 4 | ||||
| 23 | Task 5 | Fail | 45 | Tester 1 | 6 | Never Worked | ||
| 24 | Task 6 | Pass | Tester 1 | 4 | ||||
| 25 | Task 7 | Pending | Tester 1 | 4 | ||||
Tab 1 | ||||||||
Next is an example of the summary workbook. It is designed to be modular in case the checklist isn’t in the same format as all the others. It also includes the expected results based on the first example.
Edited by Nate: Removed 2nd Table, causing a problem, missing ending HTML tags...
