I have a sheet with 30 reports. I need to find the one called "APPL" at the beginning but only the one that has the cell "iTap" in an area one to three rows below it in some column. I want to select what is one cell below "iTap".
I have a sheet with 30 reports. I need to find the one called "APPL" at the beginning but only the one that has the cell "iTap" in an area one to three rows below it in some column. I want to select what is one cell below "iTap".
Please Login or Register to view this content.
Last edited by ragulduy; 11-12-2013 at 11:59 AM.
Maybe:
Please Login or Register to view this content.
@John,
Need to search the entire column for itap and that will exit the loop after the first APPL. I think you need:
Please Login or Register to view this content.
@yudlugar - Thanks for the insight, but I wasn't sure if there would be more than one "APPL".
"I need to find the one called "APPL" at the beginning". BTW your code is much more efficient.
Can I also find the report with both APPL and iTap and search for "Daily Excess"? between that first APPL with iTap found and the next occurence of APPL?
Last edited by frank35; 11-14-2013 at 09:24 AM.
anything on this?
Can you attach a file with some sample data to view? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
( many similar reports)
find APPL and iTap within 5 rows from each other and find the next report called APPL iFlat report. Within that range find "LABEL TO FIND" (then go one below to get the example 1,000,000.00
report APPL report report report report report report
report report report report NOTiTap report report report
report report report report report report report report
report report report report report report report report
report report report report LABEL TO FIND report report
report report report report 9,999,999.99 report report
report APPL report report report report report report
report report report report iTap report report report <-- APPL iTap reports start here, search from here
report report report report report report report report
report report report report report report report report
report report report report report report report report
report report report report report report report report
report APPL report report report report report report
report report report report iTap report report report
report report report report report report report report
report report report report report report report report
report report report report LABEL TO FIND report report
report report report report 1,000,000.00 report report <-- I want to find this number within the APPL iTap reports
report APPL report report report report report report
report report report report NOTiTap report report report
report report report report report report report report
report report report report report report report report
report report report report report report report report
report report report report 9,999,999.99 report report
report APPL report report report report report report <-- search ends here
report report report report iFlat report report report
report report report report report report report report
report report report report report report report report
report report report report report report report report
report report report report report report report report
(similar reports with APPL and others and iTap and others at beginning of reports)
so basically what you did before but times two and then a third search between the rows found by the two searches.
anything on this?
What do you want to do with the information once found?
This will find the second instance and highlight?
Please Login or Register to view this content.
this helps to find it in the example but not in the actual document, as it is always structured differently, look at the additional comments please.
Let me explain in another way: I need:
In an Excel 07 ninja-report (very long) the following is needed to create a limited search
Search where ABC and 100 are in any cell within 2 rows from each other
Search where ZZZ and 100 are in any cell within 2 rows from each other
Search for Gold to find the value in the cell to the right of it but in the range of the previous two searches' rows.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks