Auto Fill formulas down the same column in multiple worksheets

[myobreportguru]

Could someone help me with code for the following please?

I would like to extend a formula down column J when new data is added to columns A to E. The formula in Col J is "=IF(E819="DR",J818+D819,J818-D819)". Then I want the same thing to happen to all the worksheets in the same workbook but could be starting from a different row. I guess the formula might not be important if I could just extend the formula from the last row in Column J.

Regards
John

[TMS]

Why don't you just convert your data to a Structured Table?

[myobreportguru]

Thanks for your reply but I'm not sure how to do what your suggesting. I will attach my worksheet. I'm trying to extend the formula down in each worksheet
in Col J whenever the data in Cols A to E are added to. I have some code in the first worksheet which does work but I want to do the same to all the
worksheets at once if I can.

[TMS]

I never use AutoFill. I'd do it this way:

Please Login or Register  to view this content.

[myobreportguru]

Thanks for your help on this. It's working great.

[TMS]

You're welcome. Thanks for the rep.