I need help with an excel file

Selesai Dipasang 5 tahun yang lalu Dibayar saat pengiriman
Selesai Dibayar saat pengiriman

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

ID Proyek: #17582713

Tentang proyek

5 proposal Proyek online Aktif 5 tahun yang lalu

Diberikan kepada:

Tanmoy236

"""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 Lebih banyak

$100 USD dalam 3 hari
(183 Ulasan)
6.7

5 freelancer rata-rata menawar $108 untuk pekerjaan ini

TechnoGuruu

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 Lebih banyak

$99 USD dalam 3 hari
(55 Ulasan)
5.4
afenache

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, Lebih banyak

$125 USD dalam 3 hari
(14 Ulasan)
4.1
krishu7

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 dalam 3 hari
(0 Ulasan)
0.0