LoraKnight
New Member
- Joined
- Jun 18, 2013
- Messages
- 14
I need a code to run to remove all rows that Subtotal 0 in the "Other Dr" column
Here is an example of the sheet.
Practice Code Date Svc From Pat Person Nbr Pat First Name Pat Last Name Primary Doctor Other Dr
GREE 2/2/2015 55 Nick Smith 99233
2/2/2015 Count 1 0
GREE 2/3/2015 55 Nick Smith 99233
GREE 2/3/2015 55 Nick Smith 99212
2/3/2015 Count 1 1
GREE 2/4/2015 55 Nick Smith 99233
GREE 2/4/2015 55 Nick Smith 99212
2/4/2015 Count 1 1
In this example I would like to remove the 1st two rows of data because the "Other Dr" subtotal = 0
I need to leave all other data because the "Other Dr" subtotal is Greater than 0
I will be putting this formula in "Developer" Insert Module and Running it on an Excel 7 file
Thank you for your help
Here is an example of the sheet.
Practice Code Date Svc From Pat Person Nbr Pat First Name Pat Last Name Primary Doctor Other Dr
GREE 2/2/2015 55 Nick Smith 99233
2/2/2015 Count 1 0
GREE 2/3/2015 55 Nick Smith 99233
GREE 2/3/2015 55 Nick Smith 99212
2/3/2015 Count 1 1
GREE 2/4/2015 55 Nick Smith 99233
GREE 2/4/2015 55 Nick Smith 99212
2/4/2015 Count 1 1
In this example I would like to remove the 1st two rows of data because the "Other Dr" subtotal = 0
I need to leave all other data because the "Other Dr" subtotal is Greater than 0
I will be putting this formula in "Developer" Insert Module and Running it on an Excel 7 file
Thank you for your help