Hello, we use an excel document as an invoice for our clients. Once it's created specifically to their info it only needs to be opened each month to change the "date & month" in 2 cells. I was hoping there was a way to apply that change to the 300 + invoices (workbooks) with out having to open each one. Appreciate any help I can get. I've attached a sample of the invoice and highlighted the 2 cells that need to be updated each month.
Thank you
Thank you