Looking for vba or formula help

[azrcguy]

Hello all been searching for a while now and cant find what I'm looking for. Still new and trying to teach myself to write vba codes

I'm trying to loop through the J column on my sheet (which changes size due to inserting rows) and looks for the word "install" if it finds it, grab the number that is in the C column and perform a small formula (value in C *20/60) and put that result in the K column.

any help on this would be greatly appreciated

 

[azrcguy]

Given that and assuming the values in column J are not the result of formulas, try this with a copy of your workbook.
This does not test every row in the range, just those that have something in column J. So in my sample sheet below, only 3 tests needed.

Sub Test()
  Dim c As Range
 
  For Each c In Range("J14", Range("J" & Rows.Count).End(xlUp)).SpecialCells(xlConstants)
    If UCase(c.Value) = "INSTALL" Then c.Offset(, 1).MergeArea.Cells(1).Value = c.Offset(, -7).MergeArea.Cells(1).Value / 3
  Next c
End Sub

Here is my test sheet after running the code on a sheet with different sized merged areas.

azrcguy.xlsm
	B	C							J	K
14		5								1.666667
15	DATA								INSTALL
16
17		2
18
19
20	DATA								DROP
21
22		1								0.333333
23	DATA								INSTALL
24
25
Install

This works great. Thank you very much.
On a work pc and downloading anything is an act of congress but ill look into it

 

[Peter_SSs]

This works great. Thank you very much.

You're welcome. Thanks for the confirmation.

On a work pc and downloading anything is an act of congress but ill look into it

If you are unable to use XL2BB then in any future questions it would be a good idea to state that in the first post so that we do not keep asking.