P
Paul Peterson - Velox Consulting, LLC
I want to perform the following search:
1 - Search a worksheet with a list like the following:
C1 C2
R 1 - John Smith A
R 2 - John Smith A
R 3 - John Smith A
R 4 - Bob Jones 2
R 5 - Bob Jones 2
2 - I want to read that worksheet and create a report for all of the
occurrences of John Smith - the report would look like this:
C1 C2
R 1 - John Smith A
R 2 - John Smith A
R 3 - John Smith A
3 - In other words, I'd like to scan a worksheet and retrieve all
occurrences for a specific value - in this case, all occurrences and related
date for John Smith.
Any help will be greatly appreciated.
Paul C. Peterson
Velox Consulting, LLC
1 - Search a worksheet with a list like the following:
C1 C2
R 1 - John Smith A
R 2 - John Smith A
R 3 - John Smith A
R 4 - Bob Jones 2
R 5 - Bob Jones 2
2 - I want to read that worksheet and create a report for all of the
occurrences of John Smith - the report would look like this:
C1 C2
R 1 - John Smith A
R 2 - John Smith A
R 3 - John Smith A
3 - In other words, I'd like to scan a worksheet and retrieve all
occurrences for a specific value - in this case, all occurrences and related
date for John Smith.
Any help will be greatly appreciated.
Paul C. Peterson
Velox Consulting, LLC