How do a delete rows with specific months

Try this vba solution:

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Or if you prefer to use formula

in B2 and copy down

=TEXT(A2,"mmm")

then apply filter to columns A and B select months that you want, next, highlight selected rows, right click and delete.

	A	B
1	Date	Month
2	12/12/1980	Dec
3	1/2/1981	Jan
4	2/2/1981	Feb
5	3/2/1981	Mar
6	4/1/1981	Apr
7	5/1/1981	May
8	6/1/1981	Jun
9	7/1/1981	Jul
10	8/3/1981	Aug
11	9/1/1981	Sep
12	10/1/1981	Oct
13	11/2/1981	Nov
14	12/1/1981	Dec
15	1/4/1982	Jan
16	2/1/1982	Feb
17	3/1/1982	Mar
18	4/1/1982	Apr
19	5/3/1982	May
20	6/1/1982	Jun

Or you could skip the helper, and still use the suggested Filter, you would just need to pick out the month from each year