FILE NAVIGATION SOFTWARE

FILE NAVIGATION SOFTWARE IN EXCEL Below is a documented series of VBA codes that can be applied to extract ALL Folders and Files within a user-selected folder. The data collated are extracted to an excel spreadsheet in which the user can apply search or filter to look for what they want. The extract also organized […]

MSSQL CSV IMPORT

Import a CSV File via MSSQL Below details a series of MSSQL scripts to perform a CSV Import into a MSSQL database where it can be used for other purposes. In the below example, i have used this to import a bank csv file and convert it to a double-entry trial balance that accountants can […]

EXCEL DATA VALIDATION

Create Excel Data Validation Dependent Lists Below are a series of excel formulas that can be used to create dependent lists for data validation. =INDIRECT(“CustTable[Customers]”) OR =INDEX(CustTable[Customers],1):INDEX(CustTable[Customers],COUNTA(CustTable[Customers])) =IF(OR(‘Invoice Register’!$D22=”Choose…”,’Invoice Register’!$D22=””),””,INDEX(CustTable,1,MATCH(‘Invoice Register’!$D22,CustTable[#Headers],0)):INDEX(CustTable,COUNTA(INDEX(CustTable,,MATCH(‘Invoice Register’!$D22,CustTable[#Headers],0))),MATCH(‘Invoice Register’!$D22,CustTable[#Headers],0)))