country

Hello, I'm trying to find a way to show the world map with all countries. I want to color all countries based on criteria will be 4 colors. Example of country colors - cleared (blue) - removed (red) - review (yellow) - approved (green) What's the best way to do this? I'm not opposed to...

Hello! I mod old strategy games for a hobby. The macros I try to get working are used for modding game files for Paradox's Darkest Hour game. I have a working macro which I now would like to extend to complete the next job. To explain how it works: Columns A:B are key:value pairs, Column D...

Hi Folks, I am processing data in a large table that contains some duplicate column header names e.g., there are 2 headers called "Country", two instances of "Customer" and "Product" etc, etc. I cannot find any instance of this on Google search. Would you please help with the VBA code? What...

Hey everyone I hope someone can help me with the following. I have a sheet with companies (Column A) and their subsidiaries(Column B) and the country where those sub sidiariesoperate (Column C). It looks something like this: <tbody> Company Subsidiary Location Company 1 A US...

Hi, A----------------B Country------20 Country------21 State----------15 State-----------12 County---------30 I have a table similar to this one. On a different sheet I am trying to pull columns B by matching column A using Vlookup. Problem is when I look up for country, it's pulling up the...

hii, So what I'm trying to do goes as follows: ----SETUP---- i have a first workbook named "countrycodes.xlsx" that has 1 sheet with two columns. first column refers to "country code" (which is also the header A1) , the second column refers to the "country name" (header B1). i have a...

<colgroup><col><col><col></colgroup><tbody> Phone Country Approval Date Iphone Singapore 9/1/2016 Iphone Singapore 9/1/2017 Iphone Vietnam 9/15/2017 Iphone China 12/1/2016 Samsung Singapore 12/1/2017 Samsung China 12/15/2017 Samsung Turkey 1/5/2016 Samsung Turkey 1/5/2017...

I extracted data from another database. I want to make this data in pivot table formatting, which means fill Country and Product Column in every row so I can do analytics by country or by product type. There are 15000 rows. How can I do it using Macro? <tbody> B C D Country Product Product...

Fellow sufferers Please see my (partly pseudo-) code below. I first build a tree structure and would then like to pick one branch of it and send it to a subroutine for processing. Believe the code explains what I wish to do. BW Peter Bunde Hansen Sub Test() Dim inhabitants_in As Object Dim x...

I have a table with country performance data & I would like to be able to see the best performing country on a certain date. The idea is that if I change the date in cell E10 (highlighted in red), the formula in E11 would display the country name of the highest value on that date. In the event...

Fellow sufferers I am doing something´like this: inhabitants_in.Add "Norway", CreateObject("Scripting.Dictionary") inhabitants_in("Norway").Add "Oslo", 200000 How can I best, later, do something like, to find all the countries in the root: For each country in inhabitants_in...

Hello Everyone, I hope you can help with issue i have with a unique distinct list. I have a list of job numbers in Column C I have them marked as Complete/Incomplete in Column D I have them marked as Routine/Non-Routine in Column G I want to make a unique list of job numbers that are both...

Hi, I was wondering if anyone can helop me build a macro for a report i do every day. I have a master file that has multiple sheets. Every day i copy and paste some of these sheets into a new workbook. In my master file i am only concerned about 3 sheets, MasterF, Customer, Country. I copy and...

I have been stuck with this problem of having a sumifs formula to extract data from a table and place it in anothet format , see attached , I want to sum the data in column F& G based on the country and code and year Any help would be appreciated . The file is shared sumif.xlsx - Google Drive

Below is the query I am working on. I am having an issue with my IIF Statement. Please tell me what I am doing wrong? I am trying to get the query to place a "DQIP" in the Deviations_Request.Information field if the Deviations_Request.Nonadoptcomment = "Taiwan is non GC country, DQIP is not in...

Hello everyone, I have a quick question. Using the FIND or SEARCH Function in Excel I can check wether a cell contains a specific content, e.g. =FIND("Denmark",A1) checks the cell A1 for the word Denmark and returns the position if the word is contained in the cell. Now I have a huge dataset...

i need to copy values from a table when 2 other conditions are met. Table 1 <tbody> ID COUNTRY TYPE Details AA AZ READ This is used for reading in AZ AB UK Write This is used for writing in UK CD US EDIT This is used for editing in US AA AZ Write This is used for writing in AZ...

Hi, I have a spreadsheet with study names and more data where I've attached the pdf.file pertaining to each study. For e.g. if I filter on country it will filter correctly but does not filter the pdf.file with the correct record. Thanks. vell1958

I have never really used match and index before and I believe these will be needed to solve my problem I price list in one sheet and an invoice in another In the invoice I get in info in 4 columns that I use to check against my price list - Country, zip code, weight and then price The price...