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.
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?
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?