3.value

I have a bunch of IP Addresses in Column C that are in consecutive order containing duplicates. In Column D I have a text value that could be 1 of 4 items (Critical, High, Medium, Low). I need to delete the Duplicate IPs and Sum the occurrences of the criteria in another Worksheet to the same...

The Code doesn't like: If Sheets("TRAVEL INFORMATION").Cells(p, 3).Value <> """" I want it to create a tab if that cell is not null. Not sure why it doesn't like this Sub CreateTripTab() ' Dim p As Integer Dim LastRow As Long ' With Sheets("TRAVEL INFORMATION")...

Hi everyone I need to add a text to the column C if the text in column F like P-D, or P-E so on. I have done the code but nothing has occurred and I think it may be because of the hyphen. I want to make the criteria either P-E or P-K or P-H then shows as 'No', however I am unsure should I use...

I want to use "concatenate" here...but dont understand how to use.. With Worksheets("Sheet1") For i = 3 To RowCnt1 If .Cells(i, 3) = "" Then Else .Cells(i, "B").Value = WorksheetFunction.Combin(.Cells(i, 3).Value, " ", .Cells(i, 4).Value) Next i End With

Hi, I am not sure if this can be done with formulas and Excel tables, or whether I should try something in VBA. What do you think? I need help from design point of view, what do you think should be utilized. for each id in input table numRows = countif frequency rows + nonempty cells within...

I have a macro workbook that one of the functions is to go thru a list of members and create a copy of the "Master" workbook. These workbooks (and the Master too) when a user goes to open them always receive the Read Only which is forcing them to save as a different name and then rename their...

Hello, I am working on a spreadsheet that I have a goal seek function to find the optimal number of units based on certain parameters. My problem is that I need to round these numbers up or down depending on which one it is. I found a solution that mostly works but sometimes it does not act...

I am in the middle of a rather Large Build. I was tasked with adding another pull to the tool. For each Data pull, I have 147 networks that are being pulled. The macro I have right now, will pull the data once, place it in a sheet, use a combination of 26 formulas to grab the Data needed from...