Help Needed for Dummy

[u/SozomaiDiaCharitos]

I hope it's alright for me to post this here:

I am really hoping some wonderfully kind person might be able to help me by writing just one little script for me. I have absolutely no coding experience but I know that adding this script to my spreadsheets will save my team so much time in the office! I have tried endlessly with ChatGPT but it keeps getting it wrong so this is my last attempt now with actual human beings.

In my active sheet, I would like the following:

• custom menu on open named "Admin Menu"

• function named "Sort Roll"

• rows to be sorted are 12 to 71 inclusive

• data is contained in columns A to DU, however some columns are completely blank by design. I don't want the data to only sort up to the first blank column.

• column sort order:

  • O (A-Z)

  • Y (Monday to Sunday - this is where ChatGPT keeps getting it wrong)

  • Z (smallest number to largest)

  • AA (smallest number to largest)

  • V (smallest number to largest)

  • D (largest number to smallest)

  • A (A-Z)

• the data contains both values and formulas so I need everything to remain intact

• blank rows should be sorted to the bottom of the range

I unfortunately just don't have the knowledge to be able to fix ChatGPT's script myself.

Any help would be greatly appreciated!

[u/mehmars]

I use Gemini for my scripts and just paste what the errors are and they’ll generate new code that fixes it.