I have a workbook which records the results of test cases across various lines of business. Each line of business has it's own worksheet with test case numbers, description, results etc.
As each tester completes a test, they put their initials against a test case. It's these initials that I'm trying to count. I need to find the total number of test cases that tester has completed over all lines of business (a range of worksheets) and summarise.
I've written a small macro which determines the individual testers in a worksheet (for example, there were 3 testers who worked on a particular line of business, their initals being ab, cd and ef) but I can't figure out how to do this across multiple sheets (determine how many testers worked on the entire project and what their initials were) and then produce a count of all the test cases they initialed over all sheets.
All initials are in column C of each worksheet. As more testers may be brought in to test over the length of the project, I need to keep it dynamic, rather than hard coding the tester intials, which is why my initial macro looked promising.
I'd be grateful for any advice you may have.
As each tester completes a test, they put their initials against a test case. It's these initials that I'm trying to count. I need to find the total number of test cases that tester has completed over all lines of business (a range of worksheets) and summarise.
I've written a small macro which determines the individual testers in a worksheet (for example, there were 3 testers who worked on a particular line of business, their initals being ab, cd and ef) but I can't figure out how to do this across multiple sheets (determine how many testers worked on the entire project and what their initials were) and then produce a count of all the test cases they initialed over all sheets.
All initials are in column C of each worksheet. As more testers may be brought in to test over the length of the project, I need to keep it dynamic, rather than hard coding the tester intials, which is why my initial macro looked promising.
I'd be grateful for any advice you may have.