Below is a shortened version of my code. 
Please Login or Register  to view this content.
This code hardcodes formulas into each month's cell for calculation. Each workbook contains 1 worksheet. I run this code on each separate workbook/worksheet, each havin a different lastRow. I then combine each separate worksheet into 1 master "AllData" worksheet. The problem is the lastRow is now a different number and my formulas are now incorrect. Therefore, I have to run this code again on the new "AllData" worksheet so that it corrects the lastRow. Is there a way that the lastRow is adjustable (I think that is the correct term)?
Thank you in advance for your attention and time.
CC