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

en 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

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

Nº du projet : #549616

Décerné à:

agihcam

Please check PMB.

%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

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

%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

Please check PMB for details.

%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

Hello Please See your PMB. Thanks

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

Hi, Ready to start. Lakshmi.

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

PLEASE SEE PM FOR BID.

%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

Please, see PM for details. Thanks in advance !

%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

Hello. Check your PM please. Thank you.

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