A little back story on the project, I have invoices I am wanting to put in this new workbook and have 2 sheets, paid and unpaid. I have a macro tied to a button that will insert a new row, change all the formatting and add a button to the end of the row that says "Paid", i can then add all of the invoice information. I can press the New Invoice button and it will correctly insert and reformat rows to my liking. I then have a second macro tied to the Paid button that should move the row the Paid button is on from the Unpaid sheet to the Paid sheet and reformats the row.

The problem i have now is that invoices do not get paid in the order i input them but each new Paid button that was created only points to the row it was created on (A6) so as I add row after row and an invoice 10 rows down is paid, i click the button and it removes the very top (A6) row and moves it to the Paid sheet, not the row i needed (A16).

I need to figure out how to make the buttons keep track of the row number they are currently on so that they moves the correct row. I know that lots of buttons is sloppy programming, and i would much rather have the initial macro add checkboxes that i can select when invoices are paid and have just 1 button to move all paid invoices but it's been like a decade since i did any programming and i can't remember how to do anything at all.


Thanks for the help,

Devon