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

( 2 comentários ) Tel Aviv, Israel

ID do Projeto: #549616

agihcam

\$35 USD em 1 dia
(39 Comentários)
5.2

## 41 freelancers are bidding on average \$81 for this job

MAnkita

\$125 USD in 5 dias
(47 Comentários)
5.7
nagybatonyi

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

\$30 USD in 0 dias
(53 Comentários)
5.7
dev3dworx

\$30 USD em 1 dia
(19 Comentários)
4.7
Khurramz

Hi! Please see PMB for details

\$70 USD em 1 dia
(15 Comentários)
3.8
oFAZo

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

\$75 USD in 2 dias
(11 Comentários)
3.7
FlashBack

Dear Sir Please see the PMB Thanks & Regards Abir

\$90 USD in 3 dias
(6 Comentários)
3.4
ioanaprof

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

\$45 USD in 3 dias
(12 Comentários)
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 dias
(9 Comentários)
3.3
guoxinliu917

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

\$50 USD em 1 dia
(2 Comentários)
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 Mais

\$50 USD in 2 dias
(3 Comentários)
2.9
KellogITSolution

\$35 USD in 2 dias
(4 Comentários)
2.8
lakshmidhanam

\$50 USD in 5 dias
(1 Comentário)
2.2
jacsports

\$150 USD in 5 dias
(1 Comentário)
1.4
tindz99

please have a look at pm for details

\$30 USD in 2 dias
(1 Comentário)
1.3
val81

\$30 USD in 2 dias
(0 Comentários)
0.0
stanitsk

I can do it

\$50 USD in 2 dias
(0 Comentários)
0.0
SoniaSantos

please consider me I can do it.

\$50 USD in 7 dias
(0 Comentários)
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 dias
(0 Comentários)
0.0
Bronikels

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

\$250 USD em 1 dia
(0 Comentários)
0.0
dmitryantonov

\$200 USD em 1 dia
(0 Comentários)
0.0