macro - if/then

Hiker95 provided me with a code as noted below. I tweaked it some. What I'm looking for is if Column H contains any portion of the word "Resolve" to exclude that row. Sub bailsmb() ' hiker95, 10/13/2015, ME894007 Dim we As Worksheet Dim c As Range, lr As Long, nr As Long...

Hi, I was a Macro that help me to highlight parallel cells in column B IF cells in column E containing #N/A. So if a cell in column E row 3 is #N/A I want column B row 3 gets highlighted. Regards, Shirin

Hi All, I am trying to copy certain data from one Excel Sheet to another (Excel 2010, Windows 7) Sheet 1 Data A B C D 704 Smith 709 Heaton 711 Williams 712 Senior Sheet 2 Data A B C <colgroup><col><col><col></colgroup><tbody> 704 1...

Hi! I'm using Excel 2010 and I have a fairly straightforward issue that I'm trying to solve. Any help would be greatly appreciated! I'm a good programmer but I'm new to VBA, so I don't know enough syntax and it's taking me forever to do what I think should be pretty simple... :) I have a To Do...

Hi All, This is my first time working across sheets. I tried to copy the format of another program that worked across sheets. This is my code: Sub Search_Finder_Sheet() Dim sh_WC As Worksheet Dim sh_FS As Worksheet Set sh_WC = ActiveWorkbook.Sheets("Walls_OR_Columns") Set sh_FS =...

Hello everyone, I'm new to VBA development and am having a problem getting the below code to work properly. I need for it to sort column Y in ascending order and delete other columns I don't need. Here is what I have so far: Sub SortAndDeleteRows() Range("Y2").CurrentRegion.Select...

I was just wondering if I could make a message here in my first Sub and then Call it in another Sub. I don't know if this is even possible. Thank you if you can help in any way. Here is the code, Sub Procedure() Dim Cell, result As String, I As Long For I = 3 To 17 If Cells(I, 14).Value > 6...

I am Running Excel 2010 on a Windows 7 computer. Both are fully updated. I am trying to build a statement that when a cell has a certain text in it that it will automatically run a macro that I have defined. The macro works fine, but I can not get it to run automatically when the field is either...

I have a data set which contains test results for students, and I need to be able to compile them onto separate sheets. The original sheet looks something like this: Name...............Subject.......Date..........Score Smith, John.......Reading.....4/7/15.........5.5 Smith...

Hi, I struggle with a file of mine: I have one sheet per alley (all similar) for a store. I want to sum up each department on its specif sheet and "A1" has the name of the department on every sheets). If I create a sheet "Fruits & veg" with its name in "A1" too, what should I do to have all...

Hi All, I have a sheet with columns Amount, City and Name. I have a set of names for each location ex: North - Mr.X, Mr.Y, South - Mr. A, Mr. B, East - Mr. D, Mr.F. And a few cities in each of the locations Like North - Boston, Detroit Etc. Can Anyone please help me to provide a if condition...

(RE-POSTING DUE TO POOR FORMATTING ON ORIGINAL THREAD) Hey guys, I have the script below sort of working. It's posting the formula like it should if column 'K' = "PENDING" and column 'R' = "". No problems so far. The issue that I'm having is that when it posts the formulas, it posts the exact...

I would like to know the easiest way to paste a formula while recording a macro - I have tried referencing the formula from another cell and pasting it in that way and it does not work. Also tried pasting from text file which does not work either. I've tried various methods from other threads...

So I have a macro i have made that formats a report each pay period the way i want it. However I am never happy and want to make it more efficient. I would like my macro to search for Grant total, and when found to shade blue and bold cells P through T of the same row as Grant total, And...

Need assistance on creating macro to check cell content, IF it equals cell above THEN cut a range of cells in that row and paste into row above and to the right. Can this be done WITHOUT VBA code usage. I'm just a beginner macro user and so far have only used "point and shoot" macros,... no...