All, I've built several macros into my program, but hit a wall on the last problem. This document is a log book that invoices my customers. On the Invoice sheet i input the customer name and any unbilled lessons show up. I have a macro that copies the built invoice to a tracker on the right side and displays a PDF for billing. What I want is a macro that updates the student data sheet with a 'Billed' status for each applicable lesson and the invoice 3. I did some code at the bottom that lists the cells that would need updating, but I'm having trouble working code apply those updates, even though i know the cells that need it. Any thoughts.


It would also be nice to have a macro that updated the status to paid, once I updated the invoice tracker.

test.xlsm