I am trying to create a macro to auto populate an invoice template (excel) from data held within an excel spreadsheet, but I also want to specify the month for invoicing. e.g. If January is selected in a cell it takes only invoices that appear in January, then adds each row to the invoice for January
I have a basic understanding of Macros but wondered if anyone can help with this?
Happy to send the spreadsheets via private message.
Very new to VBA, would appreciate any help/feedback!