Automatic Admission Receipt Generate in Excel HD
Hello Friends , In this video tutorial you can learn Automatic Admission Receipt generate in Excel. I am using VLOOKUP function to generate one to more Student admission receipt in Excel.In admission No field I am using Text function to display auto admission no in excel table . Follow this steps- - In sheet 1 create a table - For Data entry of student record using FORM command -In sheet 2 Design Admission Receipt format -After designing Admission receipt add VLOOKUP function in selected field list. -Shortcut copy paste VLOOKUP function and change column index number. I hope you like this tutorial Thanking you You can watch ----------------------------------------------------------------------------------------------------------- Create Form in Excel - Data Entry Form https://youtu.be/MHvRRVlmnjo Auto ID Number in Excel Sheet Part 2 https://youtu.be/2uvyWX3Hss4 Auto ID Number in Excel Sheet Part-1 https://youtu.be/yQBcUk6YORk -------------------------------------------------------------------------------------------------- For more pls visit www.youtube.com/c/MCiTech #receiptinexcel#excelinvoicegenerator