
Closed
Posted
Paid on delivery
*Excel Automation – Linen Ordering Workbook I have an existing Excel workbook that I have already started creating. It is mostly built but needs tweaking, improving and automating by an experienced Excel developer. The workbook is used to prepare linen orders for approximately 100 holiday accommodation properties. Requirements * Use my existing Property Configurations sheet as the master database. * Office staff should only enter: * Delivery Date * Property * Cleaner * Bed Configuration * Notes * Everything else should populate automatically. Automation Required * Dynamic drop-downs for Property and Bed Configuration. * Automatically calculate linen quantities based on the selected bed configuration: * King Bed = 2 King Sheets + 2 Pillowcases * Queen Bed = 2 Queen Sheets + 2 Pillowcases * Single Bed = 2 Single Sheets + 1 Pillowcase * Bunk = 2 Single Sheets + 1 Pillowcase * Bath Mats = Number of Bathrooms. * Hand Towels = Number of Bathrooms. * Tea Towels = Always 3. * Automatically populate the Linen Order sheet and Print Docket. * Ensure formulas are robust, compatible with Microsoft 365, and don't break when editing is enabled. The workbook is already well underway, so this is not a project from scratch. I need someone to refine, automate and improve the existing workbook, making it reliable, user-friendly and easy to maintain as new properties are added.
Project ID: 40541081
38 proposals
Remote project
Active 19 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
38 freelancers are bidding on average $146 AUD for this job

As an Excel enthusiast, I am driven to provide my clients with tailored automation solutions that optimize their workflow, save time, and enhance usability. With my strong background in data analysis and management, I have the skills to build upon your existing Linen Ordering Workbook and transform it into a comprehensive automated system tailored to your unique requirements. I can create dynamic drop-downs for Property and Bed Configuration based on your Property Configurations sheet while ensuring smooth formula functionality. For seamless linen calculations, I will employ conditional logic that determines quantities based on bed configurations. Bath mats, hand towels, and tea towels can be automatically populated depending on the number of bathrooms or a fixed number as you desire. To complete the solution, the Linen Order sheet and Print Docket will populate automatically from the information entered by your office staff - ensuring an effortless linen ordering process. In addition to delivering efficient automation, I make client satisfaction a priority. My availability for demos and consultancy offers you a chance to evaluate my progress before committing further. I ensure compatibility of my work with different Excel versions like Microsoft 365 and offer continuous support even after our contract ends. Allow me to perfect your Linen Ordering Workbook so you can manage your growing property portfolio with ease! Let's discuss your project further!
$40 AUD in 1 day
7.6
7.6

Hello, I can refine and automate your existing Excel workbook using robust Microsoft 365-compatible formulas, dynamic drop-downs, and automation based on your Property Configurations sheet. I'll ensure linen quantities are calculated automatically, the Linen Order and Print Docket populate seamlessly, and the workbook remains easy to maintain as new properties are added. My focus will be on reliability, usability, and preserving your existing workflow. I'm available to start immediately. Best regards, **Muhammad Usman**
$80 AUD in 1 day
6.6
6.6

Hello, I am an Excel automation specialist who will refine and automate your existing linen ordering workbook. I will use your Property Configurations sheet as the master database, set up dynamic drop‑downs for Property and Bed Configuration, and create formulas that auto‑calculate linen quantities per bed type (King/Queen/Single/Bunk, bath mats, hand towels, tea towels) and populate the Linen Order sheet and Print Docket automatically. I will ensure all formulas are robust, compatible with Microsoft 365, and maintainable as new properties are added. Please share your current workbook. I can start immediately. Thank you. Ragards, Zafar
$120 AUD in 1 day
6.2
6.2

Hi there, I understand you already have the foundation of the linen ordering workbook in place and need an experienced Excel developer to refine, automate, and strengthen the existing solution. I am confident I can help transform the workbook into a streamlined, reliable system where staff only enter the required details while all calculations, quantities, and order documents populate automatically. My approach will be to review the current workbook structure, optimize the Property Configurations sheet as the master database, and enhance the existing formulas, validation rules, and automation. I will implement dynamic drop-downs for Property and Bed Configuration, automate linen quantity calculations based on your business rules, and ensure the Linen Order and Print Docket sheets populate accurately without manual intervention. The focus will be on simplicity, reliability, and ease of maintenance as properties and configurations change over time. The deliverable will include a fully optimized Microsoft 365-compatible workbook with dynamic data validation, automated linen calculations, robust formulas, improved usability, automated order generation, testing, and a concise handover guide. Could you share the current workbook so I can review the structure and identify the most efficient improvements before implementation? I’m ready to start immediately. Warm Regards, Aneesa.
$100 AUD in 1 day
6.3
6.3

SolutionzHere can refine and automate your existing linen ordering workbook, using your Property Configurations sheet as the master source and keeping the staff input as simple as possible. The automation you want is very doable in Microsoft 365 with dynamic dropdowns, formula-driven quantities, and print-ready order/docket sheets. For this scope, a fair quote is AUD 280–450, with 1–3 days depending on how cleanly the current workbook is structured. Since the workbook is already well underway, the main effort is making the formulas robust and the flow reliable rather than building from scratch. One quick question: is the workbook currently using tables and named ranges, or are the sheets still mostly cell-based formulas?
$450 AUD in 2 days
5.4
5.4

As an Excel specialist with a strong track record in enhancing and automating workbooks, I am confident that I am the best fit for your project. Building on your solid foundation, I will refine and expand upon your existing Property Configurations sheet to maximize its functionality in managing linen orders. What sets me apart is my dedication to robust formulas. Your workbook must be compatible with multiple Microsoft versions while maintaining accuracy in calculations without any compatibility conflicts. I assure you of delivering a workbook that remains error-free and doesn't break when editing is enabled. Whether it is formatting, data entry, or creating comprehensive charts and reports - which are crucial to decision-making - you can rely on my commitment to quality work. Closely aligning with your requirements, my proficiencies include not just being proficient in Excel but also having strong problem-solving capabilities & advanced knowledge in data handling. Adding convenience and simplicity while maintaining reliability for end-users has always been my priority. You can trust me to give your workbook the fine-tuning it needs to become user-friendly and easy to maintain as new properties come aboard. Let's make this project a success together!
$100 AUD in 1 day
5.2
5.2

Hello, I have strong experience with Excel automation, formulas, dynamic drop-downs, and creating reliable, user-friendly workbooks. I can refine your existing linen ordering workbook, automate the calculations and population of sheets, and ensure it remains easy to maintain as new properties are added. I can start right away and deliver a robust Microsoft 365-compatible solution. I am ready to start working on your task right now and can begin immediately. Feel free to message me to discuss the workbook further. Kind Regards, -Habib
$80 AUD in 2 days
4.9
4.9

Hello, I’d be happy to help refine and automate your existing linen ordering workbook. I have extensive experience developing advanced Excel automation solutions, including dynamic forms, data validation, XLOOKUP/INDEX-MATCH, dynamic drop-downs, conditional logic, and automated reporting. I’ve completed many similar projects involving inventory, scheduling, invoicing, and order management. I can help with: * Refining your existing workbook without rebuilding it from scratch * Creating dynamic Property and Bed Configuration drop-downs * Automatically calculating linen quantities based on bed types and bathrooms * Populating the Linen Order sheet and Print Docket automatically * Building robust Microsoft 365-compatible formulas * Making the workbook easy to maintain as new properties are added * Improving usability, reliability, and overall performance My goal is to deliver a clean, user-friendly workbook that minimizes manual entry while ensuring accurate, automated linen orders. I can start immediately after reviewing your current workbook and discussing any final workflow requirements. Best regards.
$150 AUD in 4 days
4.9
4.9

Hi, I've reviewed your project and understand that you need to refine and automate your existing Excel workbook rather than build one from scratch. I have experience creating automated Excel solutions using advanced formulas, dynamic drop-downs, data validation, and automation to simplify business processes. I can enhance your workbook by making it reliable, user-friendly, and easy to maintain while ensuring compatibility with Microsoft 365. A couple of quick questions: Could you please share the current workbook for review? Do you also want to automate the print docket layout, or is it already designed? I'm available to start immediately and look forward to discussing your requirements. Best regards, Nidhi
$140 AUD in 7 days
5.2
5.2

With over 10+ years of experience working with Excel, I believe I can greatly enhance and automate your existing linen ordering workbook. Being proficient in Microsoft Office applications including Excel, I can optimize your workbook to provide user-friendly and robust formulaincluding dynamic drop-downs and automated calculations for bed configurations, bath mats, hand towels, and tea towels while ensuring the compatibility of the formulas on Microsoft 365. What sets me apart is my commitment to understanding and meeting your exact needs. As a proven professional with a strong track record of delivering projects on time, I understand the value of open and consistent communication. Therefore, I assure you that I'll be available 24x7 to address any queries or make adjustments to the project whenever required. Best Regards Pinky
$54 AUD in 1 day
4.7
4.7

Greetings, I see that you’re looking to enhance your existing Excel workbook for linen ordering, making it more automated and user-friendly for your staff. My approach would involve refining your current setup to ensure that office staff can easily input the essential details like delivery date, property, cleaner, bed configuration, and notes, while everything else populates automatically. I’d create dynamic drop-down menus for properties and bed configurations, ensuring that linen quantities are calculated based on the selected bed types. By automating the order sheet and print docket, I can help streamline your processes, making it easier to manage orders for your 100 holiday accommodations. With my experience in Excel and Microsoft 365, I’ll ensure the formulas are solid and won’t break during edits, making your workbook reliable and easy to maintain. Best regards, Saba Ehsan
$100 AUD in 2 days
4.2
4.2

Hi, I’m interested in helping improve your existing Excel linen ordering workbook. My background is in operations support, reporting, and Excel-based data management, with 8+ years of experience creating and maintaining structured spreadsheets for daily business processes. I have experience improving Excel workflows by organizing data, creating formulas, improving accuracy, and making reports easier for teams to use. I can help with: - Reviewing and improving your existing workbook structure - Setting up cleaner data validation and user input flow - Improving formulas for automatic calculations - Organizing sheets for easier daily use - Checking accuracy and maintainability My focus is creating a practical workbook that helps staff work faster while keeping the data accurate and easy to maintain. I would be happy to review your current file and suggest improvements. Kind regards, Andri
$100 AUD in 1 day
3.1
3.1

Hello, I have extensive experience automating Excel workbooks using advanced formulas, dynamic drop-downs, data validation, and Microsoft 365 features. I can refine your existing linen ordering workbook, automate calculations, populate order sheets and print dockets, and ensure it remains reliable, scalable, and easy to maintain as new properties are added. Best regards, Moniruzzaman
$49.99 AUD in 1 day
2.8
2.8

Hello, Dynamic drop‑downs for Property and Bed Configuration – you need a reliable way for staff to select properties without errors. I'll set up Data Validation linked to the Property Configurations sheet, using named ranges and XLOOKUP so the drop‑downs stay current and the linen‑quantity formulas stay fast even as new properties are added. If a property name changes, the named range updates automatically, preventing broken references in the order sheet. Which column in your Property Configurations sheet holds the number of bathrooms for each property? Looking forward to working with you. Artur Giżycki
$150 AUD in 3 days
2.9
2.9

Hi, With 5+ years of freelancing experience and 500+ completed projects, I can help refine and automate your existing linen ordering workbook. I can work with your current Property Configurations sheet as the master database and set up the workbook so staff only need to enter the delivery date, property, cleaner, bed configuration, and notes. The linen quantities, order sheet, and print docket can then populate automatically based on your rules. I can add dynamic drop-downs, Microsoft 365-compatible formulas, automated linen calculations, and a clean structure that stays reliable when editing is enabled. I’ll also check the current workbook setup, fix any weak formulas, improve usability, and make sure the final file is easy for office staff to use without confusion. Since the workbook is already started, I’ll focus on refining, improving, and automating it rather than rebuilding from scratch. I’m available to start right away. Best regards, Mahnoor
$100 AUD in 1 day
2.6
2.6

I see that the main structure is already completed in the worksheet, which is a great starting point. I can help refine it into a cleaner, faster, and more reliable ordering system with better automation, error reduction. I have some suggestions like Adding stronger automation for calculations, order summaries, and repetitive tasks. Preparing it so future updates or additions can be done smoothly without breaking existing logic etc I have strong experience working with structured Excel workflows, automation using macros, and process optimization, and I can build on what you already have instead of recreating it from scratch
$140 AUD in 7 days
1.3
1.3

Hello, Your project caught my eye because it involves enhancing and automating an existing Excel workbook critical for managing linen orders across multiple properties, and I am eager to help you streamline this process efficiently. I will ensure the workbook is robust, user-friendly, and fully automated to minimize manual input and errors. My approach includes: - Refining your current Property Configurations sheet as the master database to ensure seamless data integrity and scalability. - Creating dynamic dependent drop-down lists for Property and Bed Configuration to simplify user input and reduce errors. - Developing automated calculations for linen quantities based on bed types and bathroom counts, including fixed items like tea towels, using Excel formulas and possibly VBA for reliability. - Automating the population of the Linen Order sheet and Print Docket with real-time updates, ensuring compatibility with Microsoft 365 and maintaining formula stability during edits. To tailor the solution precisely: - Is the existing workbook shared via OneDrive or locally stored for multi-user access? - Do you prefer formula-based automation only, or are you open to VBA macros for advanced functionality? I look forward to discussing your workbook’s current structure and delivering a polished, maintainable solution that saves your team time and effort. Please feel free to reach out so we can get started!
$50 AUD in 3 days
0.0
0.0

With over a decade of experience as a Full-Stack Developer, I have gained profound skills and knowledge in numerous areas, including but not limited to WordPress, Shopify, WooCommerce, full-stack web development, AI integrations, automation workflows – all of which are vital for successfully completing your Excel automation project. Understanding the demands of a growing business, I aim not merely to accomplish the given task but also develop an efficient platform that is user-friendly and easily maintainable with the inclusion of new properties. My solid background in AI-powered workflows and automation systems will surely allow me to refine and improve your existing Linen Ordering Workbook with robust formulas compatible across multiple Microsoft 365 platforms. Moreover, my expertise encompasses developing fast-loading websites that focus on optimal user experience. These skills can be perfectly employed in automating dynamic drop-downs for Property and Bed Configuration - ensuring convenience for your office staff. As a reliable freelancers delivering projects within agreed timelines is sacrosanct to me. In summary, you shouldn't overlook my specialization in developing scalable eCommerce systems, maintaining clean code, focusing on mobile-first design and prioritizing business results for your Excel task. Rest assured, I'm proficient enough to deliver quality in good time! Let's discuss further on how I can efficiently contribute to your project needs.
$100 AUD in 5 days
0.0
0.0

A half-built workbook is trickier than starting fresh — existing formula structures and named ranges can conflict with new automation, especially once dynamic drop-downs and auto-population logic are layered on top. I'll audit your current setup before touching anything, so nothing breaks and no existing work gets lost. Here's what I'll deliver: Dynamic drop-downs for Property and Bed Configuration, driven directly from your Property Configurations sheet Full auto-calculation of linen quantities based on bed type, plus bath mats, hand towels, and tea towels Auto-population of both the Linen Order sheet and Print Docket from a single data entry point Robust, M365-compatible formulas that hold up when editing is enabled Office staff will only need to fill in the five fields you specified — everything else populates automatically. I've built cascading and dependent drop-down menus extensively across inventory, ordering, and property management workbooks, so I know exactly where these systems tend to break and how to build them to avoid that. Adding a new property to your master sheet will be all it takes to keep the workbook current as you scale. Let's discuss your project now!
$61 AUD in 3 days
0.0
0.0

The risk in this workbook is the property data becoming the source of quiet mistakes as new homes get added. I would treat this as a reliability pass on the existing file, with one clean property master table driving the dropdowns, bed setup, towel and bath mat counts, tea towel defaults, and the Linen Order / Print Docket outputs. I'd keep it in Microsoft 365 Excel using proper tables, lookups and protected input areas, so staff only touch the booking fields they are meant to touch. The calculations can then pull from structured property data instead of copied formulas or manually edited ranges, which is what usually makes these workbooks fragile after a few months of use. I can do this as one deliverable: refined workbook, property-driven inputs, linen quantity logic, populated Linen Order sheet, print-ready docket, and a quick handover note on adding new properties. Bid is 395 AUD over 2 days as a single milestone. This is an indicative estimate from the brief; I'll give you a firm quote once the scope is locked and I've seen the workbook. Quick check before I start: are the current property bed and bathroom details already stored somewhere in the workbook, or will they need tidying into a master property table first?
$395 AUD in 2 days
0.0
0.0

Sydney, Australia
Member since Jun 26, 2026
₹12500-37500 INR
₹600-1500 INR
$30-250 USD
$2-8 USD / hour
$250-750 USD
€8-30 EUR
£20-250 GBP
$10-30 USD
$30-250 USD
$250-750 USD
$30-250 USD
£250-750 GBP
$15-25 USD / hour
$250-750 USD
₹12500-37500 INR
$15-25 AUD / hour
$250-750 USD
₹1500-12500 INR
₹400-750 INR / hour
$250-750 USD