I have a worksheet that contains vehicle details. Column A contains vehicle serial numbers in ascending order. I want to select the serial number from a list then run a macro which selects the entire row ready for cutting or copying but I have no idea how to do it. Is there a simple way?
Why use a macro? Why not just use the LOOKUP function? You would have to sort the vehicale data sheet by the serial numbers. Also be careful if any of the serial numbers have leading zeroes as Excel may choose to see some as numbers and then that could mess up the sorting.