If I have numbers posted in column A from 1-10 with 1 being in A-1 and 2
being in A-2 and so on with 10 being in A-10. If I hide row 5, I want the
numbers to auto populate so column A now has the numbers 1-9. Does anyone
know how I can do this?