country

Hi, I have the below code - which sorts column B ascending alphabetically. As an example column B has heading called 'Country'; ActiveSheet.UsedRange.Sort Key1:=Range("B1"), Header:=xlYes However the above doesn't work in instances where 'Country' column doesn't appear in column B (It could...

Hi All, Can anyone help me with. i have below data, if ID is duplicate then do the green color on next cell else yellow color... <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> ID Country name 306560 US 4569087 US 896880 US...

Hi Guys, thanks for reading my post. I've encounter another VBA problem again. The situation is I needa check if the country provided is within my own country list. So I've written below:- Function BSD(Place As String) As String Select Case Place Case "China", "Cyprus", "Czech Republic"...

Book1ABCDEF1Risk RaitingCountryRenewal dateOutputRelevant countries2LowCanada;Germany;UKFriday, October 26, 2018YesUK3HighCanada;Luxembourg;UKSaturday, October 27, 2018NoUnited Kingdom4MediumAU;EMEA;NZFriday, October 19, 2018NoEMEA5LowLuxembourgFriday, October 27, 2017YesBE6MediumAusSaturday...

Good morning, I have a rather large data source file with a large pivot table. In another file, I need to pull several pieces of information in order for a macro to work. The problem I am having is that the volume of GETPIVOT formulas I currently have are really bogging everything down. The...

Dear All, Userform1 : Combobox1 - Which shows different country list. "Country A, Country B, Country C, Country D, Country E, Country F, Country G, Country H & Country I" Combobox2 - Which is required to show the Start Time + 1 Hour, based on selection from combobox1. Now, For each countries...

I have a manual table which will be updated with new countries/states every 6 months or so. Once we update the countries/states, it will auto update a dashboard and the formulas associated with it. Example: <tbody> Region 1 APAC Region 2 US Region 3 EMEA Country 1 Japan Country 1 Florida...

Hello experts, I have a report that I need to format quite often, to make it more readable I need to insert yellow rows above every market. Any suggestions on how to find the first unique value in a column? To make it more clear: Column Q contains country names and by adding yellow lines I...

Hi guys, I have the following situation. Table 1 in Sheet ("PH") <tbody> Person A Country A Country B Country C Country D Country E Product A 5 10 20 30 0 Product B 5 10 25 30 0 Product C 5 10 20 30 0 Product D 5 17 25 30 0 Product E 5 10 20 30 0...

Hello I need help with a VBA code. I am currently using the below code to save files to the correct folders. Sub Button1_Click() Dim Path As String Dim filename As String Dim filename2 As String Dim country As String Dim Fixpath As String filename = Range("J3") filename2 = Range("J4")...

Hi, I have data like this in two cells. Country name USA Rick Canada John Australia Bill UK John Now in different cells I want to...

I have an Excel sheet which contains the following parameters: 1. Country 2.State 3.Site 4. Shifts 5.Experience I have another sheet in which I have the following 1. Country 2. State 3. Site 4. Vertical I want a seperate Excel Sheet which contains the following columns: 1. Country 2. State 3...

I have pasted a sample data set below with required output format, Kindly let me know if the desired output can be generated via formula/Macro. In my dataset fields are populated with 3 Keywords - Found, Not Found, Updated. I have to consolidate the headers for output field based on the...

Hi, i have a list of data on sheet("data") in columns A:C in the following format: <tbody> OrderNumber Quantity CountryCode 0001 12 01 0002 1 01 0003 4 02 0004 1 03 0005 6 04 0006 1 04 </tbody> I need to copy everything with CountryCode 01 into range "label01" on...

Hello, I have the below code, I have nearly completed what I am trying to do. The final stage would be to save each workbook into different folders depending on the country code. Can you please help? Private Sub filename_cellvalue() Dim Path As String Dim filename As String Dim filename2...

Hello, I have the below code, I have nearly completed what I am trying to do. The final stage would be to save each workbook into different folders depending on the country code. Can you please help? Private Sub filename_cellvalue() Dim Path As String Dim filename As String Dim filename2...

Hi all, I m Looking to write a formula for below requirement. But not easy. Country Number. Result DE. 1. DE. GB GB. 1. DE. GB DE 1. DE. GB Anyone has sn idea what can b fone...

Hello All, I would need someones help with frequency formula. never used it and now i need it for some of my work, i can come up with basic one but not with one with multiple criteria. So here is what i need help on, i have a document with persons working times. Based on that i need to be able...

Dear Friend How to edit code VBA for the VBA Vlookup another sheet please see table and ad visor:eeek: Thank you lotto Beginner VBA Sheet1 <tbody> item Detail Age School name Mother Country parent 1 david 17 T 2 job 12 G 3 steep 13 H 4 art 15 I </tbody> Sheet2...

Column G has Country codes in it (US,CA,LU,BE,NL,IT,ES,GB,DE,CZ,SK,FR,IE,AU,NZ,JP,CN,SG,KR). In column AT I have an IFS formula to tell me if Column G has any of the country initials for the EMEA region (LU,BE,NL,IT,ES,GB,DE,CZ,SK,FR,IE) so I can identify if a person is part of any of those...