Automated GST Billing SalesInvoice Tracking System Learn Excel in Malayalam

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=zQqF6nHB7qs

In this session, we can learn how to build automatic billing System, Sales Tracking System in Excel Malayalam also I’ve explained in easy STEP by STEP details about how to create an automated Invoice by just using some basic sum function and lookup feature and most important yes, few VBA codes.You can also create invoices instantly and print or save as PDF. In addition, you can quickly view the sales report over on the basis of given criteria. This Template is very useful for beginners, start-ups businesses and individuals as it helps in managing and organizing all your finances into one place. • Download file used in the video: https://drive.google.com/drive/folder... • VBA Code Given Below: • For New Invoice No • Range( H9 ).Value = Range( H9 ).Value + 1 • Range( d9 ).ClearContents • Range( F11 ).ClearContents • Range( c14:C24 ).ClearContents • Range( H14:H24 ).ClearContents • For Saving Data • Dim LastRow As Long • Dim sh As Worksheet • Set sh = Sheets( SALES REPORT ) • LastRow = sh.Range( A Rows.Count).End(xlUp).Row + 1 • sh.Range( A LastRow).Value = Range( I10 ).Value • sh.Range( B LastRow).Value = Range( H9 ).Value • sh.Range( C LastRow).Value = Range( D9 ).Value • sh.Range( D LastRow).Value = Range( I12 ).Value • sh.Range( E LastRow).Value = Range( D11 ).Value • sh.Range( F LastRow).Value = Range( J28 ).Value • sh.Range( G LastRow).Value = Range( J29 ).Value • sh.Range( H LastRow).Value = Range( J30 ).Value • sh.Range( I LastRow).Value = Range( J32 ).Value • For Saving Invoice (PDF) • ' SavePDF Macro • ' • ' • Range( C2:J34 ).Select • ActiveWindow.ScrollRow = 31 • ActiveWindow.ScrollRow = 30 • ActiveWindow.ScrollRow = 28 • ActiveWindow.ScrollRow = 24 • ActiveWindow.ScrollRow = 21 • ActiveWindow.ScrollRow = 18 • ActiveWindow.ScrollRow = 13 • ActiveWindow.ScrollRow = 7 • ActiveWindow.ScrollRow = 4 • ActiveWindow.ScrollRow = 2 • ActiveWindow.ScrollRow = 1 • Selection.Copy • Application.CutCopyMode = False • ChDir C:\\Users\\user\\Desktop\\Invoice PDF • Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ • C:\\Users\\user\\Desktop\\Invoice PDF\\ Sheets( BILLING ).Range( H9 ).Value, Quality _ • :=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _ • OpenAfterPublish:=False • ActiveWindow.SmallScroll Down:=-4 • Range( C2 ).Select • For Printing Invoice • ActiveWindow.SelectedSheets.PrintOut • Remember, after creating macros you cannot save the Excel file in a .XLSX format, you need to save it as a Macro enabled Excel file with .XLSM format • #AutomaticInvoiceInExcelMalayalam #StockManagementInExcelMalayalam #SalesTrackingInExcelMalayalam • ++++++++++++++++++++++ • If you want to find out more about how to learn excel in Malayalam or excel Malayalam tutorial, you must click: https://www.rowscolumns.com • Download file used in the video : https://www.rowscolumns.com/free-exce... • To learn Excel in English Click on : • FREE Excel Course (Basic to Advanced) • View my comprehensive courses: https://laurelss.com/instructor/952 • To learn Excel in English Click on: • FREE Excel Course (Basic to Advanced) • ++++++++++++++++++++++ • This YouTube channel is managed by Mohammed Alfan • Excel is one of the most widely used and powerful programs in the world. It is used in every sector and industry, from small businesses with only a few employees, to large multinational companies. In this video, Mohammed AlFan, who is a skilled Excel user, shows you how to create a simple, but effective spreadsheet. He goes through many useful tips and tricks that will help you build a successful spreadsheet. learn excel in English by watching this video, as it will teach you how to use the excel program in a short amount of time. People who searched for learn excel in Malayalam likewise searched for excel Malayalam tutorial in on YouTube, as most professionals are not getting the simple excel tips and tricks through other Channels. Please subscribe to this channel to get the latest updates on excel. • ++++++++++++++++++++++ • Let’s connect on social media: • Facebook: / skill2succced.alfan • LinkedIn: / mohammed-alfan-23a94b30 • Instagram: / z_one_clt • Twitter: / toalfan • ++++++++++++++++++++++

#############################

New on site