Hello! I am working through manual data trying to organize a range of information by inputting numbers 1 - n. Example I have an excel sheet populated with x number of cells on both the x and y axis. Column A is blank to allow for me to manually input an integer 1 - n. I want to be able to be able to label random cells in column A 1 - n and then based on the number input I would like that to then be copied in numerical order into another sheet.
A B C D....
App AB CD
1 EF GH IJ
KL MN OP
3 QR ST UV
2 WX YZ AB
In the example above based on my input of the numbers in column A the VBA should copy the rows with numbers to another sheet and order them in numerical order. Below is what the result should be if the macro worked. Row length should not have a cell range for being copied then number of integers can be capped at 100.
A B C D....
1 EF GH IJ
2 WX YZ AB
3 QR ST UV
I need it to copy the source list to another sheet. If I have a set of data that spans through row 100 and I only order 1 - 10 I want those rows I put a 1 - 10 in to copy and paste to a new tab in order 1 - 10.
Bookmarks