I need to copy a specific row (row 10) of worksheet1 and paste it to the bottom of the row each time I run the macro. Row 10 needs to be hidden after copying. Each time when I run a macro to insert a new row, a new row has to be inserted into the bottom row.
Need support. Thanks.
Need support. Thanks.