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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.