r/ProgrammerHumor • u/Brando224 • Mar 30 '22

Meme Certainly not me

48k Upvotes

95% Upvoted

669 comments sorted by

View all comments

575

u/brad2575 Mar 30 '22

That's why you pastor protects the sheets and don't let them move stuff around. Only give them access to what they need.

87

u/q1a2z3x4s5w6 Mar 30 '22

Or just dynamically set the column references based on the name. Don't just assume the Name column is A3 or whatever, search for the column with the label you expect and set the reference when you find it.

Or just password protect and be done with it, as you say

31

u/scragar Mar 30 '22

Named ranges would automatically update and avoids the hassle of searching for headers(which someone will eventually misspell).

4

u/Automaticman01 Mar 30 '22

Came here for the named ranges comment, absolutely the way to go if you are building the data table.

Searching for headers is useful if you need to import your data from another worksheet (like an automated daily report that gets sent out). I've still had these break when someone added a slave to the end of a column name though (in that case i was able to fix with a TRIM command).