manik.nag
06-24-2015, 07:22 AM
Hi all,
I'm using an excel file where I've to do the below acitivity, can it be done using a VBA Macro.
Step 1 : Select "May-15" (previous month) from "Month" column and select "Q1", "Q2" and "Q3" from "Quintile" column and then delete the all rows.
Step 2 : Select "May-15" (previous month) from "Month" column remove duplicate EIN's from "EIN" column.
Step 3 : Select "June-15" (current month) from "Month" column lookup the Unique EIN with June data and delete the #n/a from June data from column R
all this above acivity to be done from 3 different sheet in a same way and the sheet names are "OTR Raw", "AHT Raw" and "28 CPS Raw"
With Regards
Manik Nag
I'm using an excel file where I've to do the below acitivity, can it be done using a VBA Macro.
Step 1 : Select "May-15" (previous month) from "Month" column and select "Q1", "Q2" and "Q3" from "Quintile" column and then delete the all rows.
Step 2 : Select "May-15" (previous month) from "Month" column remove duplicate EIN's from "EIN" column.
Step 3 : Select "June-15" (current month) from "Month" column lookup the Unique EIN with June data and delete the #n/a from June data from column R
all this above acivity to be done from 3 different sheet in a same way and the sheet names are "OTR Raw", "AHT Raw" and "28 CPS Raw"
With Regards
Manik Nag