Delete the contents of columns if the month changes

H

hamad.fatima

I have a reference cell A1= current month like ( jan, feb , mar etc)
I have 12 columns JAN- Dec
if A1= FEB, i want a macro to delete the contents in JAN and FEB
columns and hide them .
if A1= MAR , then hide JAN & FEB & MAR and delete the contents in them
.. And so on.

Please help me write this macro.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 dimensional date sort 2
Like to start using Access 1
How can count the number of cells that fulfill certain criteria in other cells 2
Pivot table - show monthly data based on start/end date data 0
drag formula down from columns that go acros 3
Calculating occupational sick pay entitlement 0
Cumulative sum, based on previous data 0
Form return lookup values 1

Top