•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I wired my Excel inventory sheet to WhatsApp so it texts me when stock is low. is this dumb?
Our take
Imagine transforming your daily inventory routine from a tedious 30-45 minute task into a streamlined process that alerts you via WhatsApp when stock is low. By connecting your Excel sheet to a messaging platform, you can automate notifications and even generate purchase orders with simple text commands. This innovative approach maintains Excel as your central data source while enhancing efficiency and accuracy. As you explore this solution, consider the trust factors that would make you comfortable with automated edits to your spreadsheet.
so I got tired of the morning routine where I open my inventory spreadsheet, scroll through 30 rows looking for red cells, then manually type up a purchase order. every single day. maybe 30-45 minutes of just.. looking and copying.
I ended up connecting the Excel file to a WhatsApp number. the sheet is still the source of truth, all the safety stock thresholds and status flags live in Excel like before. but now instead of me opening the file, it texts me when something drops below safety stock. like "Widget A is at 3 units, safety stock is 10, want me to draft a PO?" and I can reply "yeah and add 10 extra to each" and it generates the whole purchase order. last time it spit out a ~$5,180 PO in seconds instead of me doing it by hand.
when a shipment comes in I just text "update Widget A stock to 50" and it updates the file, flips the status from CRITICAL to OK, and sends me back the updated Excel. if it's not sure what I mean it asks instead of guessing which was important to me.
the core logic still lives in Excel. nothing changed there. there's just a separate service that reads and writes to the file based on my WhatsApp messages.
full disclosure I'm building this into a small tool (ExcelClaw) for myself and a few other people who are way too deep in spreadsheets. so this isn't a neutral post. but I genuinely want to know from people who live in Excel all day:
would you trust something that edits your Excel based on text messages if you can see every change and get the file back? what would you need to feel safe with it.. logging? approval steps? version backups?
and honestly if there's a way to do this natively with Power Automate or VBA that I'm overcomplicating I want to hear that too. I tried VBA before and broke things twice so I gave up but maybe I was doing it wrong
curious what you guys think. if mods feel this is too promo-y I'll take it down, just want honest feedbak from the people who actually use Excel for operations
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- I built a tool that lets you skip Excel formulas (would love your feedbacks)Hey everyone, If you work with Excel a lot, you probably spend way too much time figuring out formulas and structuring data before you can actually get insights. I’ve been building a web app called Neural Sheet to simplify that workflow. Instead of writing formulas manually, you can just upload your Excel file, describe what you want in plain language, and it generates the result for you. You can then download everything back as a normal Excel file with full control. It’s still early, but most core features are already there, and I’d really value honest feedback from people who actually use spreadsheets daily. You get 30 free edits to try it out. If you hit the limit and want more, just DM me and I’ll top you up. Would love to hear what works, what doesn’t, and what feels missing. submitted by /u/NeuralSheet [link] [comments]
- how did you improve your workplace's legacy vba macros?I recently transitioned to a non-clinical role in a public health care system. part of the on-boarding was a 12 page, 20 step tutorial on how to 'do the macros'. The workflow simplified is: - Get source data from EHR/BI - Open the excel online (microsoft 365) "Daily Review" workbook in the desktop ms excel. (hopes and prayers it doesn't crash) - copy data (columns of patient ID, demographics, medications... you get the idea) from EHR, paste into this Daily Review - run macro (click a button) which cleans, filters, applies conditional formatting i think - save - go back to excel online and resume editing there. The VBA code was created (not sure if it was written coz it has no documentation) by a colleague who is on extended mat leave. I can see a lot of 'modules'. Can't tell which is active. There are probably lots of historical decisions. The daily review file with its many many sheets is saved in multiple locations in case newcomers like me or others break it by accident. I am told we can't change anything like move a column closer to the beginning coz well we can't. I don't know VBA but could probably figure it out if I watch a tutorial on it. I am linux user and know basics of C, python and make good use of my claude code with the pro subscription but never really worked with spreadsheets. I am wondering if anyone was in a similar situation and how you managed it. Is moving to office scripts (typescript) a viable alternative? Any other life improving tips would be appreciate it. Or maybe I should just give up and focus the energy elsewhere? submitted by /u/Neat-Badger-5939 [link] [comments]
- How to deal with a bulky spreadsheet that is starting to hit the limits of Excel?Hello all, I have been venturing on quite the Excel journey the past year or so. I made a corporate spreadsheet that is approaching 500k formulas and that is starting to get serious speed issues at this point. It is 2026, so I conversed with ChatGPT several times regarding the speed issue, but realized I am way better off asking the experts here anyways. What is the problem So, my spreadsheet imports flat databases with specific information regarding objects that need further analysing. The imported flat databases run from say A tot CC or something, from which I probably draw about 12-15 datafields that are used for further analysis. It 'may' be more in the future. Afterwards, said data gets 'enriched' (manually) by things that aren't in the database, also because said data needs a human eye that cannot be automated. So far, so good. Right now, each object gets analysed from several different angles. As it stands, my spreadsheet runs from A until NA or something on the Formula Page. Many columns receive data from preceding columns, that are in the turn the result of many (slightly complex) logical IF or IFS tests, many of which are nested 3 or 4 deep. Often, they work in conjunction with X.LOOKUP to retrieve values, as the columns on the formula page are not equal. For example: A until BC on the Formula Page may analyze 150 objects, BD until DD may analyse 100 objects (from the same dataset, so narrower), and so forths. Thus a lot of X.LOOKUP is required, also because the first 'block' comes up with values that need to be found with X.LOOKUP. Also, values need to be retrieved from the flat database 'import' page with X.LOOKUP. Finally, X.LOOKUP is an insurance compared to FILTER, as I am not fully convinced that empty values in the flat database always contain a space (" "). To get to the point I use many IF, IFS, AND, and if need be, OR, formulas. Thinks: tens of thousands, probably in excess of 100k. These are compounded with X.LOOKUP, or X.LOOKUP gets used copiously without those. Here too, think tens of thousands. These formulas are - as much as possible - in array format, even though I find it controversial to do that as I consider how it can create a chain of updates throughout the spreadsheet. 'Dependencies' is the name of the game, with one object receiving many possible alterations / adjustments due to manual input data, for which the spreadsheet needs to provide. Right now, when I update a value, it may take up to 4 seconds to update the spreadsheet, which is already beyond the annoyance point for me. This leads me to these (hopefully) simple questions: Is it smart to use array formulas, knowing that each thing I change should only impact that one object line (for example, row 488) and none other? It is important to mention that object 1 does not influence object 488, or any other. Any manual data field only effects the object in the row it is in. In my mind, array formulas do not make sense in that regard, as it can result in a cascade of updates, but apparantly array formulas are 'way more efficient'. Is use of a VBA library the way to go to reduce lag and create more of an instant spreadsheet again? I am not able to code in VBA yet, but I am in the slow process of learning it regardless. Alternatively: should I use LET whenever a repeated lookup is needed in the same formula? Really looking for to your answers! submitted by /u/EvolvedRevolution [link] [comments]
- Am I playing it too safe with multiple helper columns instead of one complex formula?Hi everyone! I'm a teacher from PH. I started building an Excel system to automate the heavy paperwork we face esp during the EOSY (End of School Year). What began as a "lazy" way to handle my own tasks turned into a tool I shared with three coworkers. From there, I dove into books and YouTube, eventually building a system using basic VBA and complex formulas that my entire school now uses. I'm proud to say it turned weeks of work into just one hour... and since it's summer here, I'm revamping the whole thing to make it available for Mac users while still being limited to Excel 2019 and older (as most teachers don't have the latest ones). I'm proud of the progress but at the moment, I am feeling self-doubt. Just earlier, I decided to lean heavily into using helper columns that my main sheets can reference to. I have quite a few, but each one has a clear, single responsibility. This makes the logic easier for me to follow and debug later. Plus there's a lot to consider really and although I know I could compress a lot of this into fewer, more complex formulas (or even one large formula) but I find this approach much easier to maintain. It's a bit like organizing my own room... I prefer to set things up in a way that I understand so I always know where to look if something goes wrong. That said, I’ve started second-guessing myself while looking at how many helper columns I’m using. Am I playing it too safe (I mean this in a negative way) knowing there are better ways to do it? My question is: In a huge system like this, do you prefer breaking logic into multiple helper columns for clarity, or consolidating everything into fewer, more complex formulas? (I admit I might just be overthinking it (maybe a bit of imposter syndrome kicking in, comparing myself to how others will probably do the same work I'm doing), but I’d really appreciate hearing how others approach this.) submitted by /u/junaliiee [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#natural language processing for spreadsheets#generative AI for data analysis#cloud-based spreadsheet applications#financial modeling with spreadsheets#rows.com#big data management in spreadsheets#modern spreadsheet innovations#self-service analytics tools#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#AI-native spreadsheets#collaborative spreadsheet tools#AI-driven spreadsheet solutions#real-time data collaboration#automation in spreadsheet workflows#no-code spreadsheet solutions