•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I built an Excel VBA tool that combines multiple supplier catalogs and generates quotations instantly – looking for feedback
Our take
I developed an Excel VBA tool designed to streamline the quotation process by combining multiple supplier catalogs into one accessible platform. This tool addresses the challenge of navigating different formats, product lists, and pricing structures from various suppliers. By allowing users to quickly search for items, add them to a quotation, and generate professional quotes automatically, it significantly enhances efficiency for small businesses already using Excel. I welcome feedback from Excel users on the workflow, desired features, and potential improvements. Thank you for your insights!
I often deal with multiple supplier Excel sheets when preparing quotations.
Each supplier has a different format, different product lists, and different pricing structures. Preparing a quotation meant constantly switching between spreadsheets.
So I built a small Excel VBA tool to solve this.
The idea is simple:
• Combine multiple supplier catalogs in one place
• Search items quickly
• Add them to a quotation
• Generate a professional quote automatically
Here are some screenshots of the workflow.
The goal was to make quotation creation faster for small businesses that already work in Excel.
I would really appreciate feedback from people who regularly use Excel:
• Does this workflow make sense?
• What features would you expect in a tool like this?
• What would you improve?
Thanks!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- I wired my Excel inventory sheet to WhatsApp so it texts me when stock is low. is this dumb?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 submitted by /u/hiclemi [link] [comments]
- 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]
- Built a platform that generates Excel sheets when connected via APIHi. I built a platform where Excel sheets are custom made when connected to a API platform. Stripe, PayPal, Citibank, QuickBooks, etc. I don't know how good it will work but I wanted to post here to see if anyone wanted to give it a spin and provide some feedback. Because I don't have enough data to feed it, its hard to tell if it is doable. the site is "excelbolt.web.app". The premise is to run custom templates and takes out the work of manually manipulating raw data, formatting it, editing it, as well as manually manipulating pivot tables & conditioning functions. A lot of people aren't good at excel so i thought I make it a bit easier for them. Any feedback is helpful. I'm the only person that put it together and plan on rolling out a iOS, Desktop management and Android edition after everything is working. Its not really self-promo btw. its still in test mode, ive completed a lot of the work btw but im just one person. submitted by /u/Solidartent [link] [comments]
- I’m researching how people automate repetitive Excel/CSV workflows in day-to-day work.I’m building a desktop tool to set up these processes visually, but before going further I want to understand what actually hurts today. I’m not selling anything in this post, just trying to learn from real-world cases. If you work with this kind of thing, I’d really appreciate your input: - What was the last annoying Excel/CSV workflow you automated? - How often does it run? - What was the most frustrating part: combining files, cleaning data, standardizing columns, deduplicating, exporting, etc.? - Are you the only one who runs it, or do other people need to run it too? - What do you use today: Power Query, VBA, Python, Power BI, something else? Thanks! submitted by /u/Remote-Ad-6629 [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#natural language processing for spreadsheets#financial modeling with spreadsheets#workflow automation#generative AI for data analysis#rows.com#big data management in spreadsheets#AI-native spreadsheets#google sheets#predictive analytics in spreadsheets#cloud-native spreadsheets#Excel#VBA#quotations#supplier catalogs#quotation creation#product lists#pricing structures