ok , this is better but in sheet1 i have 17 RANDOM numbers from 1 to 70 (sort from A2 to Q2) and let say the consecutive number are 21,22 and 37,38
in sheet2 i have a table from A2 to BR2 and i want to copy the consecutive numbers like this.please see the example in the attachments
Bookmarks