Suoritettu

How to make comparison chart to display data from two workbooks on each worksheet that have the same name

I have a difficult task. I am not sure if anyone out there can help me.

Please read my concerns:

#1 I have "2" workbooks name: Unemployment_Rate GDP_Annual_Growth_Rate_% #2 in "Unemployment_Rate" workbook. I have "1" Master worksheet and "181" worksheet which is name after a country. Example Sheet #1 "Afghanistan"; Sheet #2 "Albania"; Sheet #3 "Algeria" and so on...

#3 In "GDP_Annual_Growth_Rate_%" workbook. I have "1" Navigation worksheet, "1" Master worksheet and "185 worksheet which is name after a country. Example Sheet #1 "Afghanistan"; Sheet #2 "Albania"; Sheet #3 "Algeria" and so on...

My problem here is this:

a) How can I create a chart using VBA to automatically get the data in each country worksheet from "Unemployment_Rate" and "GDP_Annual_Growth_Rate_%" workbook? b) How can I get data from column "B" (which is the date column) and column "E" (which is the value column) in all country worksheet in Unemployment_Rate" workbook? And c) How can I get data from column "B"(which is the date column) and column "E" (which is the value column) in all country worksheet in "GDP_Annual_Growth_Rate_%" workbook? See example photo of how the chart is displayed:

My Other Problem:

How can I paste each chart into each country worksheet in "Unemployment_Rate" workbook automatically using a VBA?

With lack of knowledge for excel. I don't know if this request can be accomplish. To me it sounds difficult. I am opened for a better outcome, once available.

Below you can view other supported images and excel files that relates with this project.

How can you all help me?

Thanks in advance

[login to view URL] [login to view URL]

Taidot: Excel, Visual Basic, Visual Basic for Apps, tietojenkäsittely, Charts

Näytä lisää: excel vba create chart display data, don t know how to write a book but want to who could i talk to to help write a book, how to find a book you don t know the name of, how to compare two excel sheets using vlookup, how to compare two excel sheets for differences in values, how to match data in excel from 2 worksheets, compare two excel sheets and highlight differences macro, how do i compare two excel spreadsheets for duplicates?, compare two excel sheets and highlight differences, can i compare two excel spreadsheets for differences, how do you compare two excel sheets and highlight the difference?, i have an event and want an artist but don t know how much they charge, how to copy and paste on websites that don't allow it chrome, i have an idea for an app but don t know how to code, how to connect with someone on linkedin you don't know, how to get letters of recommendation if you don't know anyone, i have an invention idea but don't know how to make it, i have an idea for an app but don't know how to code, how to find a movie name you don't know, how to find a book when you don't know the title or author

Tietoa työnantajasta:
( 0 arvostelua ) Chaguanas, Trinidad and Tobago

Projektin tunnus: #26968477

Myönnetty käyttäjälle:

rameshraja86

Hi, I have understood your requirements. 1. Data source selection in two excel sheets with same names. It will take 1hr 2. Chart formation - 1hr 3. Chart pasting - 1hr I am sure it will be done lesser than 4hrs... Lisää

$10 USD 1 päivässä
(2 Arvostelua)
0.6
JayrilRamos

Are you using google sheet? I can help you if the said excel can be converted into google sheet. We just need to import from the 2 sheets in order to make a summary from it and make a chart Relevant Skills and Experie Lisää

$25 USD 1 päivässä
(0 Arvostelua)
0.0

8 freelanceria on tarjonnut keskimäärin 22$ tähän työhön

wangdao5211

Hello! I am happy to put my bid on your project. I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. Everyone call Lisää

$30 USD 1 päivässä
(7 arvostelua)
3.3
faisal9263

Dear hiring manager, At first take my sincere respect. I have gone through you preject description attentively. After that I am able to understand that I have enough skills to do your project perfectly. Here is so Lisää

$30 USD 1 päivässä
(1 arvostelu)
2.8
arunkumar9896

Hi there, I am an expert in excel formulas, dashboards, macros.I have gone through the description on your project and will be able to finish before the deadline. Thanks Arun

$20 USD 1 päivässä
(2 arvostelua)
2.1
chandrabhanc56

Hiiiiiii Relevant Skills and Experience Uuuijjh

$25 USD 1 päivässä
(0 arvostelua)
0.0
bluexgene

I'm an MS Excel enthusiast. I'm a banker by profession, working in a public sector bank in India. For day to day repetitive tasks in banking I have built excel macros for automation. In my free time I do hobby projects Lisää

$10 USD 7 päivässä
(0 arvostelua)
0.0
ankitguptathegab

recently work with a chartered accountant as you know that there is only work on excel, ms word as on i have 2 year experiance of it. have a good day

$27 USD 4 päivässä
(0 arvostelua)
0.0