Insert a formula if there is a value on a cell in the same row

[abrilabs]

I need to get a macro that if a row has any value on column D, it creates a formula in column A, another formula in B, and another formula in C.

Column A's formula is =VALUE(RIGHT(D6,7))
Column B's formula is =CONCATENATE(D6,"_",TEXT(COUNTIF(D$4:$D6,D6),"000"))
Column C's formula is =CONCATENATE(D6,"_",G6)

Also, it needs to ignore rows 1,2,and 3 as the data starts on row 4.

Entering all these formulas as a template takes up a lot of space in the file since the data could be 300 rows or 30,000 depending on the day. This is why I need a macro so the formulas are only entered when there is a value that needs them.


Can you please help??

Thank you!

[:) Sixthsense :)]

Try the below code...

Change the Start and EndRw Values to your desired rows.

Please Login or Register  to view this content.