# Effectuer des travaux sur Excel

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

İşveren Hakkında:
( 16 değerlendirme ) Salmiya, France

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 %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(1 Yorum)
0.0

## Bu iş için 17 freelancer ortalamada \$27 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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(129 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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(184 Değerlendirme)
6.7
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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(79 Değerlendirme)
5.9
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(54 Değerlendirme)
5.0
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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(36 Değerlendirme)
4.6
ksinghrajeev

Here are some examples of my work. Project Report Automation - [url removed, login to view] Log Report Automation - [url removed, login to view] Daha Fazla

in %bids___i_period_sub_35% gün içinde56%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)
4.0
mD4work

Very fast and effective project submissions. contact over chat session

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
3.2
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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% 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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
blacktigerling

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% 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 %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.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 Fazla

in %bids___i_period_sub_35% gün içinde12%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 Fazla

in %bids___i_period_sub_35% gün içinde28%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
faisalnadeem578

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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0