I am not an expert and am not sure this can be done. I have put
together a spreadsheet for a project with a budget and progress draws.
I want to show the total of payments by line item in a single cell
and re-calculate the remaining budget left. About 400 lines. I would
like to be able to click on a cell that shows a total of payments for
a line item and have a drop down open up that I can add to showing 5
rows for memo information only with one row that totals to the
original cell showing where the total has come from. I want to be
able to list the payments, dates, company etc and have only the total
show on the spread sheet but also want to add payments to the drop
down as payments are made. When I am on that cell, I would like the
list to drop down for viewing or adding another row and the payment
column displaying the total in the cell on the worksheet. I can then
take information from that cell for the rest of the spreadsheet. Is
this possible?