I have numbers listed in column A. They are listed 1 through 10 with 1 being in A-1 and 2 being in A-2 all the way through 10 with 10 being in A-10. If I hide row 5, I want the column to auto populate so column A will now have the numbers listed 1-9. Can anyone help?