In Progress

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!

Skills: Excel

See more: pay expert, need expert excel help, need excell help, file excel expert, expert excel help, expert help excel, excel help needed, 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 file prepared step, cities data excel sheet, excel data hand, order sheet, excel file cities, excel order, order excel

About the Employer:
( 2 reviews ) Tel Aviv, Israel

Project ID: #549616

Awarded to:

agihcam

Please check PMB.

$35 USD in 1 day
(39 Reviews)
5.2

41 freelancers are bidding on average $81 for this job

MAnkita

Hello,Please refer your PMB.Thank you.

$125 USD in 5 days
(47 Reviews)
5.7
nagybatonyi

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

$30 USD in 0 days
(53 Reviews)
5.7
dev3dworx

Please check PMB for details.

$30 USD in 1 day
(19 Reviews)
4.7
Khurramz

Hi! Please see PMB for details

$70 USD in 1 day
(15 Reviews)
3.8
oFAZo

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

$75 USD in 2 days
(11 Reviews)
3.7
FlashBack

Dear Sir Please see the PMB Thanks & Regards Abir

$90 USD in 3 days
(6 Reviews)
3.4
ioanaprof

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

$45 USD in 3 days
(12 Reviews)
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 in 3 days
(9 Reviews)
3.3
guoxinliu917

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

$50 USD in 1 day
(2 Reviews)
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 More

$50 USD in 2 days
(3 Reviews)
2.9
KellogITSolution

Hello Please See your PMB. Thanks

$35 USD in 2 days
(4 Reviews)
2.8
lakshmidhanam

Hi, Ready to start. Lakshmi.

$50 USD in 5 days
(1 Review)
2.2
jacsports

PLEASE SEE PM FOR BID.

$150 USD in 5 days
(1 Review)
1.4
tindz99

please have a look at pm for details

$30 USD in 2 days
(1 Review)
1.3
val81

Please, see PM for details. Thanks in advance !

$30 USD in 2 days
(0 Reviews)
0.0
stanitsk

I can do it

$50 USD in 2 days
(0 Reviews)
0.0
SoniaSantos

please consider me I can do it.

$50 USD in 7 days
(0 Reviews)
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 in 2 days
(0 Reviews)
0.0
Bronikels

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

$250 USD in 1 day
(0 Reviews)
0.0
dmitryantonov

Hello. Check your PM please. Thank you.

$200 USD in 1 day
(0 Reviews)
0.0