Hello all,
I'd like to create a macro to find a value (text) in a column where multiple cells in this column may contain this value. For those rows found, I'd like to store certain cell's information from that row in an array. Can anyone advise how to do this?
I have a named range on the header cell of the column in question.
The search column will grow over time, so not sure if its best to search the entire column or if there is a better way to limit the search ? ....thoughts?
Thanks in advance!
I'd like to create a macro to find a value (text) in a column where multiple cells in this column may contain this value. For those rows found, I'd like to store certain cell's information from that row in an array. Can anyone advise how to do this?
I have a named range on the header cell of the column in question.
The search column will grow over time, so not sure if its best to search the entire column or if there is a better way to limit the search ? ....thoughts?
Thanks in advance!