Visual Basic

A collection of visual basic scripts for Access and Excel that have saved countless hours:

Access

  • Create 1 Workbook with Multiple Sheets based on Values in Column
  • Print 100 one page reports, rather than 1 one-hundred page report

Excel

  • Save tabs as new workbooks (Excel)
  • tab out data based on Cell Value (Excel)