I've been tasked with cleaning up my company's report. I like to pretend that I'm competent in Excel until I attempt to create a macro. They're the bane of my existence but, with what I need to do, I have to create one.



I've attached a simplified version of my report but here's what I need to be able to do:
Upon the update on a cell (c1) I need to have cells C3-F6 sorted descending.

It always seems simple enough but I've been googling all over but I cannot figure out how to make other people's macros work for me. Any help with this matter would help tremendously. Keep in mind I'm VERY new to macros.
This may be a stupid question but do I need a macro or can this be written in VBA so that it recognizes that cell c1 has changed? Apologies in advance for the stupid questions!

In the meantime I'll be cursng Microsoft's name and attempting to fry my computer's motherboard with my tears.

Thank you!

Attached Files

MTD Summary Example.xlsm (13.0 KB, 10 views)