Auto-populate monthly titled cells with amounts based on a specific date

[rob1234]

Hi all

Hopefully a straight forward one...?

I have a table. column A has an amount, column B a date. Columns C to N are headed with the months 'Jan' through to 'Dec'. How do I auto-populate the respective monthly titled cell with the amount in column A based on the date in column B? for example if A7 has $400 and B7 is dated 15/7/23, how do I make the $400 dollars auto-populate in the July row (I7)?

 

[awoohaw]

do you want somethinglike this:

Mr excel questions 53.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date	Amount	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2	2022-01-05	16	16
3	2022-01-20	12	12
4	2022-02-05	13		13
5	2022-02-20	9		9
6	2022-03-05	13			13
7	2022-03-20	9			9
8	2022-04-05	18				18
9	2022-04-20	15				15
10	2022-05-05	15					15
11	2022-05-20	14					14
12	2022-06-05	7						7
13	2022-06-20	19						19
14	2022-07-05	14							14
15	2022-07-20	12							12
16	2022-08-05	19								19
17	2022-08-20	7								7
18	2022-09-05	14									14
19	2022-09-20	19									19
20	2022-10-05	13										13
21	2022-10-20	12										12
22	2022-11-05	8											8
23	2022-11-20	6											6
24	2022-12-05	18												18
25	2022-12-20	13												13
26
rob1235

Cell Formulas
Range	Formula
C2:N25	C2	=IF(AND(MONTH($A2)=MONTH(C$1),YEAR($A2)=YEAR(C$1)),$B2,"")
A2:A25	A2	=DATE(2022,ROUNDDOWN((ROW(A1)-1)/2,0)+1,IF(ISEVEN((ROW(A1)-1)),5,20))

 

[rob1234]

Perfect, thank you

 

[awoohaw]

Happy you found a solution here!
Best wishes!