Terminé

Excell Expert Needed

Hello there,

I need some help with excel sheets that I have and analyzing the data within the sheets / producing new sheets.

1. Please take a look at the attached "detailed-income-sheet" file (this is only an example, the actual sheet that I have has much more rows, but I prepared this one for the sake of the example).

2. The two columns that interest on the "detailed-income-sheet" are C ("City") and A ("Price"). I would like to use the "detailed-income-sheet" to generate a table that summarizes, for each city separately, the total "price" values related to it. I prepared an example to the way the "summarized-income-sheet" should look like (the file is attached and is called "summarized-income-sheet").

3. The next step of the calculation involves a third sheet that I have at hand, and the file is attached ("expanses-sheet"). What I need here is to use the "expanses=sheet" and the "summarized-income-sheet" in order to generate a fourth sheet (let's call it "profit-loss-sheet"). The fourth sheet will calculate the difference (for each of the cities) between the "expanses" and "income". Pay attention that the "expanses-sheet" has more rows (cities) than the "income sheet" (i.e, some cities don't have income).

To summarize:

- I have 2 sheets at hand - "detailed-income-sheet" and "expanses-sheet"

- I need your help with producing automatically and easily, using the information in the above mentioned two sheets, two additional sheets - "summarized-income-sheet" and "profit-loss-sheet".

What solution would you suggest here? Is it possible to produce the sheets using excel or would it need an external software?

Thank you!

Compétences : Excel

Voir plus : pay expert, need expert excel help, need excell help, file excel expert, expert with excel, expert in excel help, expert help with excel, excel help needed, excel 0 to expert, excell expert, excel sheet expert, summarize, sake, Expert Excel, software calculate profit, summarize software, excel sheet summarize, cities file, look table excel, expert use, excel difference sheets third sheet, excel file prepared step, cities data excel sheet, excel data hand, order sheet

Concernant l'employeur :
( 2 commentaires ) Tel Aviv, Israel

N° du projet : #549616

Décerné à :

agihcam

Please check PMB.

35 $ USD en 1 jour
(39 Commentaires)
5.2

41 freelance font une offre moyenne de $81 pour ce travail

MAnkita

Hello,Please refer your [url removed, login to view] you.

125 $ USD en 5 jours
(47 Commentaires)
5.7
nagybatonyi

I can complete this project in less then one day, please, see PMB for details! Regards!

30 $ USD en 0 jours
(53 Commentaires)
5.7
dev3dworx

Please check PMB for details.

30 $ USD en 1 jour
(19 Commentaires)
4.7
Khurramz

Hi! Please see PMB for details

70 $ USD en 1 jour
(15 Commentaires)
3.8
oFAZo

Exceptional quality & Quick work. Please refer to Profile & PMB for details. Thanks FAZ

75 $ USD en 2 jours
(11 Commentaires)
3.7
FlashBack

Dear Sir Please see the PMB Thanks & Regards Abir

90 $ USD en 3 jours
(6 Commentaires)
3.4
ioanaprof

Dear Mr / Ms Please have the kindness to check Project Message Board. Thanks

45 $ USD en 3 jours
(12 Commentaires)
3.5
mantripti

Hi I am Mechanical Engineer + Cost Management Accountant I understant the task very clearly Would love to work on this project Regards

150 $ USD en 3 jours
(9 Commentaires)
3.3
guoxinliu917

Hello, I can do it for you. Please check my PMB. Thanks.

50 $ USD en 1 jour
(2 Commentaires)
2.9
VBASpecialist

This is definitely a project that is easy to do and automate using Excel and VBA. As a new user on this site, I'm willing to do this work at a budget-friendly price, in order to get a rating. I have many years of exper Plus

50 $ USD en 2 jours
(3 Commentaires)
2.9
KellogITSolution

Hello Please See your PMB. Thanks

35 $ USD en 2 jours
(4 Commentaires)
2.8
lakshmidhanam

Hi, Ready to start. Lakshmi.

50 $ USD en 5 jours
(1 Commentaire)
2.2
jacsports

PLEASE SEE PM FOR BID.

150 $ USD en 5 jours
(1 Commentaire)
1.4
tindz99

please have a look at pm for details

30 $ USD en 2 jours
(1 Commentaire)
1.3
val81

Please, see PM for details. Thanks in advance !

30 $ USD en 2 jours
(0 Commentaires)
0.0
stanitsk

I can do it

50 $ USD en 2 jours
(0 Commentaires)
0.0
SoniaSantos

please consider me I can do it.

50 $ USD en 7 jours
(0 Commentaires)
0.0
dfoliver

I have been writing formulas and macros for 23 years, including Lotus 1-2-3, Symphony and Excel. This can be done in Excel. An external program will not be needed.

100 $ USD en 2 jours
(0 Commentaires)
0.0
Bronikels

Excell , MS office , Internet, SAP , Pastel, Typing, Accounting

250 $ USD en 1 jour
(0 Commentaires)
0.0
dmitryantonov

Hello. Check your PM please. Thank you.

200 $ USD en 1 jour
(0 Commentaires)
0.0