I can get the sales Report every three month and can calculate for term end at April every year. Need Description, Amount, CST, Sub Total, Grand Total automatically saved for all the invoice into 1 excel sheet so that we can calculate VAT easily.Ĥ.Need Invoice Increment in the form of Text Date and Number Like ED/0001/Jun14. Path for auto save cant work as its for Windows, need code for the path for MACĤ.After three month, we have to submit sales tax in India so need database for all the invoice. I merged B12-C-13 to make a common Cell B12.Didnt workedĢ. Watched the video but didnt helped out.ġ. Need AutoIncrement Invoice and AutoSave Invoice NumberĬopy Pasting the reference code below, Changed the Range as per my xlsm but showing Red while running. I am using Microsoft EXCEL MAC 2011 Version 14.0 Thanks for the outstanding forum on the Planet for the Excel Lovers.
0 Comments
Leave a Reply. |