Find a value and insert a value in a corresponding cell.

[th29]

Hi,

I need to insert the formula "=1+1" into column H of every row with the value "Complete" in Column F.



The end result would look like:

A B C D E F G H I
1 Complete =1+1
2 Incomplete
3 On Hold
4 Complete =1+1
5 Complete =1+1
6 On Hold
7 Incomplete

[HSV]

Please Login or Register  to view this content.

[th29]

That did exactly what I asked. Unfortunately, I made a mistake in the asking. I completely forgot about relative references when pasting the final formula that I will be using. The way I had it pasting the formula as text in column H is creating an absolute reference.

I'm going to start over from scratch, and just describe what I would do if doing this by hand.

Cell H2 will always be my starting point.
I will always paste the formula "=C2+1" into cell H2 to start with.
The next step would be to grab the handle on H2 and drag my formula down column H until I get to the last row of data, letting relative references adjust as I drag.
I would end up with formulas that read =C2+1, =C3+1, =C4+1, ...all the way down column H

I had an old macro that would do the paste in H2 and then drag for me down to row 1000 in column H, then follow that up with a delete of all rows with no data in column A. That would effectively find the end of my data in a roundabout way. Assuming I never go over 1000 lines of data, that would work, but I hate to leave loose ends.

Is there a way to paste "=C2+1" in cell H2, then copy the formula from H2 all the way down the remainder of column H (applying relative references), stopping at the row in which data ceases?

[HSV]

Would this do it ?

Please Login or Register  to view this content.