Hi,
I have a workbook with sheet1, which i would like to duplicate the data in the next empty row.
i have a range of data lets say from column A to D and the amount of data changes it could be 10 rows or 20 rows. id like to duplicate this data in the next empty row. i would need to do this a few times if its possible to do this & if its possible can there be a cell to enter a number of times its duplicated? is it possible to color code each copy to differentiate each one. if it can't be done with VBA is there a better way to achieve it.
Many thanks for any advice
Mattless1
I have a workbook with sheet1, which i would like to duplicate the data in the next empty row.
i have a range of data lets say from column A to D and the amount of data changes it could be 10 rows or 20 rows. id like to duplicate this data in the next empty row. i would need to do this a few times if its possible to do this & if its possible can there be a cell to enter a number of times its duplicated? is it possible to color code each copy to differentiate each one. if it can't be done with VBA is there a better way to achieve it.
Many thanks for any advice
Mattless1