R
Robert Crandal
My sheet contains several rows of data and the number or
rows will grow each day. At the end of the year, I'm
guessing that this sheet will contain between 500 and 600
rows of data.
I created a search macro which basically steps though each
row one at a time (using a For-Next loop). I then do simple
string comparison to check if the row of data matches the
search criteria.
If anyone else here was given the task of creating a similar
searching system in Excel, what would you do?? I often
hear about using auto filters and VLOOKUP & MATCH
functions, so I often wonder if my search method is
too simple minded or not.
I'd appreciate any opinions. thank u
rows will grow each day. At the end of the year, I'm
guessing that this sheet will contain between 500 and 600
rows of data.
I created a search macro which basically steps though each
row one at a time (using a For-Next loop). I then do simple
string comparison to check if the row of data matches the
search criteria.
If anyone else here was given the task of creating a similar
searching system in Excel, what would you do?? I often
hear about using auto filters and VLOOKUP & MATCH
functions, so I often wonder if my search method is
too simple minded or not.
I'd appreciate any opinions. thank u