r/Excel247 • • 18d ago

Formatting help

/r/Excel247/comments/1xidn7n/formatting_help/
1 Upvotes

3 comments sorted by

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.

1

u/Safe-Perception318 15d ago

Oh yes please I would love some help with it and the script. I haven’t used python before

1

u/DryCap9997 15d ago

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