# 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 &quot;detailed-income-sheet&quot; 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 &quot;detailed-income-sheet&quot; are C (&quot;City&quot;) and A (&quot;Price&quot;). I would like to use the &quot;detailed-income-sheet&quot; to generate a table that summarizes, for each city separately, the total &quot;price&quot; values related to it. I prepared an example to the way the &quot;summarized-income-sheet&quot; should look like (the file is attached and is called &quot;summarized-income-sheet&quot;).

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

To summarize:

- I have 2 sheets at hand - &quot;detailed-income-sheet&quot; and &quot;expanses-sheet&quot;

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

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

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

Nº du projet : #549616

## Décerné à:

agihcam

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(39 Commentaires)
5.2

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

MAnkita

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% 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!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(53 Commentaires)
5.7
dev3dworx

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(19 Commentaires)
4.7
Khurramz

Hi! Please see PMB for details

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(15 Commentaires)
3.8
oFAZo

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(11 Commentaires)
3.7
FlashBack

Dear Sir Please see the PMB Thanks & Regards Abir

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(6 Commentaires)
3.4
ioanaprof

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% 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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(9 Commentaires)
3.3
guoxinliu917

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(3 Commentaires)
2.9
KellogITSolution

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(4 Commentaires)
2.8
lakshmidhanam

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(1 Évaluation)
2.2
jacsports

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(1 Évaluation)
1.4
tindz99

please have a look at pm for details

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
1.3
val81

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
stanitsk

I can do it

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
SoniaSantos

please consider me I can do it.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% 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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
Bronikels

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
dmitryantonov