Seaching Column C changing multiple values in column E

[Halbertzinser]

Hi!

I am currently working on a spreadsheet and need some help! I have column C that lists equipment name, D that has hours ran, and E that has the rate of those hours. Some of my rates are off and I was wondering if there was anyway I could search Column C of a specific equipment name and change column E so the rates are the same for the same equipment.

Any help is appreciated. TIA

 

[My Aswer Is This]

Try this script:

Sub Check_Rates()
Application.ScreenUpdating = False
'Modified 5-9-17 11:05 AM EDT
Dim i As Long
Dim Lastrow As Long
Dim ans As String
Dim Rate As Long
ans = InputBox("Enter Equipment Name")
Rate = InputBox("Enter Rate amount for " & ans)
Lastrow = Cells(Rows.Count, "C").End(xlUp).Row
    For i = 2 To Lastrow
        If Cells(i, "C").Value = ans Then Cells(i, "E").Value = Rate
    Next
Application.ScreenUpdating = True
End Sub

 

[My Aswer Is This]

If you want to enter a dollar value for the rate use this script:
enter value like this: 5.65

Sub Check_Rates()
Application.ScreenUpdating = False
'Modified 5-9-17 11:34 AM EDT
Dim i As Long
Dim Lastrow As Long
Dim ans As String
Dim Rate As String
ans = InputBox("Enter Equipment Name")
Rate = InputBox("Enter Rate amount for " & ans)
Lastrow = Cells(Rows.Count, "C").End(xlUp).Row
    For i = 2 To Lastrow
        If Cells(i, "C").Value = ans Then Cells(i, "E").Value = Format(Rate, "$.00")
    Next
Application.ScreenUpdating = True
End Sub

 

[hiker95]

Halbertzinser,

Welcome to the MrExcel forum.

We may be able to solve your request without looping thru the rows in your worksheet.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


If you are not able to provide screenshots, then:

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com