test

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...

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...

I need a macro file with the macro button where it should work as below. - When I click on the macro button, pop up should open to select the report from my local drive(the report will be in .xls or .xlsx or .csv format) - Once I selected the report it should ask for the column name to input. -...

Hello , I have an excel file which is the source document and I have other excel files which are destination files all in one location. - I want VBA to open the source excel and Format the Date in Column C of the source to MM YYYY. - Check if column A has the word 'SIGNAPAY' , - If true then...

I have a large data table that was not very well put together. I need to find the last test date a student took a specific test in a range that contains also contains dates for the other tests they've taken. My table is as such: ID | LName | Test Date | Math Test | Score | Eng Test | Score |...

Evening All Wondering if someone could lead me to an alternative. The below Loop deletes the row if a cell condition (Text "Test") is located in Column J, also looking to delete the 3 rows above. Coincidentally found a similar request on the forum yesterday, however unsure how to amend. Thank...

I have the below spreadsheet for test scores. The first column lists the test dates for each student and another lists the test scores. if the student passed, there's a "P" for their score. The spreadsheet has 260 records with dates throughout the year. I'd like to count how many records with a...

Hi all. I need Excel to count lines that include the phrase "test & 10", but not to count other lines that only have the word "test" without the & 10 I'm finding that I get zero results for "test & 10" as the keyword 'test' is filtered out in the 1st argument. The formula I've tried is...

Hey guys, I'm trying to learn how to use factorials, this is a simple example: Option Explicit Function factorials(nr As Long, Optional factorialsTest As Long = 1) Dim test As Variant factorialsTest = nr * factorialsTest nr = nr - 1 If nr <> 0 Then Call factorials(nr, factorialsTest) test =...

Hello, people, Wow. This forum sure makes it difficult to show a sample spreadsheet. And I've read posts complaining, but that rule apparently ain't gonna' change. Ah, well. OK. I've done a lengthy search, found many people with the same problem, but no answers. How, in Excel 2007, to...

Good morning, I have an excel file which is the source document and I have other excel files which are destination files all in one location. - I want VBA to open the source excel and Format the Date in Column C of the source to MM YYYY. - Check if column A has the word 'SIGNAPAY' , - If true...

I am currently working through middle size data sets, around 1000 recordings, and want to be able to work through them quicker. My main problem is that if I have a column marked "test" with results from the tests in a different column marked "results" with the values, is there a shortcut to lets...

Hi, I have not used VBA in months and my first task back is trying to create a menu page which will have a data validation drop down with multiple selections on there which I want to link too certain sheets. So when selecting "test" from the drop down list then it will take me to the "test"...

Hello, I have different excel workbooks in the multiple locations and would like to open them and copy into a new excel. Example, This is the standard location - C:\IT\Test Project\2019 Further the 2019 is divided into 12 monthly folders named 1-2019, 2-2019, 3-2019 etc. Each of the monthly...

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...

Previous correspondence about this post is found at https://www.excelforum.com/excel-formulas-and-functions/1285077-formula-for-variable-date-ranges-in-if-logical-test.html#post5168556 -------------------------------------------- I am trying to make a formula that works something like...

Is there an IN function in excel vba that I can use ? In SQL I can do something like this: Select * from table where field IN('value1','value2','value3','value4') Is there something similar that I can do in Excel? I have this If statement below that I want to do this to: If...

Hi excel gurus I need a formula that will return a value of 1 in a cell, if the contents of another cell are between 2 ranges, ie, it needs to return a value of 1 if the test cell contains any number between 60 and 64 or 86 and 90. if the value in the test cell is not within these 2 ranges, it...

I maintain an aged workbook for my company that is twenty years old (approximately), containing over 20,000 lines of code. There is no documentation for the workbook. I am having difficulty successfully publishing updates to it because there is no test plan. If anyone has a guide, or a link...

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...