Updating Numbers In Bulk
There is an Excel file that teaches how to perform the Updating Numbers In Bulk operation.
Excel Updating Numbers in Bulk
This workbook demonstrates updating numbers in bulk using VBA macros on a 19-row data layout.
Hope it is useful.