Insert formula up to last Row

[Barieq]

Hi,

I want enter below formula up to last row based on column A. Below is the code which I am using in which I have to insert the formula if certain criteria meets. I need to extend this formula up to last row.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

' Need to enter this formula upto last row based on Column A

[Fluff13]

How about

Please Login or Register  to view this content.

[Barieq]

How about

Please Login or Register  to view this content.

Thank You, works perfectly.

[Fluff13]

You're welcome & thanks for the feedback.

[Barieq]

@Fluff13,

Sorry, Now when my data rows increases, the lookup value row is variable. How can handle this problem. Row A184 may increase or decrease, but column will always be constant.

Please Login or Register  to view this content.

[Fluff13]

Can you supply a sample file, also is the word total only found on 1 row in col A?

[Barieq]

The word total found in more than one rows. Actually it is pivot table and I inserted additional column to calculate SAR. I have attached the file for your reference.

[Fluff13]

Thanks for that, how about

Please Login or Register  to view this content.

[Barieq]

@Fluff13,

Thanks, I never thought about R1C1. Solved.

[Fluff13]

Glad to help & thanks for the feedback.