Copy/Paste Formula to many cells on the same column

[rpd2015]

Good day!

I am an average excel user, i only know the basics and I have no knowledge on Macro or VB. But I really wanna shorten the time I complete my monitoring worksheet. Basically, I have a tab where i source all my formula from another tab. On this tab which contains all the formula, I basically need to copy one formula all the way down to the end of the table but i cannot drag it down since the table contains cells with different formulas. Is there any way i can make this process short? I have like 10 worksheets and each worksheet has like 10 tables, so that's like 100 times of copy paste actions.. it eats up my entire day just doing this.

Also, I was going to attach my sample worksheet here but I don't think I am allowed.

Would very much appreciate any help here. Thank you so much!

 

[MARK858]

Please see my signature block at the bottom of this post which has links to ways to post useable screenshots of your worksheets.

 

[rpd2015]

Please see my signature block at the bottom of this post which has links to ways to post useable screenshots of your worksheets.

Please use below link to DL my worksheet please... THANKS A LOT!! T_T
https://www.dropbox.com/s/ckm2cv0tgek5zqv/OPEX Monitoring Sample 2015.xlsx?dl=0