
Closed
Posted
Paid on delivery
We need an Excel VBA quotation system (offline) for a windows & doors company. The system must include: A protected Admin Pricing Sheet where only admin can control all prices (designs, materials, colors, glass, screens, key lock, installation rates, delivery rate). A Customer Database where users can add customers, but cannot edit or delete them without admin approval. Customers must be searchable and auto-filled into quotations. A Quotation system where: - Quotation number is automatic - Date is automatic - Expiry date is +15 days - User selects customer, adds salesperson name and remarks Each quotation must support multiple line items. Each line includes: Design, Material, Color, Glass, optional Screen, optional Key Lock, Width, Height, Quantity. The system must automatically calculate: Price per m² (based on selections) Line total (including quantity and key lock) Subtotal (all lines) Project-level calculations: Installation (optional, based on highest rate per material and total m²) Delivery (0 if ≤30 km, otherwise full km × rate) VAT 7% Final Total System must be protected: Users cannot change pricing or formulas Saved quotations cannot be edited without admin password Final quotation must be clean and ready for PDF export.
Project ID: 40376359
17 proposals
Remote project
Active 1 mo ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
17 freelancers are bidding on average ₹1,100 INR for this job

Drawing from my extensive experience as a Full-Stack Web Developer, specialising in Ecommerce & Enterprise Websites, I am confident in my ability to fulfill all of your project's requirements. I am proficient in PHP, a skill that will be hand for automating the tables and calculations ensuring clean code, and ultimately accurate results. In addition, my understanding of backend development will help me create a secure REST API, as requested by the must-have features. The protection functionality you desire is also within my purview as I can create a system where regular users cannot edit or delete customer information without admin approval. The system will also automatically generate quotation numbers and dates. Plus 15 expirations dates are also part of my offerings. I fully empathise with your need for complete reliability within the system; from pricing to formulas to saved quotation security - data integrity is paramount. It would be a pleasure to work on this project with you and insightfully merge my skills with your vision to produce an exceptional Excel VBA Quotation system for your windows & doors company.
₹1,050 INR in 2 days
8.8
8.8

Hi there, I like how you have outlined your project description with clear and detailed requirements for the Excel VBA quotation system. You need a secure, user-friendly offline solution tailored for a windows and doors company, with an admin-protected pricing sheet, controlled customer database, and a robust quotation system featuring automatic numbering, date handling, and multiple line item support. The system should perform complex calculations including price per square meter, line totals, subtotals, installation, delivery charges, VAT, and final totals, all while safeguarding formulas and pricing from unauthorized changes and enabling PDF-ready quotation outputs. With extensive experience developing customized Excel VBA applications, I have delivered similar comprehensive solutions focused on data integrity, ease of use, and maintainability. I will ensure your system restricts editing appropriately, handles all the outlined calculations accurately, and produces clean professional quotations formatted for export. I am confident in delivering a high-quality, secure, and efficient tool within 10 days that fully meets your needs. Please feel free to reach out so we can discuss any additional specifics or questions you may have. Looking forward to collaborating with you on this project.
₹1,050 INR in 10 days
6.1
6.1

Hi there, I see you’re looking for an Excel VBA quotation system for your windows and doors company. You need a secure admin pricing sheet, a customer database with search features, and an efficient quotation system that automatically handles all calculations. This is a great way to streamline your processes and ensure accuracy. With 4+ years of experience in Excel VBA and database management, I can create a user-friendly system tailored to your specific requirements. I'll ensure that pricing is protected and that only admins can make changes, while users can easily generate quotations with all necessary details. One question I have is, do you have specific designs or materials in mind that should be included in the admin pricing sheet? Best regards, Arslan Shahid
₹600 INR in 1 day
5.1
5.1

As a seasoned administrative professional, I'm well-versed in the kind of job you're proposing. My Excel skills paired with my proficiency in VBA and automation will help your company save valuable time while streamlining its quotation system. Using VBA, I'll create a secure Admin Pricing Sheet that only the admin can access. This not only protects your pricing data but also ensures that all changes are controlled and validated. Additionally, I'll design a customer database that allows users to add customers but not alter or remove entries without admin approval. The easy-to-use database will enable you to search and automatically fill customer details into quotations, improving overall efficiency. Coming to the quotations themselves, my automation capabilities guarantee automatic quotation numbers, dates, and expiry dates. In summary, hiring me would mean the implementation of an intelligently-designed quotation system that fulfills all your project requirements efficiently. And with my dedication to delivering quality results on time, you can count on having the system up and running in no time at all!
₹5,050 INR in 1 day
4.2
4.2

With over 6 years of experience and having delivered more than 850 projects successfully, including complex data systems, I'm confident that my skills align perfectly with your Excel VBA quotation project. As a Top 5% Full Stack Developer, I am well-versed in Microsoft Excel, proficient in VBA, and skilled at designing tailored solutions to meet specific business needs. My approach to this task would be to create a robust and user-friendly system that meets all your functional requirements while taking your company's security needs into account. My experience in CMS Development ensures that I can create a system that is administratively secure, allowing only authorized personnel to edit the pricing sheets and quotations, thus minimising any chance of errors or mishaps. Lastly, with a 100% satisfaction rate and an impressive rehire rate on Freelancer.com, I assure you not just professionalism but results. Partnering with me will enable you keep track of your pricing without causing errors to your pricing sheets and quotations, generate accurate quotations quickly, searchable customer database and automated calculations for line items entrusting you with a ready-to-export PDF document. Let's discuss the details so we can begin enhancing your business operations!
₹600 INR in 9 days
4.4
4.4

Hello, I'm very interested in 'Excel VBA 600 INR'. I've done very similar work and can bring that experience directly to your project. I value long-term client relationships and always go the extra mile to make sure you're happy with the outcome. Let's talk!
₹1,080 INR in 7 days
2.5
2.5

Hey , I just went through the project description, and I see you are looking for someone experienced in Excel VBA, Database Management, Visual Basic, Excel, Software Architecture, PHP, Data Entry, Data Processing, Automation and Data Protection. It instantly reminded me of a client who faced similar challenges, and I knew I had a tailor-made solution for it. Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: • Is there anything else you’d like to add to the project details? • What’s the top hurdle you’re facing with this project? • What is the timeline to get this done? Why Choose Me? 250+ Projects. 5 Years. Zero Misses. My reputation is built on a single metric: Flawless Execution. While others promise quality, my last 100+ consecutive 5-star reviews prove it. I don’t just finish the job; I set the standard. Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) The portfolio here is just the tip of the iceberg. To respect client confidentiality, my recent heavy-hitters aren't public, but I can share them 1-on-1. Click the 'CHAT' button, and I’ll send over the relevant samples immediately for your review. Regards, Abdul Haseeb Siddiqui.
₹600 INR in 2 days
3.4
3.4

Hello, I understand you need an Excel VBA quotation system for a windows & doors company with a protected Admin Pricing Sheet. The system must include automatic quotation numbers and expiry dates. ✨ Why choose me? ✔ Excel VBA for automation ✔ Customer Database with searchable customers ✔ Clean code + full documentation delivered ✅ View my portfolio: https://www.freelancer.com/u/masroorahmed56 Let's collaborate on this hourly project, masroorahmed56
₹600 INR in 1 day
0.0
0.0

Hi, I have read your description and I understand what you are expecting. I am a skilled freelancer with 4 years of experience in PHP, Software Architecture, Automation. See my profile for recent work. Looking forward to your reply. Warm regards, Syeda Tahreem
₹1,050 INR in 7 days
0.0
0.0

Hi, I've carefully reviewed your requirements for an offline Excel VBA quotation system tailored for your windows and doors company. With solid experience in Excel VBA, automation, and database handling, I understand the critical need to balance functional detail with secure data management. I will develop a protected admin pricing sheet where only authorized users can update pricing components, ensuring integrity. The customer database will support additions with restricted edit/delete options requiring admin approval, paired with efficient search and autofill for quotations. The system will generate quotations with automatic numbers and dates, support multi-line items detailing your specified attributes, perform precise calculations including installation, delivery, VAT, and finalize totals. Security measures will prevent unauthorized changes, and saved quotations will require admin authentication for edits. The output will be clean, formatted for quick PDF export. I estimate delivering a tested, robust solution in about 5 days, ready for your review and integration. What are your preferred workflows or Excel versions to ensure compatibility and ease of use? Thanks, Fabian
₹1,165 INR in 1 day
0.0
0.0

Hi, A quotation system for windows & doors needs proper unit pricing logic — price per m² varies by product type, and installation/delivery fees often depend on quantity thresholds. I'll structure the pricing sheet so you can update rates without touching any code. What I'll build: • Admin-protected pricing sheet (password-locked, editable only by admin) • Customer database with search + autofill on the quote form • Multi-line-item quotation: select product → auto-pulls price/m², enter dimensions → calculates total per line + installation + delivery + VAT 7% • PDF-ready print layout for professional quotes • Password protection on all sensitive sheets I've built similar Excel VBA systems for inventory and invoicing. Can deliver within 2-3 days. One question: do you need the customer database to store quote history, or just contact info for autofill? Best regards, Eric
₹900 INR in 3 days
0.0
0.0

Yes! You are on the right bid. I have read all project details and descriptions regarding Excel VBA 600 INR I will save your time by letting my work speak for you. If I am lucky enough to get your attention, please feel free to reach me so we can spend 10-15 minutes and discuss everything ;) You can check my portfolio and reviews regarding your Project: https://www.freelancer.pk/u/Q@d33rM3hdi Best regards! Qadeer Mehdi!
₹600 INR in 4 days
0.0
0.0

Hi, I’ll keep this short. I noticed you need a fully structured Excel VBA quotation system with strict controls and automation, and I understand how important accuracy and protection are for this kind of workflow. I can build a clean system that includes: Protected admin pricing control Searchable customer database with restricted edits Automated quotation flow (number, dates, calculations) Multi-line item support with accurate pricing logic Locked formulas + admin-only editing access Final output ready for PDF export (client-facing format) My focus is to make it simple to use for your team, but fully controlled on the backend. I can start immediately and share a working structure early for feedback. Thanks, Annisa P.S. Do you already have a preferred quotation layout/style, or should I propose a clean professional format?
₹1,050 INR in 5 days
0.0
0.0

pattaya, Thailand
Payment method verified
Member since Jan 21, 2021
$10-30 USD
$10-30 USD
$30-250 USD
$10-30 USD
$10-30 USD
$250-750 USD
$1500-3000 USD
$10-30 USD
$15-25 USD / hour
₹100-400 INR / hour
$10-30 USD
$10-30 USD
$10-30 USD
$250-750 USD
₹1250-2500 INR / hour
₹750-1250 INR / hour
₹100-400 INR / hour
$8-15 USD / hour
€250-750 EUR
₹750-1250 INR / hour
₹750-1250 INR / hour
₹600-1500 INR
₹1500-12500 INR
$15-25 USD / hour
$30-250 USD