copy formula and paste it to dynamic table

Hello Experts

I am looking for better way to copy formula and paste it to dynamic table (I don’t know how many rows there is at the table).
The procedure takes long time for the user.
(the table may contain more than 30,000 rows !!).
My suggestion:

Please Login or Register  to view this content.

You could perhaps replace all of that & apply to the range simultaneously with the below:

Please Login or Register  to view this content.

EDIT: revised above to account for Current Region and fact B is probably blank....

Please read forum rules below. I've amend you're title for you this time.

Try

Please Login or Register  to view this content.

PS No need for an if statement as you can see

VBA Noob

Are you just trying to put that formula in all cells from B2 down to the bottom of the dataset in column B? Perhaps this?

Please Login or Register  to view this content.

If not, click on GO ADVANCED and use the paperclip icon to post a workbook showing what you're doing.