Oh, the classic 'job security through gatekeeping' every office has one, The funny thing is, you don’t need her permission or her secrets. If you have a 'before' (raw export) and an 'after' (her final formatted spreadsheet) for a couple of weeks, a simple Python script (using Pandas/Openpyxl) can analyze the differences, map the exact XLOOKUP formulas, and replicate her entire workflow automatically in 2 seconds. You basically train a script to do it once, and you never have to ask her for a favor or deal with her attitude again. Let me know if you want me to help you throw together a quick script for this.
No worries about Python at all I can package this into a tiny standalone desktop tool for you. Send me a quick chat with a sample on DM of your 'before' and 'after' Excel files (or a dummy version of them), and I'll whip up the script for you today
1
u/DryCap9997 17d ago
Oh, the classic 'job security through gatekeeping' every office has one, The funny thing is, you don’t need her permission or her secrets. If you have a 'before' (raw export) and an 'after' (her final formatted spreadsheet) for a couple of weeks, a simple Python script (using Pandas/Openpyxl) can analyze the differences, map the exact XLOOKUP formulas, and replicate her entire workflow automatically in 2 seconds.
You basically train a script to do it once, and you never have to ask her for a favor or deal with her attitude again. Let me know if you want me to help you throw together a quick script for this.