Hi all,

I want to apologize for the complexity of this question, but could really use some help. I have been developing a budgeting sheet to keep track of several expenses across several bank branches.

Users use a data validation list and enter information into an entry form that includes:
Branch name
Month
Expense Type
Actual Expense

Once they enter the information, it feeds into a pivot table so that an easy and highly granular display of the information can be reviewed over the course of a year.

Here is the question:Some of these expenses have to be distributed evenly across all of the branches. Given that the branches are all listed for the data validation, is there any way I can modify the entry form so that it will allow a cost to be evenly distributed across all bank branches in the resulting pivot table?

Thanks,
Alan