I amy trying to copy the current value of a row from one worksheet (Data
validated list) to another worksheet. The first time the destination is
"A50", the second time has to be "A51" so as not to overwrite previous copy.
In cell I12 is the selected sequence number to assist (1,2,3,4,5...)but I
cant figure out how to use the value in I12 to advance the destination from
A50 plus that value.