Macro to increment column and copy columns to next row (check box included)

Hi,
I am trying to copy the entire row into a new row, but having problems with the functioning of the check box. check by clicking the check box C7, it will also check the check box C8 as I copied it from above.

I want to create a macro which will create a new row and automatically increment the value in Column A by one, and copy the contents of Columns B, C, E, F .. as it is.

For example in the attachment, when I run the macro it should be able to print the value 27000.05 in A8 and copy the remaining values from the above rows. Making sure that the corresponding check box functions well.

Thank You.

I tried this code, It will copy all the columns into next row but, but it would not solve the problem of the check box.

Please Login or Register  to view this content.

After a long wait for help from the moderators, I gave up and started solving this problem on my own with the very little programming knowledge I have and succeeded.

Please Login or Register  to view this content.