SUM Data validation into specific day in the month

[jonwondon]

Hi Guys,

First I want to say the users on this forum have always helped me with my specific requests and thank you for that.

My next task!

I'm looking to make a workbook. On first sheet is multiple columns for the different transactions in a bank account (Cash, Mastercard, Visa, Amex, Discover, etc...) - 2nd sheet would be where I post my bank statement CSV -

I want to make a data validation dropdown list that when I select an item - it dumps it into the first sheet for that specific day. It also has to add up these amounts for the day.

SR-6.xlsx
	L
32
Sheet1

SR-6.xlsx
	B
3
Sheet2

Maybe a SUMIF for the totals on the 2nd Sheet for the data validation to dump the totals to the specific day. But how would I read the date of the transaction and total it to be dumped into the specific day on the first sheet?

 

[Joe4]

Please try posting your images again.
Be sure to select the ENTIRE range you want to copy over (it looks like you only selected one cell each time, which doesn't really show us anything).