I need help with an excel file

I have an excel to save information about a music performing business... file with this estructure:

I use a worksheet for every presentation. Saving information such as: date, client, amount charged to client... In that sheet I select from a dropdown list the artists that performed in that presentation and their rate... Everytime we have a presentation a duplicate the worksheet and fill the information.

I have a sheet for the artists and the instrument they play. (thats the source for the dropdown list in the presentation worksheet )

I have a sheet for payments: person paid, date of payment and ammount..

WHAT I NEED: I want a formula, macro, or other solution to do the following:

Go over all events worksheets, check the name of the artist, sum the rate that is set in the event worksheet and then subtract all payments that are made to that person (registered in the payment sheet).

Create a new event worksheet when i need it, so i dont have to manually duplicate the worksheet everytime.

Excel Excel Macros Excel VBA

หมายเลขโปรเจค: #17582713

เกี่ยวกับโปรเจกต์