Hi Everybody,
I know this is one is probably an easy one for you all. I have a long error report I need help with. Attached is a sample of the spreadsheet. Column J shows where the error is located on the spreadsheet. Is there a way to highlight the row where the error shows up? For instance...
Hello all
Can I have help please on this loop please.
I want to complete a sumifs statement in cell "D9" and then replicate this every 4 cell down in column "D" until I get to cell "D2597"
Tried to put this together but failed
Dim i As Integer
Range("D9").Select
i = 1
Do Until i > 2597...
So I am trying to create a button that opens a userform thatasks questions on what the user wants to do. It is kind of hard to explain so Iam going to try to insert screen shots of what I want to happen.
Below is part of a table that is created on the main pageentitled “Status Sheet.”
<tbody>...
I have the below formula
=IF(AND(OR(H2="#N/A",I2="#N/A", J2="#N/A")),"FAIL","PASS")
In the results it either brings "PASS" when passed or shows "#N/A" when failed.
How can i get this to say PASS when it's passed and FAIL when it's Failed?
<tbody>
Item 260
A/C 2121
Date failed: 15 May
Fault: B60
Item 260
A/C 2121
7 May
B60
Item 260
A/C 2003
3 May
B60/CS
Item 260
A/C 2103
6 Jul
B60
</tbody>
I'm trying to build a table that pulls from another automatically and checks to see if my equipment items have failed...
Hi,
Please could someone help me with an IF statement. I would like to write the below in an IF statement if possible.
scenario:
Total number of items = 39
For each item that is failed, 0.01 point deducted per 0.01% that the item is below 99.5% but above or equal to 96% and
For each item...
Hi,
Please could someone help me with an IF statement. I would like to write the below in an IF statement if possible.
scenario:
Total number of items = 39
For each item that is failed, 0.01 point deducted per 0.01% that the item is below 99.5% but above or equal to 96% and
For each item...
Hi,
I have 2 sets of code. One copies the form and the second pastes it.
(the ancillary functions are sheet hide unhide etc)
The problem is, at times the codes work perfectly fine.
But sometimes i get the "pastespecial method of range class failed 1004" error.
I have created an excel ribbon...
Hi,
I have this formula below where I would also like to add if B3 = "3rd Party", then have the same result as Contractor, I've clearly failed trying AND/ OR functions. Please could you help?
=IF(B3="Contractor",VLOOKUP(C3,'Rate Card'!A:M,13,0),VLOOKUP($B3,'Payroll by Person Mar-18'!A:M,13,0))...
I keep getting this error "runtime error 1004 pastespecial method of range class failed" on following code :
Option Explicit
Sub copypasterow()
'
' chequerecieving Macro
' copy active row to another workbooks last row
'
' Keyboard Shortcut: Ctrl+l
'
Dim wbTarget As Workbook...
Hopefully a quick question all
The following line of code is failing
Sheets("ChartByCount").FullSeriesCollection(5).AxisGroup = 2
I get a runtime error; "Method 'AxisGroup' of object 'Series' failed" Must be a syntax problem or something equally simple, but I can find the problem
Any help...
Hi,
When trying to load a table into the Data Model using Excel 2013 I get the following error message:
"Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.WorkbookClass' to interface type 'Microsoft.Office.Interop.Excel._Workbook'. This operation failed because the...
Hi All,
I tried to create two slicers by Slicercaches.add2() methods. it worked for the first slicer but failed for the second one. I tried every way i could use: put them in a same sub, use two subs, record a macro then paste it in my code. All failed. Can anyone help? Thanks.
Hello,
I have a power query pulling from a CSV file. I have set the data type in one of the columns as text, but there are errors that claim power query could not convert the data in the column to a number. I have tried refreshing the query. I've tried converting to a different data type then...
Sheets("INPUT").Protect Password:="runway", DrawingObjects:=True, Contents:=True, Scenarios:=True
Except "AE:AT , X "COLUMN need to add to above code,rest of the cells need to be protect
i tried but getting failed
Anyone can help me out
<colgroup><col></colgroup><tbody>
As new set of cells has to be copied at the bottom of existing used cells,
but the VBA code below is failed (far lower than my used range),
</tbody>
<tbody>
a = ActiveCell.SpecialCells(xlLastCell).Row
</tbody>
<tbody>
please advise the code.
</tbody>
Have a workbook with 70 different worksheets, all the worksheets are the same "Form", all these forms have a "comments" section (cells A35:G36), and a cell F32 which if an X is placed in it, indicates a failed inspection. Trying to add a table to the main page in essence a summary of failed...
Hello- i am having some difficulties creating a formula to help me figure out the forecast accuracy and fulfillment rate with different if scenarios.
Forecast accuracy column: If forecast is 10,700 and i sold 8,108 that mean i over forecasted by 24%. Also, if my forecast is 85 but i sold 176...
I searched in the Internet and I found tons of stuff related to setting Header/Footer (Left, Right, Centre). However, I am trying to do the opposite and I have not succeeded.
What I need is to get the text (ONLY THE TEXT) from CenterHeader.
The text of CenterHeader was "Greece".
I run the...
I am having a student data to calculate the number of subjects failed by a student. ABSENT is also considered as fail and those who have scored below 50 marks is considered as Fail. The excel sheet designed is as follows:
Roll No Name Subject 1 Subject 2 Subject 3 Subject 4 Subject 5...
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.