📚🎓🔎 Excel's XLOOKUP function to the rescue! Effortlessly fetch student grades based on their names and performance! 📚🎓🔎 When it comes to retrieving grades for individual students, the XLOOKUP function is a game-changer. It enables you to search for a specific value in one column and return a corresponding value from another column, making student grade retrieval a breeze. The XLOOKUP function is incredibly versatile and efficient, making it a favorite tool for searching and retrieving data

Make file list from folder 📁 #vikominstitute #excel #vba CODE Sub LoopThroughFiles() Dim oFSO As Object Dim oFolder As Object Dim oFile As Object Dim i As Integer Set oFSO = CreateObject("Scripting.FileSystemObject") Set oFolder = oFSO.GetFolder("E:SHORTSShorts") For Each oFile In oFolder.Files Cells(i 1, 1) = oFile.Name i = i 1 Next oFile End Sub | Excel By Vikal