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
Each TAB represents the "sales" above for a specific month.
Tab 08-15 = August 2015
Tab 09-15 = September 2015
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
5 Sep. 15
6 Oct. 15
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.
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;
21 freelancer bu iş için ortalamada 26$ teklif veriyor
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...
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/
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.