Help: multi function macro needed - copy row, reset checkboxes, erase cells.

[Acubed]

Hi
I am extremely new to the programming game and I am in need of help.

I have made a spreadsheet with multiple checkboxes. The boxes trigger a value in a different row.
What I need is a macro that will copy the info from that different row to the next available row and then clear some of the cells (Name Addy etc) in that row and reset the checkbox values to zero.

I am hoping a checkbox can be used, (called-done) at the end of the row to allow me to enter a second and third client and so on.
I did this so I can enter the clients purchases and total the cost.(I did this already) While keeping a running total. It's monthly repeat business.

I found the code to move the row, but can't find the reset and erase.

Any help would be greatly appreciated.

Thanks
ACUBED

[alansidman]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Acubed]

I'm sorry I am still learning Excel, I'm not sure how to attach a sample work book. I can forward a copy, but to do so would reveal confidential information regarding my business.
I hope this is enough
Acubed

[alansidman]

The reason for attaching a sample workbook is so that people here do not have to reconstruct your work. They can see the formatting you did that may affect the outcomes and test their solution with your sample data. A picture of your work is meaningless and a waste of time. As to confidential data, dummy it up so that it is not confidential.

Please read the forum rules and pay particular attention to the section: Want to get your question answered quickly? click here-->http://www.excelforum.com/forum-rule...rum-rules.html

[Acubed]

Sorry for my stubbornness.
As requested I hope I did this right.

Acubed

If i have missed anything, please let me know. Thanks A3