# Effectuer des travaux sur Excel

## Açıklama

Hi

I have an Excel files which contains 20 tabs.

In each Tab there is a Table.

On the left side of the Table (first column) there is a different city name on each line (starting let's say A10, then A11, A12 etc...).

On line 9, in each column starting B (let's say B, C, D etc...) there are also different City Names.

In B10 there is the number of tons that has been sold from the City in A10 to the city in B9.

In C10 there is the numberof tons that has been sold from the City in A10 to the City in C9.

In B11 there is the number of tons that has been sold from the City in A11 to the city in B9.

In C11 there is the number of tons that has been sold from the City in A11 to the city in C9

Etc...

Each TAB represents the "sales" above for a specific month.

Tab 08-15 = August 2015

Tab 09-15 = September 2015

Etc...

So the sales are classified by Tab/Month.

Now here is what I want someone to create for me:

I want to create 1 Tab for each City that is in Column A in TAB 08-15 (for example)**.

In that new TAB, in column A we will have all the months:

1 CITY NAME

2 A B C D

3 City name in Column B / City name in Column C / City name in Column D

4 Aug-15

5 Sep. 15

6 Oct. 15

etc....

I need a macro that will fill B4 AUTOMATICALLY according the City in A10 in TAB 08-15.

And same for all the Cities.

At the end, instead of having the data classified by TAB/Month, I want to have the Data classified by TAB/City.

+

A Pivot Table from which I will be able to extract for exemple all the Tons sold from 1 City to & or 2 or 3 other cities on 1 particular month of several different months.

Beceriler: Veri Girişi, Veri Madenciliği, Veri İşleme, Excel

Proje NO: #14067135

## Seçilen:

NOURLIL

Bonjour, Ingénieur calcul, j'ai l'habitude de faire de l'excel avec du code visual basic. Je peux vous aider sur votre projet. Merci de me contacter Cordialement;

1 gün içinde 10\$ USD
(0 Değerlendirme)
0.0

## 21 freelancer bu iş için ortalamada 26\$ teklif veriyor

mantislin

Hi sir, This is kimi and I am scraping expert, I have did too many scraping projects, please check my profile page then you will know. https://www.freelancer.com/u/mantislin.html Can you tell me Daha fazlası

1 gün içinde 30\$ USD
(122 Değerlendirme)
6.8
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

1 gün içinde 50\$ USD
(155 Değerlendirme)
6.6
ksriniravi

Greetings! I can write a macro for your first requirement (Data classified by TAB/City, instead of having the data classified by TAB/Month). I have 17+ years experience in using Excel as part of my daily work li Daha fazlası

1 gün içinde 30\$ USD
(65 Değerlendirme)
5.6
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Mana Daha fazlası

1 gün içinde 30\$ USD
(27 Değerlendirme)
4.5
1 gün içinde 25\$ USD
(44 Değerlendirme)
4.7
ksinghrajeev

Here are some examples of my work. Project Report Automation - https://www.dropbox.com/s/tt0q9qhfq3s4izm/eBird%20FEP%20Plan%2012_Feb_15.xlsm?dl=0 Log Report Automation - https://www.dropbox.com/s/bebbodnh9qvk0av/ Daha fazlası

in 5 gün içinde56\$ USD
(12 Değerlendirme)
4.0
mD4work

Very fast and effective project submissions. contact over chat session

1 gün içinde 20\$ USD
(4 Değerlendirme)
2.9
1 gün içinde 25\$ USD
(1 Değerlendirme)
3.0
harshacd

DON`T BE MISLEAD BY MY LOW BID. I AM NEW TO THE SITE AND REALLY WANT SOME 5 STAR RATINGS. I have over 17 years of experience in data handling and I am fully competent in MS Excel and MS Powerpoint. I have an MBA and Daha fazlası

in 2 gün içinde12\$ USD
(0 Değerlendirme)
0.0
techcrunch2

Hello Sir, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the resu Daha fazlası

in 6 gün içinde28\$ USD
(0 Değerlendirme)
0.0

I have Data entry skills. I am qualified in MS IT(GIS). working experience is 3 years. I worked on multiple projects.

1 gün içinde 25\$ USD
(0 Değerlendirme)
0.0
abir4

Hello, I want to let you know that I have been working with these types of works for more than five years. I believe my skills would be ideal for your project.I can follow instructions very well and will deliver the Daha fazlası

1 gün içinde 25\$ USD
(0 Değerlendirme)
0.0
techlogics4

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Daha fazlası

in 6 gün içinde28\$ USD
(0 Değerlendirme)
0.0
edwardazarak

Hi.. I can help you in your work.. This work its very simple... We can talk about this work and I can deliver the first day the progress and if you have any question we make the correctios...

in 2 gün içinde30\$ USD
(0 Değerlendirme)
0.0
1 gün içinde 35\$ USD
(0 Değerlendirme)
0.0
ishtiyaqlone

Hello, My name is Ishtiyaq Lone, I am expert in web scrapping, data crawling and data mining, I have 6 years+ experience in data mining, website scraping, screen scraping and I am certified web scrapper expert. I have Daha fazlası

1 gün içinde 25\$ USD
(0 Değerlendirme)
0.0
Zubairashraf123

Hello, My name is Zubair Ashraf I am a professional in extracting data from a web page. I work with some useful tools which is why I can get data from web page fast and accurately. I am a database administrator with Daha fazlası

1 gün içinde 10\$ USD
(0 Değerlendirme)
0.0
blacktigerling

A proposal has not yet been provided

1 gün içinde 20\$ USD
(0 Değerlendirme)
0.0
cdleviatan

I have great knowledge of Excel spreadsheets. I have great speed in data processing. I work hard to deliver the jobs on time. https://www.linkedin.com/in/carlos-alberto-de-luca-76ab3a28/

1 gün içinde 15\$ USD
(0 Değerlendirme)
0.0
satishpandians

Please upload the file so that could better understand your requirement. THe analysis that you propose does not require macros and can be handled with formulas in Excel. Please ping if interested.

in 0 gün içinde25\$ USD
(0 Değerlendirme)
0.0