MS Excel Formula Magic

Generate a list of files from the OS directory specified in a cell using MS Excel. Start with a Excel Workbook and follow these steps to create a named formula. From the Formula menu choose Define Name -> Define Name From New Name Dialog box provide formula name, say FilesList. Leave Scope to Workbook. In […]

Continue Reading