Good morning or evening depending where you're located,
I have a sheet where I need to select a range of data from A1 to AExx. The row value of AE is determined by the creative keyword "stop." The word "stop" appears in column AF where the last row appears that meets my criteria. I also have a cell reference that returns the row number where the word "stop" occurs. So, the selection could be done by finding the instance of the word "stop" by searching column AF or by referencing cell AH2 (which contains the row number) to determin the last row of the range. Either way is fine withh me.
Thanks for any help,
Jeremy
I have a sheet where I need to select a range of data from A1 to AExx. The row value of AE is determined by the creative keyword "stop." The word "stop" appears in column AF where the last row appears that meets my criteria. I also have a cell reference that returns the row number where the word "stop" occurs. So, the selection could be done by finding the instance of the word "stop" by searching column AF or by referencing cell AH2 (which contains the row number) to determin the last row of the range. Either way is fine withh me.
Thanks for any help,
Jeremy