Having a sheet revert to blank when a new drop down selection is made

[excel33]

Hi, I am creating a spreadsheet (newbie) and i have two drop down selections. One for months and one for days (numbers from 1 to 31).
I would like the sheet to go back to blank (all except the days column) when a new month is chosen from the drop down. can anyone assist?
Thanks

 

[awoohaw]

This gives you your drop down and your days of the month (according to the month).
To clear all but A1 and B1, if you want to do it automatically you will need to create a macro.
Here is some vba you can paste into a macro code (then you will select to run it from the macro list). or you can assign it to the workbook sheetchange event
As a macro...

Sub ClearAllButA1B1()
'
' ClearAllButA1B1 Macro
'

'
    Range("A2", "XFD1048576").Select
    Selection.Clear
    Range("C1", "C1048576").Select
    Selection.Clear
    Range("A1").Select
End Sub

as a worksheet change (whenever you change cell A1 - warning - will delete all every time)

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Set Target = Range("A1")

    Range("A2", "XFD1048576").Select
    Selection.Clear
    Range("C1", "C1048576").Select
    Selection.Clear
    Range("A1").Select

End Sub

mr excel questions 6.xlsm
	A	B
1	May	1
2		2
3		3
4		4
5		5
6		6
7		7
8		8
9		9
10		10
11		11
12		12
13		13
14		14
15		15
16		16
17		17
18		18
19		19
20		20
21		21
22		22
23		23
24		24
25		25
26		26
27		27
28		28
29		29
30		30
31		31
32
Sheet2

Cell Formulas
Range	Formula
B1:B31	B1	= SEQUENCE( DAY(EOMONTH(DATE(2023,MATCH(A1,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1),0)),1,1,1)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
A1	List	Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec

 

[awoohaw]

@excel33 , If you don't have a excel 365 or 2021 the above won't do your date sequence.
Please advise.

 

[excel33]

Excel 2016. The idea is that when a month is selected from the drop down at B3 the spreadsheet should revert to blank for all coumns that would have had figures inputted in the rows below the headings. It's basically to track expenses without having to copy and paste this sheet 12 times. I hope I am explaining things properly.

 

[awoohaw]

Okay, does 2016 have the sequence function?
and are you doing this on twelve worksheets? Why have a month drop down? or are you going to copy the workbook after each sheet is set up?

 

[excel33]

Okay, does 2016 have the sequence function?
and are you doing this on twelve worksheets? Why have a month drop down? or are you going to copy the workbook after each sheet is set up?

No it doesnt. No one worksheet. But i am rethinking now based on what i need it for as i figure the information would be lost when the sheet reverts. Is that so?