vba .formula

I have the folowing formula in cells in col G =IF(ISERROR(VLOOKUP(C4,$A$3:$B$596,2,FALSE)),"",VLOOKUP(C4,$A$3:$B$596,2,FALSE)) if there is no result then the cell is empty. I want to hide rows where cell G cotains a result . I know how to hide blank rows but can't seem to modify the code to...

I am using the following VBA Code. Colum A in the sheet has a formula that pulls data from another sheet that is sorted via a VBA code on value in a different column . The problem is that this code does not sort at top due to zeros in blank cells. Is there something that needs to be added to...

Hi all. I am trying to develop a questionnaire with 50 questions. I can only fit 13 questions on the screen. Do I use scroll or split the form? Each question has 5-options (very inaccurate, moderately inaccurate, neutral, moderately accurate, and very accurate). Each question has 5 option...

Hi all, In a psych experiment I am using forms where my participants enter their Participant Number in a textbox (TextBoxSubjectNumber, which saves to cell A2) then complete some psychological questions which have 5 choices (Strongly disagree, disagree, neutral, agree and strongly agree). Each...

I am working on a spread sheet that has a column with various single characters in it, such as 2,8,? and E, what I am looking for is for excel to send an email to an address if one of the cells in this column changes from any of the before mentioned characters to a [.......................any...

I am new to VBA and am trying to get one to work. I have copied one from a forum and I'm pretty sure it will do what I require. The code is as follows: Sub test() Do myRange.Replace What:=" ", Replacement:=" ", LookAt:=xlPart Loop Until Application.CountIf(myRange, "* *") = 0 End...

I need to create a VBA code that will accomplish the following in a specific Col Example 904020161 to XXXXX-XXXX-XX where zeros fill in to create 00904-0012-24 88904020161 to XXXXX-XXXX-XX or 88904-0012-24

Hi, I am comparing the signs of rows in 2 columns. If the sign is different, I want to multiply the 2nd column by (-1). I have the code below, but it is not working. For k = 2 to k If sgn(k,"O")<>sgn(k,"P") then range("P"&k)*(-1) Next k End If

Hello, I'd like to know if you could please help me with VBA code for generation of row values in 1 column. I'm looking at how I can write in VBA a macro that generates values in a particular column (say 'x') that has a few hundred rows (of variable length) within a table. I would define these...

I am trying to create tow formulas that will enter the contents of A1 from sheet 1 in A1 of Sheet 2 and b1 from sheet 1 in b1 sheet2 and c1 from sheet1 on c1 sheet2 IF b1 in sheet 1 is is <7 or c1 sheet 1 is>12. I hope you can help, Thank you in advance. </SPAN>

Hello, The following function will work when CTRL-SHIFT-ENTER from a cell in Excel =MAX(IF((A2:A1655="ProductName"),C2:C1655,0)) where C2:C1655 contains a list of values. i.e. this will return the maximum value from an array (column C) if it meets criteria met in another column (column A)...

hi, im having a little trouble trying to write a formula to count the occurrences of a phrase in the range B:B, but i want to count the phrases separately depending on there cells fill colour.. ie. if the cells fill colour is red it would be counted and added to the f1 cell, if blue f2, if...

Hi, I have a userform that is coded to enter data into the next empty row on a worksheet. The first 8 columns are populated with data from the user form, I need column 9 to be populated with a VLOOKUP formula. The extract code below does enter the formula, but "MONTH(B8)" appears to be absolute...

Excel 2007 Windows XP Hello I need to populate a table with two formulas. The numbers of rows and number of column will vary. I've got my code up to the point where the table is outlined: <tbody> Employee Name Job Title 7/22/12 7/23/12 7/24/12 Employee1 Employee2 Employee3...

Hello, I’m a newbie at programming in VBA So I hope someone here can help me along. What I’ve been trying to do these last weeks is getting a nice looking overview of empty locations in our warehouse. I Actually did get it to work(barely) with the conditional formatting function. However since...

I have the following command buttons in a sheet. he problem is that when I use the CommandButton2 Clear col A and B function the formulas in the cells of Col d- h are cleared as well. Any suggestions? Private Sub CommandButton1_Click() ActiveSheet.Unprotect "Passwordgoeshere" 'Toggle...

I have a SS that puls data from another sheet using the following formula =IF(OR('Site Visit ASSESSMENT'!D9={"PARTIAL COMPLIANCE","NOT COMPLIANT","NOT ASSESSED","ADDITIONAL INFO NEEDED"}),'Site Visit ASSESSMENT'!A9,"") I also have VB Code in teh sheet as follows to hide rows. If I protect...

I am trying to have a value from sheet1 'Site Visit ASESSMENT for a specific cell to appear on another sheet (let's call it sheet 2) only if if certain statements exists in another cell such as E3 in sheet 1 Statemetns are PARTIAL COMPLIANCE,NOT COMPLIANT,NOT ASSESED,ADDITIONAL INFO NEEDED...

Hi, Is there any way to change singular words to plural in excel? example dog to dogs best regards,

Dear helpers, I need some help with my code to select multiple rows and columns to use with a function within a macro. I basically need to select the rows based on duplicates in the street column and the A,B,Status columns to give me a new Status based on the criteria in the Macro...