# 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!

Skills: 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