usa

Hello, I would like to transpose the first table into the second table. The table will always begin in Cell A1 but could have varying row and column lengths. I have been toying with VBA but cannot find an appropriate solution. Table 1 (original) <tbody> TEST LOCATION 2016A 2016B 2016C 2017A...

Access 365 Within my main form f_pac, I have 3 check boxes (USA, Canada, Combined) I need to have them enabled/disabled. If either USA or Canada is checked then disable Combined. and if Combined is checked disable USA and Canada. How can I do this?

I have similar to this table with many columns and thousand of rows (patients) - as you can see each patient have 6 tests(test1 to test6) with different 6 result. - all other columns have the same result. - I need to switch the results from vertical to horizontal so I the table can show one...

I have similar to this table with many columns and thousand of rows (patients) - as you can see each patient have 6 tests(test1 to test6) with different 6 result. - all other columns have the same result. - I need to switch the results from vertical to horizontal so I the table can show one...

Hello, I have a workbook that contains a list of orders amongst a vast amount of other information. The orders are listed by a sales order due date from oldest to newest and are repeated multiple times but referencing different line items on that order(its almost safe to assume every order will...

Hi I would like to Bold alternate words for eg Name : MR.EXCEL Country : USA Dim strName As String, strCountry As String, Dim mpStart As Long strName = "MR.EXCEL" strCountry = "USA" With Worksheets("sheet5").Cells(14, 1) .Font.Bold = False .value = "Name : "...

Hello I have three formulas that calculate three different numbers in the format: "23 USA orders", "53 EU orders", "36 ASIA orders". How can I return the first biggest and second biggest from the above? Thanks!

Hello VBA pros, I have a tricky problem (well it is for me) regarding duplicates in a dataset. Regularly I receive manually generated customer lists from our finance/sales or another department including an overview of customers and their revenues in a specific period (customer name in column A...

Hi, I am after a lookup formula to bring across the freight cost to give me a total cost of deliverys? Please see below table. <colgroup><col width="64" style="width...

Hey Guys, Having trouble solving this one. I have data that is displayed like this: England 4 France 3 Brazil 4 USA 4 USA 4 Canada 3 I'm trying to count how many times a combo of England,France occurred as a 4/3, Brazil, USA as a 4/4 and so on...the data is displayed vertically...

Hi, I have a table called "SITES" like this: Company Site freelensia www.freelensia.com google www.google.com mrexcel mrexcel.com The table is then loaded into Power Query and displayed as table SITE2 In table SITE2, I have added a new column with hard-coded text like this: Company...

Hey Mr. Excels,:cool: I am currently running a project that requires an automation on data. I have altogether 78 sheets: - 3 sheets are output data. - these 3 sheets are differentiated by payment types. - the rest of the 75 sheets are category sheets - category is located in J column in...

Hi ppl, I need to convert the Table 1 to Table 2 as shown below. Is it possible? Table 1: <tbody> Country Product France A France B France C Germany B Germany C USA A USA A </tbody> Table 2: <tbody> Country Product France A, B, C Germany B, C USA A, A...

I'd like to do a three color conditional format on one column IF another column has a certain value in that row. For example, if the country is USA and the sales conversion target is 20%, I want to have a rule that makes a three-color spectrum based on the actual conversion rate compared to...

Here i paste one excel report. In this, In need to make a report form a Master data with search keys.. please find the attached file and help me please... thanks in advance.. <tbody> Master Data Item No. Name Code Price Cat. 245 Apple Red UK 1.50 10 4157 Orange Naval USA USA 1.30 11...

Hello! I've painted myself into a corner here with an IF/AND/OR statement. This is a generalization of what I'm trying to accomplish in Excel 2016. The column VEHICLE doesn't always contain the word "TRUCK" so it needs to be scrutinized. The following string causes Excel to tell me there is...

I want a VBA that AutoFill the data in A2,B2,C2 to the last value of the Column D <tbody> Name A/C Code Country Balance John 001 USA 100 50 </tbody> In above table the values in A,B,C is automatically autofill to the last value which is 50 in this case of Balance(D)

Hi everyone, I"m still new in VBA and currently working on to develop data entry form in excel. I'm facing errors where my ID cannot auto increment while inserting the data=Country with 10 rows once the button was clicked. My codes are getting errors by overwritten the previous data for next...

I have a data validation drop down list with several entries. How can i also transfer the formatting over of the options from the list Example, if in my list i have an option that says USA and it is highlighted red i would like to also have the list appear red when i select USA Hope this...

Hi, I'm trying to prepare a reporting tool that will let me see cost and head count sortable by time period. I can do a countifs or sumifs function easily enough sorting by Division/location/role (columns A-C) if I target the formula to a particular date column. However, I want to be able to...