Find Text and Insert Formula

Hi Everyone,

I am on the verge of perfecting this macro just need help pushing over the top

Want to Find text in Column A and insert a formula into Column H that will sum Cell Adjacent In G and the One Below It.

This goes through an entire work sheet and is not even

Ex: Find text in A5 and want a formula in H5 that will sum G5 & G6

My Macro Formula is off but everything else works fine. The $ keeps going into 6 Locking that cell which is what I DONT want

This is what I have thus far THANKS!!

Please Login or Register  to view this content.

Hi.

Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

On test with stuff in rows 6-9 and your 8p-12a...text in A9 I see

Formula:

Please Login or Register  to view this content.

Removing the $ sign (caused by the 6 in
"=(RC[-1])+(R6C[-1])"
I get

Formula:

Please Login or Register  to view this content.

What result are you expecting?

Hi,

In that case the relevant line needs to be

Please Login or Register  to view this content.