Please help with calculation on last line

I need help with calculation on last line, bit it must also recalculate with filters


Below is my code. it auto calculates and works out everything 100% i just have no clue how to get my total as aa calculated field that auto calculates when filter is added.

I need "F = (D-C)/D " on the last entry line.

here is my code below

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

I think you need to read our rules - this is the second you have now broken.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I will do it for you this time.)

Please confirm that you have read (and understood) thee moderation notes you've received today. Thanks.

It is in tags because I had to do it for you! Please read post #2 in FULL.

I cannot add to first post as that was a totally different query ... This is a totally different error. so its not duplicate.

You weren't asked to ... And I never mentioned thread duplication.

Have you read our forum rules now? I wouldn't want to find myself having to pull you up again. There is a link at the top of the page - our rules are short and simple to follow. Thank you.

EDIT: I have sent you a private message regarding the negative rep you have given me today - please do me the courtesy of responding. Thanks.

This is the answer to your question.

Originally Posted by AliGW

It is in tags because I had to do it for you! Please read post #2 in FULL.

Ali is just asking you politely to confirm you have read and are ready to abide by forum rules, nothing more nothing less.
Bu alas, you choose to be rude AND ignore the question...
If the forum rules are that difficult to read/apply, then perhaps you should draw your conclusions.

No mistake: please see the small text bottom left in your opening post:

Last edited by AliGW; Yesterday at 01:41 PM.

This was me editing your post to add the code tags for you. They were not present before. I said this at the end of post #2:

(Note: this change is not optional. As you are new here, I will do it for you this time.)

and this in post #6:

It is in tags because I had to do it for you! Please read post #2 in FULL.

So your question has been answered already.

Both Pepe and I assist thousands of members with their queries, but we also have jobs to do as moderators.

Hopefully one of our VBA experts will be able to help answer your query.

You are bombarding me with PMs asking me to answer the questions that I have now answered at least twice here and via PM.

1. My code was in code tags - why are you accusing me of not using code tags?

Answer: see post #12 above, in which I point out (again) that I edited your opening post to add the tags for you. You did not add them - I did.

2. Why are you accusing me of thread duplication?

Answer: I am not - I never did. Your other thread, however, was reported by another member as a cross-post (not the same thing), and you were picked up for that because you had not declared your cross-posting (read the rule).

3. Why don't you help people instead of policing the forums?

Answer: I am a moderator, therefore I have a job to police thee forums. The rest of my time here (most of it) is spent answering queries and helping members.

4. Can you help with my query?

Answer: I have said on at least three occasions now between PM responses to you and here that I cannot - VBA is not one of my skills.

If you insult me or any of my colleagues again, I shall ban you from these forums.

Any further complaint should be taken to an administrator.

Thread closed.