
Completed
Posted
Paid on delivery
I'm looking for an expert to build an Excel macro that will help automate some tasks. The primary goal of this macro is to help take a picklist and build a tool that will scan barcodes and tell us which item the box belongs in. It needs to have a few vlookup functions, but overall its not too complicated. Video attached to show what I need. [login to view URL]
Project ID: 39691801
41 proposals
Remote project
Active 11 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi Joshua You explain it pretty good so i dont have any question. I will build a macro in sheet 1 as you have told in video that will select the temp excel file and then do the processing to bring unique orders in [login to view URL] sheet 3 it will layout all orders by boxes. would you like to discuss project design with me?
$100 USD in 1 day
7.6
7.6
41 freelancers are bidding on average $134 USD for this job

As a seasoned data analyst, I bring decades of experience in Excel and macro automation to the table. I have extensive hands-on experience in handling similar projects with a specialty in data analysis, entry, and mining that aligns perfectly with the needs of your task. Handcoding excel macros, especially those leveraging Vlookup functions, is my forte and I'm confident in my abilities to deliver on building the tool that will automate your picklist scanning. Moreover, I am well-versed in other verticals that add value to this project, such as data manipulation and using Excel for creating sleek and efficient forms like you require. As you can see from my portfolio and the services I offer, dealing with complex datasets and implementing solutions through macros is part of my daily operations. My in-depth understanding of data management combined with my proficiency of delivering accurately swiftly makes me the ideal candidate for the job. In addition to my skills and experience, what sets me apart is my dedication to delivering high-quality, reliable work to my clients. I approach every project as if it were my own, guaranteeing a comprehensive solution that meets your needs and timeline as specified. Pairing this commitment with my technical brilliance makes me an invaluable asset for overcoming your automation challenges. Choose me for seamless macro integration = Endless gains for your business!
$199 USD in 1 day
7.5
7.5

Hi I'll help you by creating an excel spreadsheet that will automate your work. With over 10 years of experience I am here to help make your excel dreams come true. All sort of work can be done. My Services: Excel Automation, to run your daily tasks on auto pilot. Create Customized Automated Dashboard in excel or google sheets. Excel VBA Google Sheets automation and scripting Mixing Excel with Adruino. Linking VBA to Autocad. Excel formulas. Excel to pdf conversions Email automation from excel , generate automatic emails Designing any sort of templates in Microsoft Excel data analysis. Visual Basic for Applications Forms, for user interface designing and dashboards Data Entry with automated process Merging tables. charts, pivot tables, userforms, cell functions, formulas, mail merge, template design
$180 USD in 3 days
6.8
6.8

About me ADVANCE EXCEL , more 7 years experience I am a CERTIFIED Excel VBA Programming , CERTIFIED Business Analytics and i have a MASTER of BUSINESS ADMINISTRATION
$55 USD in 2 days
6.3
6.3

Hello Joshua D., I reviewed your project, "Excel Macro Automation Specialist Needed," and it’s an excellent match for my expertise. With 500+ completed projects and a 4.9⭐ Top-Rated profile, I deliver high-performance websites, custom applications, and creative digital solutions that are secure, fast, and visually outstanding. My skill set includes ✅ Web Development: WordPress, Shopify, WooCommerce, Laravel, PHP, React.js, Vue.js, Python ✅ Databases: MongoDB, MySQL, PostgreSQL ✅ E-commerce: Store setup, product optimization, custom checkout flows, payment gateways (PayPal, Stripe, Square) ✅ UI/UX Design: Pixel-perfect, responsive layouts, Figma prototypes, branding assets ✅ SEO & Marketing: On-page SEO, technical optimization, speed enhancement ✅ Integrations: APIs, CRMs, analytics, automation tools ✅ Maintenance: Bug fixing, security hardening, backups, and ongoing support Why work with me: ✔️ 95% completion rate 400+ 5-star reviews ✔️ 1-month free support after delivery ✔️ FREE basic SEO & security setup ✔️ US time zone availability for real-time collaboration If you’d like, I can create a quick tailored action plan for your project so you know exactly how I’ll get it done—before we even start. Let’s make your project a success. Kausar Parveen Multimedia Graphic Designer & Full-Stack Developer Your Partner in Digital Excellence
$180 USD in 3 days
6.3
6.3

Hello Joshua D., I have read the project details and understood the overall requirement. With 5 years of experience in Visual Basic, Excel, Software Architecture, Visual Basic for Apps, Excel Macros, Data Analysis, Automation, and Data Management, I am confident in delivering a high-quality Excel macro automation solution for your project. I have already successfully completed multiple projects in this domain. You can view my portfolio here: https://www.freelancer.com/u/mannanmaan1425 Please ping me back so we can discuss the project further in the chat. Best regards, Abdul
$30 USD in 1 day
6.2
6.2

Hi there, I'm Ravinder, a seasoned finance professional with an extensive background in accounting, financial analysis and - most importantly for your project - proficient in Excel macros and automation. I have been leveraging my skills to streamline business operations and data processing for over 15 years, completing over 180 successful projects along the way. With your Excel macro automation task, I can create the perfect tool that matches your needs to effectively scan barcodes, run VLOOKUP functions, and identify item allocation. As a freelancer, I understand the significance of accuracy and efficiency in every project. Your video clearly outlines what you need, and I am confident that my deep understanding of inventory management coupled with my extensive experience in Excel VBA macros development will make me the ideal candidate for this task. For your project success, you need a professional who is not only proficient with the necessary tools, but also readily available when needed. My flexible schedule ensures I can put in 13 hours per day on your project if necessary. Let's turn your picklist into a barcode-scanning powerhouse!
$50 USD in 2 days
6.2
6.2

Hello, I have over 7 years of experience in Excel, Excel Macros, and Visual Basic for Apps. I have carefully reviewed the project requirements and the attached video demonstrating the task. To address your needs, I propose creating a custom Excel macro that will utilize VLOOKUP functions to scan barcodes and match them with the corresponding items in the picklist. The macro will automate the process, making it efficient and error-free. I will ensure that the macro is user-friendly and meets your specific requirements. I am confident in my ability to deliver a high-quality solution that streamlines the task as per your description. I would be happy to discuss the project further and answer any questions you may have. Please feel free to connect with me via chat for a detailed discussion. Best regards.
$100 USD in 2 days
5.6
5.6

Hi Joshua, Thank you for considering my proposal. I have carefully reviewed the requirements for your Excel macro automation project. With over 8 years of real-world experience and freelance work in Excel, I am confident in my ability to assist you effectively. I am interested in discussing your project further to understand your specific needs and how I can help you achieve your goals. I would appreciate the opportunity to connect with you in chat to delve deeper into the details of the project. Looking forward to the possibility of working together. Regards.
$30 USD in 1 day
5.7
5.7

Dear Client, I will make an excel macro for you . We can discuss more detail in chat. Looking forward to your response.
$100 USD in 3 days
3.8
3.8

With 8 years of experience in the field, I believe I am the best fit to complete this project. I have the relevant skills and expertise to deliver the Excel macro you require to automate tasks efficiently. How I will be completing this project: - I will start by thoroughly understanding the requirements and functionalities needed for the Excel macro. - Next, I will create a detailed project roadmap outlining the different stages of development and implementation. - I will then begin developing the macro, ensuring it includes the necessary vlookup functions and meets all specified requirements. - Rigorous testing will be conducted to ensure the macro functions smoothly and accurately. - Finally, I will provide documentation and support for using the macro effectively. What tech stack I will be following: - Microsoft Excel for macro development - VBA (Visual Basic for Applications) for scripting I have previously worked on similar solutions where I have successfully automated tasks using Excel macros. My experience in this area will ensure timely and high-quality delivery of the project. I am confident that my skills and experience make me the ideal candidate for this project. I look forward to the opportunity to work with you.
$30 USD in 7 days
4.2
4.2

Hello, As a seasoned Senior Software Developer, I am well-equipped to handle the automation needs of your Excel macros project. Drawing from my 20 years of experience, my expertise spans numerous industries and projects including high-stakes ones in finance, healthcare, energy, retail, banking, and industrial automation where attention to detail is paramount. Backed by a strong technical background that includes a diverse range of programming languages and platforms such as Python and Java, I am confident in managing the vlookup functions and any other complexities your project may entail. Moreover, my solid grasp on data management dovetails seamlessly with the needs of this project. I've worked extensively on handling large datasets and designing software solutions that streamline tasks like barcodes scanning. In fact, automation is at the core of my skill set; I have a lengthy track record of successfully implementing AI-driven automated processes to databases for businesses just like yours. Lastly, communication and partnership are the cornerstones of my client approach. I won't just build you an efficient macro today - instead, I'll embark on a long-term partnership with you. After all, future-proofing systems is one of my key competencies. With me on this project, not only will you get this task automated quickly but you'll also be working alongside someone who can adapt it to any contingencies or changes that may arise. Toge Thanks! Hakan
$180 USD in 1 day
2.9
2.9

Hello, I'm an experienced data analyst with a demonstrated expertise in Excel and VBA automation. I am confident I can deliver the solution you need for your Excel task automation project. With advanced proficiency in developing macros specifically tailored to simplify complex data processes, I can leverage my skills to construct a tool for your unique picklist scanning requirement using vlookup functions and diverse automation techniques. Throughout my career, I have successfully provided data-driven solutions across various industries, ensuring smarter system operations, comprehensive dashboards, and robust reporting structures. More pertinently, my proficiency in Smartsheet and Power BI further bolsters my abilities to effectively analyze your data and present the outcomes in dynamic visualizations. By selecting me for this task, you are not just hiring an Excel specialist with versatile data handling skills but also someone who can bridge the gap between raw data and actionable strategies. My goal is always to streamline data processes to ensure optimal efficiency that ultimately saves not only time but also valuable resources. I hope to hear from you. Best regards, Paul A.
$140 USD in 7 days
3.1
3.1

With over THEME_FLEXRWORDS000 successful projects, I'm confident in my ability to provide you with an amazing Excel macro automation tool for your picklist task. My proficiency with Excel VBA will enable me to deliver a fast and reliable solution while incorporating the functions you need, including the vlookup functions. I have hands-on experience designing intelligent automated solutions that significantly improve workflows and boost overall efficiency. Moreover, I leverage my web scraping and data extraction skills to ensure our automation solution is dynamic and adaptable. This means that as your business evolves, so can the tool we build today. Being a believer in the power of data, I'm equally versed in handling and transforming complex data sets into simplified and structured formats. By entrusting me with this project, you'll not only get a quality Excel macro automation tool but also someone who genuinely understands your needs and can exceed your expectations. Let's team up and transform your tedious manual tasks into effortless, time-saving operations!
$60 USD in 1 day
2.8
2.8

Greetings, I see you're looking for someone to create an Excel macro that automates the process of matching barcodes with a picklist. This is a great way to streamline your workflow and ensure items are sorted correctly. From what you described, I would develop a macro that incorporates VLOOKUP functions to easily identify which box each item belongs to. With my experience in Excel and Visual Basic for Apps, I've successfully built similar tools that enhance data management and automate repetitive tasks. I pay close attention to detail, ensuring that the final product is user-friendly and efficient, just like you need. I’m excited about the opportunity to help you with this project and make your tasks easier. Best regards, Mehran Riaz
$200 USD in 4 days
2.5
2.5

Joshua, for the Excel Macro Automation Specialist project, would it be fine if I analyze the video attached to understand the specific requirements and functionalities needed for the Excel macro? Once reviewed, I can sketch out a clear and efficient approach to create the automation tool you are looking for. So I believe that with a well-designed Excel macro, the automation tool can streamline the process of scanning barcodes and matching them to the correct items efficiently, ultimately saving time and reducing errors in the task. By the way, do you have a preferred timeline for the completion of this project, or are there any specific Excel functions or features that you would like to prioritize in the automation tool? Your insights will help in tailoring the solution to best suit your needs.
$200 USD in 2 days
2.0
2.0

Hello Joshua, I am Volodymyr, a freelancer with 4 years of experience in Excel, Software Architecture, Data Analysis, Automation, and Data Management. I have carefully read your project description regarding the need for an Excel macro automation specialist to create a tool that can scan barcodes and match them with the corresponding items in a picklist. To achieve this, I propose developing a custom Excel macro that integrates VLOOKUP functions to efficiently scan barcodes and provide accurate item identification. The macro will streamline the process by automating the matching of barcodes with the picklist items, enhancing efficiency and reducing manual errors. I would be delighted to discuss your project further and explore how I can assist you in achieving your automation goals. Please let me know a convenient time to connect via chat. Thanks, Volodymyr
$140 USD in 7 days
1.4
1.4

"Vista — where the climate’s as vibrant as the community." When it comes to automating tasks, my skills and experience as a developer make me the perfect candidate to create the Excel macro you need. Not only do I possess an extensive skill set, including proficiency in Excel and software architecture but, crucially, I've specialized in automation solutions - a skill that aligns directly with your project's requirements. I understand that your main objective is to streamline the process of scanning barcodes and ascertaining the corresponding box destination. This involves employing various functions like vlookup which I'm well-versed with. Additionally, automation being one of my core strengths has enabled me to develop excellent problem-solving abilities. This project appears sufficiently challenging and is likely to brush up my proficiency even further. Lastly, as a committed professional, my goal is to develop high-quality, efficient, and scalable solutions tailored specifically to my clients' needs. With your satisfaction in mind, I am dedicated to delivering on-time without compromising on the quality. Overall, my experience coupled with my passion for automation ensures not just a job well done but an effective solution that brings tangible value to your business.
$200 USD in 7 days
1.4
1.4

Hey there, I’d love to assist you in building the Excel macro for your barcode scanning tool. Based on your description, I can create a seamless solution that uses vlookup functions to match scanned barcodes with the correct box from the picklist. I’ve reviewed your requirements and will ensure the macro is efficient, user-friendly, and tailored to your specific needs. Previously, I worked on a project where I developed an Excel macro to automate inventory management by integrating barcode scanning functionality. The tool streamlined operations by matching scanned items with predefined categories, significantly reducing manual sorting time. My skills include expertise in Excel VBA programming for automating tasks and advanced knowledge of vlookup functions to manage and process large datasets efficiently. I want to discuss in detail. Best Regards,
$140 USD in 7 days
1.4
1.4

Hi I can build an Excel VBA tool that takes your picklist, scans barcodes, and instantly tells the user which box to place the item in with clear on screen cues and an audible beep on match. I recently delivered a kitting macro for a small warehouse where a USB scanner fed Excel, XLOOKUP mapped SKUs to bins, duplicates were flagged, and a simple log captured every scan for audit. I use structured tables plus XLOOKUP and INDEX MATCH for fast lookups, a protected Scan sheet with a big input field that accepts any HID scanner, color feedback for match or error, duplicate and over pick checks, and a Config sheet so you can change box rules without touching code. Optional exports to CSV and a summary of unpicked items keep teams aligned. I can start right away and match your review cadence. Happy to begin with a small paid pilot using your sample workbook to prove the flow. Send the picklist columns and barcode format and I will share a short plan today. Thanks for reading Jorge
$380 USD in 2 days
1.0
1.0

I am a perfect fit for your project. I understand the importance of automating tasks and integrating vlookup functions within the Excel macro to streamline the process of organizing items based on barcodes. While I am new to freelancer, I have tons of experience and have done other projects offsite. I would love to chat more about your project! Regards, Enri Esterhizen
$200 USD in 14 days
0.0
0.0

Vista, United States
Payment method verified
Member since Jan 11, 2018
$15-25 USD / hour
$30-250 USD
$50 USD
$750-1500 USD
$15-25 USD / hour
$250-750 USD
$750-1500 USD
₹600-1500 INR
$30-250 USD
$250-750 CAD
$30-250 USD
$250-750 USD
₹12500-37500 INR
₹1500-12500 INR
₹600-1500 INR
₹12500-37500 INR
₹100-400 INR / hour
₹12500-37500 INR
₹600-1500 INR
₹600-1500 INR
£20-250 GBP
₹12500-37500 INR
₹1500-12500 INR
₹1500-12500 INR
$10-30 USD