pass

I have the below code: Range("A:A,B:B,C:C,D:D,E:E,F:F,G:G,H:H,I:I").Select Range("I1").Activate ActiveSheet.Shapes.AddChart2(227, xlLine).Select ActiveChart.SetSourceData Source:=Range("Sheet2!$A1:$I$" & lr2) Since I know that data is available from columns A to I, I have passed all the...

Good Morning, I have the following code that's been working well as a "password box" to unlock a few sheets. However, I'd like to tweak it so that the if the password is wrong, it will display an "wrong password" message and then ask for the password again. this is all mounted on userform5 as...

Good day all, I am working on a sheet for a school, and would like to create an automatic selection from one sheet to another. The idea is to have one sheet with various details, and then another with a form for a gate pass. What I am aiming for is the name to appear on the gate pass, if the...

Good morning! I am trying to write a If/Then formula which returns one of two statements based upon the input in an series of cells. Example: =IF(H29:K38="X","Fail","Pass") If an "X" appears in H29 - K38, I was "Fail" to appear in a cell, if "X" does not appear I want "Pass" to appear...

Hi all, I'm trying to set up protection on my excel sheet.. and the way I imagine it, would be, when someone opens the workbook, they have to input a password, if they don't or the password isn't correct, they can only observe the workbook, and can't even select cells or do anything. Then if...

Hello, Last time I had somewhat same query and helpful tips from this forum, so I am here again, This time bit complex (at least to me). Here is the file with required format: https://drive.google.com/open?id=1jSG-azrx4r_zobaLUZwFijd9Rm8qcbB9 there are total 28 subjects a student can either...

In lieu of placing the array of sheets within the two procedures below, how can I use a third procedure to establish the array of sheets and then pass that argument? Sub ApplyAutofilter() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets(Array("Sheet1", "Sheet2", "Sheet3"...

Hi everyone, I hope you can help me with my concern. This formula, =IF(ISERROR(MATCH("Fail",CHOOSE({1;2;3;4;5;6},Q57,S57,U57,W57,Y57,AA57),0)>0),IF(ISERROR(MATCH("Pass",CHOOSE({1;2;3;4;5;6},Q57,S57,U57,W57,Y57,AA57),0)>0),"Unexecuted","Pass"),"Fail") worked perfectly to address the conditions...

Hi, I am trying to make a list based on the values in a table. In Row A I have a list of locations, in Column 1 I have a list of departments. Within the table I have various cells with "Pass" written in. I am looking for a way to list all the departments of each location that have "pass"...

This formula doesn't seem to work: =IF(CHOOSE({1;2;3;4;5;6},Q33,S33,U33,W33,Y33,AA33)="","Unexecuted",IF(CHOOSE({1;2;3;4;5;6},Q33,S33,U33,W33,Y33,AA33)="Fail","Fail",IF(CHOOSE({1;2;3;4;5;6},Q33,S33,U33,W33,Y33,AA33)=OR("Pass","")))) Does anyone have any idea how to fix it? The intention is: 1...

Hi guys, Sorry to be a bother. I hope you can help. I have 7 columns, I want to apply a formula in the first column to return the value "Pass" ONLY if the next 6 columns are either all "Pass" or blank. If there is any one column that has the value "Fail", I want the first column to return the...

Finding that M$FT in its infinite wisdom chose not to provide a built-in IsDate function to go along with all of the other IsXxx functions, I decided to write my own. Here it is: Function MyIsDate(ByVal cell As Variant) As Boolean MyIsDate = IsDate(cell) End Function It works fine if I pass it...

Hi All, I want to count the total number of Pass and Fail based on Column 1 (Originating) site. For. Eg., If I select US, I should get 3 pass and 1 Fails, and if I select UK I should get 1 pass and 1 fails. Can someone please help? <tbody> Originating Site Description US Pass US Pass UK...

I have some data that has the word "pass" or "fail" in one column, and a date in the one next to it. I am trying to use COUNTIF to count how many times a pass or fail occurred within each month. I have tried both of the below formulas: =COUNTIF(A1:A5,"Pass"),(MONTH(B1:B5)=F13) (F13 is...

Hello I need assistance with coming up with a formula for spreadsheet 2 column 2. I have a list of all PO in spreadsheet 1 and need to Pass or Fail based on the status from spreadsheet 1. If it contains a no or maybe then fail. this is a s implied version. <tbody> Spreadsheet 1 </tbody>...

I am working on extracting some information from an existing spreadsheet and copying the information to another sheet based on search. In column named Welder I want to extract that rows information for each individual welder initial and create a different workbook for each one. What would be...

Hi I have a table like the one below. I created advanced filter criteria criterial 1 - exam1 >50 [=B2>50] criterial 2 - exam2 >70 [=C2>70] and applied on this table <tbody> student exam1 exam2 result john 50 70 mary 30 77 alex 70 40 sarah 100 90 david 11 90 anna 20 30...

I have a Chart with 10 Series. For one of the series (Series 9) I want to pass the values using an array. I have created a SUB but I am unable to execute it, and can't figure out the reason. There are two charts in the Sheet. Chart1 and Chart2. I want to pass values to Chart1. Error that I am...

Hi, having trouble figuring this out, i have the following sheet code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("Z2:Z50")) Is Nothing Then If Target.Offset(0, 1).Value = Target.Offset(0, 2).Value Then 'do...

Hi I was reading the article below and then tried the code below by myself. Not sure why the code below works! password is a function and I want to pass 1 to that function. so I expected to do these (the password is 1) workbooks(1).password "1" OR workbooks(1).password 1 ++++++ Sub...