exceldata
PMH Biostatistics
Overview
Workflow Development
Setup
Installing the package
Installing the Excel Macro
Creating your Personal Workbook
Adding the Macro to your Personal Workbook
Check the Installation
Workflow
Using the CheckData Macro
To Run the Macro
Editing the Dictionary Sheet
The importExcel Package
Example Import
Sample Data
Lisa Avery
Using the Excel dataChecker macro and the importExcel package
Check the Installation
Click on the Developer Tab
Click The Macros button
The PERSONAL.XLSB!CheckData macro should appear in the list of macro names
That’s it - you are all set to use the macro
