Userform to updated years for each cell

[bmkelly]

Hello,

I have an excel spreadsheet that shows multiple accounting years (Fiscal Year, Calendar Year and some Operating Years) that gets updated a few times a year and am wondering if the best/easiest way to update the years for each accounting year is to have a userform open and we select the type of accounting year we have (FY, CY or OY: Oct-Sep or OY: Apr-Mar) and then select the year we would like to update it to and then the macro would updates those cells

here is the spreadsheet I have, I just don't really know how to go about starting or even completing a userform like this:

Calendar.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2
3
4		FISCAL YEAR FY22
5		3 MONTH ARREARS	4	5	6	7	8	9	10	11	12	1	2	3
6		Quarter	FY22 Q1			FY22 Q2			FY22 Q3			FY22 Q4
7		Inventory Changes Occuring	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22
8		Billing Period	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22
9			7	8	9	10	11	12	1	2	3	4	5	6
10
11
12
13		CALENDAR YEAR CY22
14		3 MONTH ARREARS	10	11	12	1	2	3	4	5	6	7	8	9
15		Quarter	CY22 Q1			CY22 Q2			CY22 Q3			CY22 Q4
16		Inventory Changes Occuring	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22
17		Billing Period	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21
18			1	2	3	4	5	6	7	8	9	10	11	12
19
20
21
22		OPERATING YEAR OY22 (OCT-SEP)
23		3 MONTH ARREARS	7	8	9	10	11	12	1	2	3	4	5	6
24		Quarter	OY22 Q1			OY22 Q2			OY22 Q3			OY22 Q4
25		Inventory Changes Occuring	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22
26		Billing Period	Oct-10	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22
27			10	11	12	1	2	3	4	5	6	7	8	9
28
29
30
31		OPERATING YEAR OY22 (APR-MAR)
32		3 MONTH ARREARS	1	2	3	4	5	6	7	8	9	10	11	12
33		Quarter	OY22 Q1			OY22 Q2			OY22 Q3			OY22 Q4
34		Inventory Changes Occuring	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22
35		Billing Period	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22
36			4	5	6	7	8	9	10	11	12	1	2	3
37
38
39
Sheet1

 

[bmkelly]

Hello,

I have an excel spreadsheet that shows multiple accounting years (Fiscal Year, Calendar Year and some Operating Years) that gets updated a few times a year and am wondering if the best/easiest way to update the years for each accounting year is to have a userform open and we select the type of accounting year we have (FY, CY or OY: Oct-Sep or OY: Apr-Mar) and then select the year we would like to update it to and then the macro would updates those cells

here is the spreadsheet I have, I just don't really know how to go about starting or even completing a userform like this:

Calendar.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2
3
4		FISCAL YEAR FY22
5		3 MONTH ARREARS	4	5	6	7	8	9	10	11	12	1	2	3
6		Quarter	FY22 Q1			FY22 Q2			FY22 Q3			FY22 Q4
7		Inventory Changes Occuring	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22
8		Billing Period	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22
9			7	8	9	10	11	12	1	2	3	4	5	6
10
11
12
13		CALENDAR YEAR CY22
14		3 MONTH ARREARS	10	11	12	1	2	3	4	5	6	7	8	9
15		Quarter	CY22 Q1			CY22 Q2			CY22 Q3			CY22 Q4
16		Inventory Changes Occuring	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22
17		Billing Period	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21
18			1	2	3	4	5	6	7	8	9	10	11	12
19
20
21
22		OPERATING YEAR OY22 (OCT-SEP)
23		3 MONTH ARREARS	7	8	9	10	11	12	1	2	3	4	5	6
24		Quarter	OY22 Q1			OY22 Q2			OY22 Q3			OY22 Q4
25		Inventory Changes Occuring	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22
26		Billing Period	Oct-10	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22
27			10	11	12	1	2	3	4	5	6	7	8	9
28
29
30
31		OPERATING YEAR OY22 (APR-MAR)
32		3 MONTH ARREARS	1	2	3	4	5	6	7	8	9	10	11	12
33		Quarter	OY22 Q1			OY22 Q2			OY22 Q3			OY22 Q4
34		Inventory Changes Occuring	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22
35		Billing Period	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22
36			4	5	6	7	8	9	10	11	12	1	2	3
37
38
39
Sheet1

I will need to update the billing Period Year as it doesn't line up exactly with the Inventory Change Occurring Row but that won't effect the larger picture of the UserForm Macro