Delete fields that correspond to certain months in amortization table

[ihumet]

Hey guys,

I have a sheet (like example attached). it's broken out by month for many decades. certain columns like B-N need each field populated. There are others like O, P, Q, where I need to delete all cells except for 2 months that year (in this example, all except May and November).

Is there a shortcut method to do this quicker?

Thanks!

example.xlsx

[ihumet]

nevermind, i figured something out

[JBeaucaire]

As per Forum Rules, you should post your solution to make the thread complete.

I was going to suggest using the AUTOFILTER to filter out the data you want keep, then delete all the remaining visible rows, the turn off the AutoFilter to reveal your retained data.

[ihumet]

oops sorry, didn't know.

i basically filtered out each month i didn't want with the built in date sort, selected all data in those months and deleted them. might not be best solution but it worked