I'm trying to automate the quoting system that we use in excel. It is now hand typed and I would love to have macros do the backend work.
Basically, I have one workbook with a bunch of worksheets containing tables with different asset pricing based on discount price (that is determined by the amount of licenses they have registered). Each discount rate (12.5%,15%,17.5%,20%, 25%, 30%, 40%) has its own worksheet with the pricing listed based on 1-30 assets. The pricing in each worksheet includes 4 columns that are License Fee, Maintenance Fee, Integration & Commissioning, Travel.
To explain in simple terms of what I need the macro to do:
- User selects the discount percentage for the company manually from a list then moves down to the quote chart, and selects how many assets you are quoting for manually
- based on the discount rate specified, and the number of assets selected for that row, go to the appropriate worksheet (based on the discount), and then take the pricing from the proper asset number row and produce this data in the "Quote" worksheet
I've tried playing around with If statements and what not, however...this one is out of my league
Bookmarks