Is it possible to have a macro that when clicked the value of highlighted cells are inputted into a table and the values in these highlighted cells are cleared. Then when the cells have data in them again and the macro is clicked again these next set of values are inserted into the next row of the table.