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;
Bu iş için 17 freelancer ortalamada $27 teklif veriyor
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
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.
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
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
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
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
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
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...
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
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
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
I have Data entry skills. I am qualified in MS IT(GIS). working experience is 3 years. I worked on multiple projects.