Update range in the formula based on the new data (countif) vba

[Sherilyne]

Hi.

I want to automatically change the range of my formula in cell AG4 =COUNTIF(AG2291:AG4459,"Active") to newly added data in column AG. Note that my new formula should only capture the added columns as its range.

Thanks!

 

[billgyrotech]

Perhaps if you make it a table then the formula range will grow as data is added.

 

[Sherilyne]

Hi, Billy.

Thanks! But I only want the formula to reflect only the new added data as its range. Kindly refer to the link.

https://www.dropbox.com/s/5mmg0yidfos3j1c/sample file.xlsx?dl=0

Thank you!

 

[billgyrotech]

I referred to your link and the file is too large and inefficient sorry I cannot help you with this file. Consider multiple workbooks and link to master. If I were you I would post a different question on how to do this.

Good luck,
Billy