# test

1. ### Help with IF formula

I am trying to develop an IF formula. I have 4 cells with eother "yes" or "no" in them. I would like a formula that looks at the 4 cells and returns a message in another cell of "test" when 2 or more of the cells have "yes" in them. Can anyone assist me?
2. ### How do I use Index & Match to reference a separate sheet?

I have the following test code that is working where column H is equal to what's in column B versus column D Range("H2:H17") = "=INDEX(D2:D17,MATCH(B2:B17,B2:B17,0))" Column B Column D Column H A Test1 Test1 B Test2 Test2 C Test 3 Test3 D Test 4 Test4 E Test 5 Test5 F Test 6...
3. ### Scan Barcode...compare against inventory...place X in cell when matched...automated

<a href="https://fhexcelphotos.shutterfly.com/pictures/9" target="_blank">https://fhexcelphotos.shutterfly.com/pictures/9 https://fhexcelphotos.shutterfly.com/pictures/10 Hi All, Please bear with me as I am not a programmer and therefore aren't fully competent with the terminology or...
4. ### Change column order

Hello, Shown below is a simple table showing a list of students and their grades for tests they periodically take. I send the results to them so that they can see how everyone is performing without knowing each others scores. I would like to automatically anonymise the columns each time I send...
5. ### IF X then display Range A in Range B

hi, I'm looking for a formula to display a range of cells if condition is met. For example IF A1 equals to "test" then display range F1:G4 in range B1:D5. Any ideas? Thank you
6. ### Fuzzy search of values from one column in another

I have one column with words, and another one with sentences. I want get into knowledge, which sentences from the second column contain words from the first column, putting into the third column something like "contains / not contains". Case insensitive could it be. Example...
7. ### Array Formula Question - Condition An Array by Itself

Hello! I'm trying to solve the following issue using an array formula but I'm struggling. I'm fairly versed with arrays but can't figure this out. Thank you in advance for the help! Using the example below, I'd like to pull the max number associated with each individual text in the first...
8. ### Search in a Cell and Return Associate Value

Hello, I have two tabs. [TAB1] is where I want to place my results. I want the results starting in columns C and moving right, as many columns as need be. I am hoping I can limit the columns the results section will be by only returning unique results (i.e. if there are three reference IDs...
9. ### Searching for a formula to display highest score and last date student tested

I have a database containing hundreds of students. That database has student ID numbers (column A), student last name (column B), students first name (column C), test scores (column D) , and test date (column E) as shown below. I want column F to display the student's ID number, column G, the...
10. ### VlookUp

I have a table with multiple columns. I am wanting to search one of those columns to find if there is a value > 0. If so, I want it to return back to a main table dashboard that value in one column and in the second column, it will return the number in the column it was searching. It would...
11. ### Update cell based of powerquery result

I have a button to update a powerquery on Sheet 2 from another workbook. the number of rows of data will vary. Now i want to include VB script on the button to update data on Sheet1 based off the data imported. What I am trying to accomplish. if Sheet2 column A has an entry that MATCHES Sheet1...
12. ### vba to copy one cell value to another cell value

Hi, I have this value (95551092 - ) in the activecell and I would like to add whatever value is in cell A50. I do have the following code which adds the value but it deletes the spaces and then moves the hyphen in front of the numbers. Sub test() Dim d As Double d = ActiveCell.Value...
13. ### Using Toggle/Option Buttons

I put two option buttons on a form and I am trying to figure out how to use them. Where is the Value stored when one of the Options are selected? I want to use these buttons in an If statement. Option246 Option248 I tired to test it: Private Sub Frame244_Click() If Option246.Value = "1" Then...
14. ### Countblank and If statements

=IF(ISBLANK(Q22),"FAIL",COUNTif(C27:Q27)"=>"&\$Q\$22),IF(COUNTIF(C27:Q27,">"&\$O\$18),"FAIL","PASS") I think I got myself twisted up here. The idea is to replace one of the Pass/Fail columns on the right with a code that leaves the portion IF(COUNTIF(C27:Q27, ">"&\$O\$18), "FAIL", "PASS") intact...
15. ### Test if contains a string in a list

Hi, I have the following in D2 which contains "David & Rose Smith =iferror(LEFT(\$C2,(FIND(" ",\$C2,1)-1)),C2) I want to test for strings listed in the named range, "NOGOOD". If none of the string are in C2, I'd like to apply above. If any of the stings in NOGOOD appear in C2, the result...
16. ### Variables between modules

Hello guys, I've been having trouble getting global variables to work. Module1 code: Option Explicit Public Test As Variant Sub init() test = 2 Call testing End Sub Module2 code: Option Explicit Sub Testing() test = 3 End Sub All i want is to throw over my test variable value and update it...
17. ### Transpose Columns to Rows and Repeat with each Row

Hi, I have a table of names as columns and skills matrix as rows for each name. However, I am now trying to move each column (name) to row and repeat all of the skills matrix for each name eg shown below. I have Names listed from Col B to Col W and may keep on increasing and changing and have...
18. ### debugging VBA code: compile error: member or member data not found

Please help what's wrong with this code: results in compile error: member or member data not found Sub test() Dim rng1 As Range Worksheets.Sheet1.Range("D15").Value = "test" Stop End Sub Thanks
19. ### Open This Workbook.Path

I'm having problems understanding how to designate a specific file path on this line of code. This works as long as the file is one folder before \old reports..... As soon as the file is moved the code no longer works. I would like to be able to hardcode a folder such as...
20. ### VBA solution to create worksheets based on cell value and then copy data to its new worksheet

Hello, I'm looking for some code that will: 1. Evaluate my data set in my "test" worksheet. The header for my data set begins in worksheet("Test"), cell A3, and the size of the data set varies weekly. 2. Create new worksheets (and name the new worksheet) based on the cell content is the...

### This Week's Hot Topics

• Timer in VBA - Stop, Start, Pause and Reset
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
• how to updates multiple rows in muliselect listbox
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
• Delete Row from Table
I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
• Assigning to a variable
I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
• Way to verify information
Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
• Active Cell Address – Inactive Sheet
How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...