Simple Daily Data Hack

Here I'll show you how to use the least amount of codes to automate the most tedious data tasks.
This series of tutorials will teach you how to automate your daily administrative tasks by coding.
You don't need to study data science or work on some meta-data projects.
Life is getting better!

Menu

Microsoft Excel VBA Tutorials

#1: Inserting today's date in one click

This tutorial shows the VBA macro you need to insert today's date by clicking a bottom.

Clinical Research Data 101

#2: Setting up the same header

This tutorial shows you how to set up the same header variables for every spreadsheet.

Clinical Research Data 101

#3: Assigning site names based on assigned site numbers

This tutorial shows you how to automatically delete the unused column, loop through all rows to assign site names based on assigned site numbers.

Clinical Research Data 101

#4: Generating a new list based on filtered values

This tutorial shows you how to automatically filter the spreadsheet, find the IDs with missing values and then copy the list to a new sheet.

Clinical Research Data 101