1 min readfrom 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

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.

https://preview.redd.it/8g8ixybxh0pg1.png?width=1280&format=png&auto=webp&s=773323e7852f8938b4d6a982ad5994666a5d3ae6

https://preview.redd.it/n42zjwqzh0pg1.png?width=1122&format=png&auto=webp&s=29ca58bedb239714213b4a0fa2de6b755b7c1756

https://preview.redd.it/4lrytrw0i0pg1.png?width=629&format=png&auto=webp&s=ed12867c4517724efc559bcf83c0945893418944

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!

submitted by /u/ShahSavareKianee
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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