How can I record a macro to be use in a command button or after a particular cell the data has been enter to insert a row below the last cell with data? I have a table with dates and numbers that is use to plot several graphs and I would like to use a macro to insert a row automatically, so when next time to input a new date and numbers the macro will insert the row just below the last entry.