jmthompson
Well-known Member
- Joined
- Mar 31, 2008
- Messages
- 966
New to VBA-
I have a template I use to reformat an exported report so it will import into another database. One of the things I need to do is divide this report into 26 separate reports.
What I would like to do is create a macro that will delete any rows where the first cell is not equal to a given value, for example 10100. My thinking is that I will create a macro for each of the 26 possible values and save as after I run each delete macro.
This report does have a header that I need to keep.
The length (number of rows) changes monthly and I'd rather not alter the macro each month.
Help?
I have a template I use to reformat an exported report so it will import into another database. One of the things I need to do is divide this report into 26 separate reports.
What I would like to do is create a macro that will delete any rows where the first cell is not equal to a given value, for example 10100. My thinking is that I will create a macro for each of the 26 possible values and save as after I run each delete macro.
This report does have a header that I need to keep.
The length (number of rows) changes monthly and I'd rather not alter the macro each month.
Help?