Devam Ediyor

523948 Excel Macro

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

Beceriler: Her şey Kabul, Excel, PDF, Şablonlar, Visual Basic

Daha fazlasını görün: name address template excel, company invoice template excel, excel invoice template , spreadsheet excel accounting, macro, fixed income, excel accounting, accounting spreadsheet, excel contains, excel random number, excel accounting worksheet, xls visual basic, copy pdf excel macro, vat excel template, accounting spreadsheet template, basic invoice template, macro spreadsheet, copy pdf template excel, invoice macro excel template, basic accounting excel template, copy pdf excel file, macro address, excel macro data pdf, companies address data excel, company name address xls

İşveren Hakkında:
( 7 değerlendirme ) Edegem, Belgium

Proje NO: #2269886