I have a large range (24 columns by 50 rows) and the majority of the cell
values are zero, but there are about 10-20 that are not. However, these
10-20 values change position depending on other data. Does anyone have a
macro that can find the cells that have values and put the values into the
first column of another worksheet?