test

Hi all. I need help with some VBA using find and match type queries. I have a worksheet which has columns: ID, test depth and test result. I have a second worksheet which as ID, start depth, end depth and category. What I need the code to do is loop through each row in the first worksheet and...

Hello, I would like some help with a bit of code. What I have is some dates in cells H3:H. I would like toenter in the word "1Y" in the next cell I3:I and it will add 1 Yearto the date in H3 and apply it to cell I3. Basically, I need to tract when people have done a test, andif they are due...

I am trying to work out a way of identifying individuals in a random list as opposed to non-individuals, where each individual does have a known identifier in a separate list. And then cutting out the entire row where the individual is identified to paste into a separate sheet. For example in...

im having trouble with making a code that will extract data out of a sheet that ill have a varying range and turning it into a chart sheet. can someone help me out please or point me in the write direction. tried this but dont know how to vary range Sub test1() Dim test As Chart Set test =...

Hi all, I've tried reading up on regular expressions but I am drawing a blank as to how to extract from a string 3 consecutive digits (no more, no less). So if I have: <tbody> A B 1 String: my test 1: 123 string 23: 456 that I need to extract numbers 25 789 from. 2 Expected Output...

I have a database that produces reports about tests taken by students all on one row. The data always includes a test name, test date, and one or more scores. E.g.: <tbody> Test Date Algebra Geometry Arithmetic Test Date Spelling Math 2/2/2019 40 50 60 English 2/5/2019 70 </tbody>...

Hi, I have a list of customer names in column A of sheet 1,their product testing results in columns O, R, U, and X, and the time tests completed in column AK. I need a way to populate sheet 2, column A through F (B, C, D, E, for test results option) and F for the time test conducted with the...

I have a list of Presidents in B2 with a dropdown. I would like to loop thru dropdown in Cell B2 of "Test". Then copy contents from A1 to end and paste in new sheet for each change in filter ie called "Test_Washington" , "Test_Kennedy" etc

I'm making a workbook for both Windows & Mac. I have a button in my workbook that allows them to PRINT worksheets, and another that allows them to make a PDF of worksheets. Both buttons work perfectly on Windows. On Mac 2016/2019/365, the PDF button works fine. It’s the PRINT button that...

Hello, I have a table which tells me which class a student is in; <tbody> Student Group1 Group2 Group3 Group4 StudentA 2 3 4 6 StudentB 3 4 1 7 StudentC 6 5 4 2 StudentD 2 3 7 1 </tbody> I would like a VBA code which; Creates a list of students in each class from the table above...

I have four worksheets in my workbook that I wish to hide. All four are running data refresh via web queries when the file is opened and I am wondering if they will still be able to do that if the sheets are hidden? Unfortunately, I can’t test it because the updates are year-end and I would like...

Is there a way to conditional format a column in a pivot table but not include the subtotal cell? I am thinking I would test for the word 'Total' in column A and if it is found then don't perform the formatting. I am not sure how to test for 2 conditions in the formula so any help is greatly...

Hey, First post here and I can usually find the help I need after some googling. Today I have failed since I could only partly find what I was looking for. First I tried power query and failed but then I ended up at VBA which most likely will fix the problem for me, but I just don't have the...

Hi, How to refer Application.WorksheetFunction to the variable which represents column of table? This macro works perfect: Public MyTable as Object Sub test () Set MyTable = ThisWorkbook.Worksheets("Sheet1").ListObjects("MyTable_table") Msgbox...

I am unable to retain the position of a punctuation in the text while performing Cambridge Transposition (which scrambles every word in the string except the first and last). The reference code is: Sub v(strText) m = 1: Z = Split(strText, " "): j = UBound(Z) For u = 0 To j t =...

How do I create a question and answer bank with excel in a way that I can randomly produce tests with corresponding answer sheets? Also, I need to create multiple choice tests. Little about me: real dumb. Basic instruction and guidance is appreciated. Thanks in advance!

Hi I have this as data in column A , B to create a pivot test 1 Test 1 Test 1 When I do a pivot it returns on the data above it returns only 1 line as test 3 (3 is the total) '************************************* Is there anyway the pivot returns ? test 1 Test 2

Hi there, I've built a Chi square test and a column proportion test in Excel and am now trying to build a grouping of the results. I've started off with this example: https://www.ibm.com/support/knowledgecenter/en/SSLVMB_23.0.0/spss/tables/sig_tests_colprop_ex.html#sig_tests_colprop_ex The...

Thanks in advance for any suggestions for which I will give feedback. Why is the following code not executing? I would like to deselect "Test" which exists in the Pivot Table. Sub Macro7() Dim ShtNameOld As String ShtNameOld = "Test"...

Hi, I will insert this formula to cell with VBA =COUNTIFS('today'!C:C;OOS_daily!G1;'today'!G:G;0;'today'!D:D;"<>N";'today'!O:O;0;'today'!P:P;">0") I try this; Sub test() ' ' test Macro ' ' Columns("G:G").Select ActiveSheet.Range("$G$1:$G$50000").RemoveDuplicates Columns:=1...