Let's say I have a spreadsheet in which a unique number
is entered into column A, rows 1 through 5.

Column A
Row 1 100
Row 2 200
Row 3 300
Row 4 400
Row 5 500

I need a macro that will insert 9 rows after each entry,
copying original value. To further clarify, the macro
needs to read the value of cell 1A (100), and then insert
9 rows underneath containing the same value (100). I need
this done for all 5 original rows. Thanks.