I need to be able to run a macro (Log_Invoice) each time a new invoice is completed, to record certain cell data on an Invoice Log within the same workbook. Then create a new worksheet (named "new invoice") with all data fields cleared, ready for the next invoice.
I have recorded the macro in the attached file to get started but do not know how to check the Invoice Log and only copy selected data (cells shaded in yellow) to the next blank line. The Invoice Log will not be cleared and current thinking is to retain soft copies of completed invoices also.
Thanks in advance for your kind guidance.
PS - If you clean-up the macro code and have the time, feel free to comment on your improvements for my learning benefit. Thx