testing

Good morning. I'm a new user to this forum but have been using it for a while now to learn and expand my skill set on different formulas. With that being said, I'm stumped on this one. Here's what I'm trying to do with the data below. If the Column D equals "Monitoring" then I want to count...

Hello everyone, I have this excel spreadsheet and one of the column contains notes. I want to be able to extract a specific text based on a common user. Below is an example of what is on the notes column. These are all on one cell. Test,Name1 10/18/2017 8:43:15 AM > FAXED Test,Name2...

Hi! I have been searching these forums to find a solution for what I want, but alas I can't find a suitable solution. What I want to do is that, when Testing is selected from a dropdown (dropdown created already), an internet explorer window opens. I have written the following code (I didn't...

Hey everyone! I have a data set that I would like to summarize - and no I can not use a data table or pivot chart for what I am doing. I have 4 types of cost classifications - Internal Engineering, Internal Testing, External Engineering, and External Testing I need to have an equation that...

I am running into trouble configuring a cell formula that is testing for multiple embedded conditions based on values in 4 separate cells. In fact, it seems that there are perhaps dozens of possible outcomes. I've begun by testing with nested IF(AND( statements. I can see how this could...

Hi all, Was hoping someone could help, I have written the below: Lastrow = .Cells(.Rows.Count, 1).End(xlUp).Row branchCol = .Range("1:1").Find(What:="Property_Branch", LookAt:=xlPart).Column Set dltRange = Range(Cells(Lastrow, branchCol), Cells(2, branchCol)) 'delete...

I always have problems with the ""'s in setting up the following link In my cell ref I have: F4 C:\Users\Owner\Documents\ExcelChest\ F20 MySourceWB.xlsx G20 Testing (My Sheetname) H20 A1 (contains text) This is my current attempt, which IS NOT working...

New member here & I am sorry if this is posted & answered elsewhere. I tried to do a search but wasn't finding exactly what I was looking for. I am trying to automate a workbook for another department at my office. As they are not too XL savvy, I saw an opportunity to help the team and get some...

Hi I have a page of data in one particular cell (i imported an email into it). What i would like to do is remove many words between sentences so i am left with the data i require. For example Cell "A1" contains Hello this is a test Customer require IF Testing 123 etc,etc I would like to...

Hi, I would like to save the active workbook as a specific name which is obtained from a cell in the workbook, then close the workbook. It's a test results sheet. The engineer opens the master, he adds his results and then clicks a button which says "Testing Complete". I'd like the master to...

Hi, i have built this if formula, which works correctly until the last if CZ>99 criteria is met, when the formula returns #Name? =IF(CW2<3,"Catch up",IF(AND(RIGHT(E2,3)<>"MPM",CL2>0),"100% Testing",IF(OR(CD2>100,CI2>100,CH2>100),"100% Testing",IF(CY2>99,"100% Testing CI",IF(CZ>99,"100% testing...

I am trying to test whether or a certain file is open already, and if it is closed I am saving data to it. For some reason, my code was working just fine and randomly it stopped working and giving me the message "Sub or Function not defined". I don't understand why it suddenly stopped working...

I'm struggling with a couple of issues, please see P4 to P7 cells highlighted with comments. https://www.dropbox.com/s/fece4t40doduxxc/Mr%20Excel%20Request.xlsx?dl=0 Any tips much appreciated!

Hello everyone, I am working on the tool which helps to verify/test spreadsheet models - http://exceltested.com The idea is inspired by unit testing from programming and many stories when Excel mistakes had serious consequences:European Spreadsheet Risks Interest Group - spreadsheet risk...

I have been learning excel VBA for about 6 months now, its tough some times teaching your self, but a need to better my self has driven me to VBA. With no prior programming knowledge i jumped into this purely by chance while using excel in the office. Recording macros and then realizing i could...

Hi All, We are developing numerous macros in these days:). I just want to know if anybody can help me in documentation:rolleyes:. I am searching for following documents.:eeek: 1. Macro Requirement Request format.;) 2. Design Document for VBA project. 3. Manual testing format for VBA project...

I am trying to create a summary of testing several tests per "palette", as follows: We test several (generally 7) parts off every palette shipped for multiple parameters (width, height, depth, weight). For each sample number, the sample may fail for any of these four parameters. If it fails...

Hi, My query is regarding internet explorer 6 automation via code in VBA (Excel 2003). I'm trying to open a page on clicking a button in main page. I'm able to open both parent and child pages via VBA, but now want to automate events (like radio btn click etc) in child page. Could you...

I have some lengthy macros that I have to edit and test. After adding certain commands i.e. sorting, excel says that this will end the playing of the macro and I have to start over but I really need to test from the middle of the macro so I hit F8 & drag the arrow to where I want it to start...

Hi, hoping someone can help with a string testing problem. I want to test for similarity. I have two columns of data, actually filenames. In the second column, somewhere there is an *almost* identical filename to each of the filenames in the first column. The function needs to lookup the second...