Move one record in a range to the top

I have 10 rows of data


Column A - ID
Column B - First Name
Column C - Last Name


Is there a way to move the row 3 to row to row 1 and

keep all other rows in the same order



for example using id's

1
2
3
4
5
6
7
8
9
10

move id 3 to first row would give me something like the following
3
1
2
4
5
6
7
8
9
10



thanks for any help


Josh

That worked great, Thanks.


Is there anyway to go one step further with an input box asking you what id you are looking for.

then it loops through the rows, if the id is found, it will give you the row number, if not, it will let you know, that id is not in those 10 rows.


thank you

Josh