A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hello Bob Spence,
Thank you for posting your question in the Microsoft Q&A forum!
I realize that you've encountered a problem with Marco Excel. I truly understand your confusion. Let me assist you further.
For me to provide the most accurate solution, I just need to confirm that: Do you want the macro to sort only the active sheet or all week sheets (W01–W52), and does the range C4:L255 include a header row (so Header:=xlYes) or is it data only (Header:=xlNo)?
And could you share a screenshot of the area around C4:L10 (or any small portion of the range), if possible? Please crop or blur out any personal or sensitive information first (names, emails, IDs, client data, etc.).
I am looking forward for your respond. Thank you so much for your times.
Best Regard,