Need help getting buttons to command correct row

[azreark1]

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

[bakerman2]

A sample file with non sensitive data and the codes you are currently using can help a lot in getting a to the point answer.

Regards, bakerman2

[azreark1]

Here you go.

[bakerman2]

Devon,

Try next one.
When you click Paid Invoices button a Userform appears. In that userform is a listbox with all open Invoices. You can select one or more invoices by clicking on them.
After selecting click Move to paid button and all selected invoices are copied to Paid Invoices sheet and deleted from Open Invoices sheet.

[azreark1]

Hey that works really good! You did a lot more than i was expecting, i was ready for just some coaching on code.

[bakerman2]

Nice to hear.
Why not make a similar userform for inputting invoices? Or combine the two things in one ?
That way you don't have to mess around on your spreadsheet.
Let me know if there's any interest for that.