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.

Skills: Excel, Excel Macros, Excel VBA

See more: free excel help, excel help formulas, excel spreadsheet, excel formulas, microsoft excel help guide, excel help chat, excel help forum, advanced excel help, save datagrid excel file, freelance need help wsdl file, need someone excel attached file, save excel file custom xml, save scipt output excel file, need excel file track job, net save datatable excel file, export file excel vb6 save print, netread excel file save access, read excel file save access net, read excel file save using, need convert excel file hyperlinks pdf

About the Employer:
( 2 reviews ) Medellin, Colombia

Project ID: #17582713

Awarded to:


"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m More

$100 USD in 3 days
(183 Reviews)

5 freelancers are bidding on average $108 for this job

$61 USD in 2 days
(237 Reviews)

Hi, As per your project description I will develop VBA macro for you which will perform the listed tasks for you. I have developed many such macros and have expertise in automation. Please give me this opportunity t More

$99 USD in 3 days
(55 Reviews)

Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, More

$125 USD in 3 days
(14 Reviews)

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.

$155 USD in 3 days
(0 Reviews)