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.
5 freelancers are bidding on average $108 for this job
Hello, I am Pooja Rohra, Computer Instructor and Manager in reputed firm. I have plenty of experience doing Ms office work. I have read you job post and feel fit for such job.