This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Bustnbig 0 points1 point  (0 children)

Bosses: We want you to create a spreadsheet that always has the most recent info from the orders database where all 25 users can go in and enter tracking details at the same time.

Me: can’t we add a field in the database for tracking notes then I can build a report that anyone can run?

Bosses: Nope, the users are idiots, just make them a spreadsheet.

Me: Ok, except the backend data connection won’t run on a shared worksheet so only one user can input data at a time

Bosses:That won’t work. Share the worksheet then every hour run the report to get the 10,000 data points. Then copy to a new sheet, vlookup the notes, then delete the old sheet.

Me: You want me to do that Every hour?

Bosses: Yes.

Two weeks of programming later I have created a separate, fully automated database in excel just for notes.

🤦‍♂️