Hello, Thanks for the response here. I’ve been experimenting here with your solution but I’m still having a few issues. I used X and Z for examples for the columns where in reality they are AW and G so it takes some time to arrow to the desired column. Also, in my column X (in the X,Z example) everything in column X is also populated from a formula so I have the same issue here. Is there possibly another method? Basically what I want to do is select all the cells in a particular column that appear to have data so some script I'm running can copy it for something in another program. I do not want to include the cells that appear to have no data even though the cell has a TRIM formula that could populated it another scenario. The data in each of the sales that I want to select/copy contains numbers and letters if that matters. Thanks