Hello Everyone,
I need some help developing a Macro which will find matches to my criteria, then return the line right below the matches.
For example I have a list (Example spreadsheet attached) with 4 columns of data. First two columns are names. The third column are days of the week and the forth column are the numbers 1 thru 4 in random order. I am constantly adding names, the day of the week and a random number to the bottom of the list each day. All my searches are based on the last entry to the list (from the bottom) up.. so say I want to search on the last 3 entries, which in this case would the random numbers 4,2,1. I would like to find all occurrences of 4,2,1 in the list (Sheet 1) in the example. There are 3 occurrences of 4,2,1 found in this list Hilighted in yellow. I need the very next entry after each of the 3 occurrences to be returned under Results, Hilighted light Blue.
My list has hundreds of entires.. and multiple columns A,B,C,D I would like the ability to be able to search on any of the columns, going back any number of entries from the bottom. I am adding names, days of the week and random numbers 1 thru 4 to the list daily. So the Macro should take that into account. There is another example on Sheet 2.
One last request, it would be great if there could be a button to reset/clear the search criteria and results.
I would greatly appreciate any help and Thank you all in advance.
Dave
I need some help developing a Macro which will find matches to my criteria, then return the line right below the matches.
For example I have a list (Example spreadsheet attached) with 4 columns of data. First two columns are names. The third column are days of the week and the forth column are the numbers 1 thru 4 in random order. I am constantly adding names, the day of the week and a random number to the bottom of the list each day. All my searches are based on the last entry to the list (from the bottom) up.. so say I want to search on the last 3 entries, which in this case would the random numbers 4,2,1. I would like to find all occurrences of 4,2,1 in the list (Sheet 1) in the example. There are 3 occurrences of 4,2,1 found in this list Hilighted in yellow. I need the very next entry after each of the 3 occurrences to be returned under Results, Hilighted light Blue.
My list has hundreds of entires.. and multiple columns A,B,C,D I would like the ability to be able to search on any of the columns, going back any number of entries from the bottom. I am adding names, days of the week and random numbers 1 thru 4 to the list daily. So the Macro should take that into account. There is another example on Sheet 2.
One last request, it would be great if there could be a button to reset/clear the search criteria and results.
I would greatly appreciate any help and Thank you all in advance.
Dave