hi,
im using excel 2016 and want to print the invoice to pdf, list of data will provided in sheet 1 and format in sheet 2.
Sheet 1 example: Invoice no, Customer Name, Address, GST No, HSN, Product spec, invoice amount in rows.
Sheet 2 - invoice format with Vlookup to match data from sheet 1 ( Challenge - converting invoice amount to word)
Print has to be saved as invoice no. as per the sheet 1 rows.
request to help with solution to this problem
im using excel 2016 and want to print the invoice to pdf, list of data will provided in sheet 1 and format in sheet 2.
Sheet 1 example: Invoice no, Customer Name, Address, GST No, HSN, Product spec, invoice amount in rows.
Sheet 2 - invoice format with Vlookup to match data from sheet 1 ( Challenge - converting invoice amount to word)
Print has to be saved as invoice no. as per the sheet 1 rows.
request to help with solution to this problem