Editing Value Automatically
There is an Excel file that teaches how to perform the Editing Value Automatically operation.
Excel Editing Value Automatically
This workbook demonstrates editing value automatically using VBA macros on a 1-row data layout.
Hope it is useful.