I have 2 spreadsheets:
A : 1st spreadsheet with 2 worksheets:
A1) Worksheet containing fixed company address data (company name, address, VAT number)
A2) Worksheet with empty invoice template
B : 2nd spreadsheet
contains monthly income worksheet, every month the spreadsheet will be copied to a new file, and all existing data will be removed
What I need is a macro which copies the invoice date minus X days (X = random number between 3-14) from B, the company name and the amount of money to spreadsheet A, and prints the invoice at A2 to PDF (filename = invoice number). This macro must start at the first company at B, until there are no companies left and all invoices are printed to PDF.
I need instructions how to copy it to my existing accounting spreadsheet (identical to enclosed samples).
Attached XLS samples & a PDF file which should be one of the end results