Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Find the largest sum of 3 consecutive days

0
Please help Vba Code find the largest total of 3 consecutive days in the data area
Answer
Discuss

Answers

0
Selected Answer

HGVIET,

This is not an answer but I had to use the "Answer" portion to be able to attach a file.

Again you have posted your question incorrectly. You haven't followed the guidance I gave in your last post so I have attached a file with screen shots that hopefully will make things clear to you.

Also the cell references in your file are a bit confusing. You state " From (A6:M36)" - should that be "B7:M37"? And should "Sum(A6:A8)" be "A7:A9"? Or "B7:B9"? And "Sum(B35:C6)" - what is this. You haven't made it clear what you want summed. Do you want to sum the 1st, 2nd, & 3rd for Jan (B7:B9), then 2nd, 3rd, 4th for Jan (B8:B10), etc and find the largest amount? Or, do you want to sum the 1st, 2nd, 3rd for Jan thru Dec (B7:M9), the 2nd, 3rd, 4th for Jan thru Dec (B8:M10) etc and find the largest amount?

This can be achieved with or without VBA but I'm not going to spend any time on this unless you go back to your last post and follow what I've said (and abide by the Forum rules).

Discuss
0
Sorry, I sent the wrong file and sent it again, thank you for your reminder.
Discuss

Discussion

It seems obvious that you are unwilling to follow instructions. You selected my "answer" above despite my stating it wasn't an answer (which clearly it isn't). You continue to post questions and discussions the wrong way.
The file you attached above is the same file from your original post. You haven't answered the questions I asked above.
These are just a few of the reasons why I am not going to do anything further to answer your question. Good luck.
WillieD24 (rep: 637) Oct 26, '24 at 9:50 am
HGVIET,

If you want to get an answer to your question you must first go back and correct the errors in all of your posts as I have described.
WillieD24 (rep: 637) Oct 27, '24 at 1:44 pm
HGVIET<

I have a solution to your question. I will post it but only if you fix your posts.
WillieD24 (rep: 637) Nov 3, '24 at 1:14 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login