Thanks again. What you are presenting here does what I need to do. The thing is I’m trying to do it without a button so that it’ll work just as a formula would. When data is put into a cell the results are automatically displayed. This will be just one part of a long sequence. It won’t be the beginning or it won’t be the end of the sequence just one part of the sequence. When completed I want to paste a string in Column A and get the desired results in column T without having to interact with the process. Thanks