Excel/VBA Macro Upgrade for excel Inventory Program

$30-250 USD

Open

Posted

about 5 hours ago

•

Ends in 6 days

$30-250 USD

Paid on delivery

I'm seeking an expert excel/vba programmer. I'm using an existing vba macro excel program that needs to be upgraded. It was created to automate the process of building a single inventory list from multiple vendors feeds. The website is now using the Shopify platform and requires data to be imported into different column names and for more columns added. Summary of work required: 1. Need to change the import process to a single form, where feed can be added, vendor profile selected, map file column names to names in the program, save profile and import feed. 2. Adjust Export functionality to use similar template with different columns for different export options. 3. Data in compiled list needs to be read only unless enabled for in-line editing 4. Need a button to be able to add a single line to the sheet if needed (this will add a new line with all formulas/repetitive data columns already completed) 5. Column N thru AF is currently using split and some other formulas to manipulate the vendor categories Iine column AF the vendor categories are renamed to AGB category names (located in sheet CAT Reconcile sheet) This functionality needs to be programmed in to allow categories from vendors to be automatically renamed and added to column AF Also - Build Cat Reconcile feature - ability to be able to see existing categories and their assigned AGB alternative + be able to add new ones NEW FEATURE 6. GB DESIGNER . Popup form to build bundle designs using existing components. . List of created bundled designs (option to edit/delete designs) . Popup Form to add/edit/delete components to GB Components. GB COMPONENTS . inventory of added components

Project ID: 39017014

About the project

39 proposals

Open for bidding

Remote project

Active 19 mins ago

Place your bid

Bid amount

USD

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

39 freelancers are bidding on average $151 USD for this job

@rahul62544

Hello Davee, I am thrilled to propose upgrading your Excel/VBA macro for your inventory program. The project involves enhancing the current automation process to accommodate Shopify's platform changes and additional functionalities. To achieve this, I will: 1. Implement a user-friendly form for importing feeds and mapping column names. 2. Modify Export function to cater to various export options. 3. Set the compiled list to read-only mode with in-line editing capabilities. 4. Add a button for easy insertion of new data lines with completed columns. 5. Enhance vendor category manipulation and automate the renaming process. For the new feature - GB DESIGNER: - Create a popup form for building bundle designs and managing components. - Develop a feature to view, edit, and add components to GB Components inventory. With expertise in Data Analytics, Visual Basic, and Shopify integration, I am equipped to deliver a seamless upgrade aligning with your requirements. Looking forward to bringing your inventory program to the next level! Thanks, Rahul

$225 USD in 1 day

5.0

(1046 reviews)

8.8

@sareheshak

About me I am a CERTIFIED Excel VBA Programming , ,,,,,,,,,, I specialize in enhancing and optimizing data import/export processes, improving category management systems, and developing new features to efficiently manage bundled designs and components.

$80.80 USD in 1 day

5.0

(72 reviews)

5.9

@khurshid040462

I’m Khurshid, a Shopify designer with 10th years of experience."Excel/VBA Macro Upgrade for excel Inventory Program" I propose a tailored Shopify website that showcases your products effectively, featuring a user-friendly layout, responsive design, and optimized checkout process. My goal is to enhance customer experience and drive sales. Let’s bring your e-commerce vision to life!

$85 USD in 5 days

5.0

(37 reviews)

5.4

@ayazakhtar75

Hello Client, This is definitely possible. With my expertise in Excel VBA and automation, I can efficiently upgrade your inventory program by enhancing macros, improving functionality, and optimizing performance. I have extensive experience streamlining inventory management systems, ensuring seamless data processing and automation. Would you like to discuss specific improvements or custom features you need in the upgrade? Regards Ayaz Akhtar

$100 USD in 1 day

5.0

(32 reviews)

4.8

@wairimubredah20

Hello Davee, I am thrilled to propose my expertise for upgrading your Excel/VBA macro inventory program tailored for the Shopify platform. The enhancements you seek are exciting and require a detailed approach. Here's a summary of the work I'll undertake: 1. Revamp import process to a user-friendly single form for effortless feed addition and vendor profile selection. 2. Customize export functionality with various template options catering to distinct column requirements. 3. Implement a read-only feature for the compiled list with enabled in-line editing. 4. Develop a button for adding a line with pre-filled formulas and data columns. 5. Enhance vendor category manipulation in columns N to AF, automate category renaming, and integrate the Cat Reconcile feature. For the new feature: 6. Introduce GB DESIGNER with a popup form for bundle designs and components management. Skills: Excel, Shopify, Data Analytics, Data Analysis, Visual Basic. I am confident in delivering a seamless upgrade that aligns with your vision. Looking forward to collaborating on this innovative project. Thanks, Bredah

$200 USD in 1 day

5.0

(3 reviews)

4.1

@abhay686

Hello Davee, If you are not satisfied with the work, do not pay. I’m Abhay, a data scientist with over 6 years of Excel and VBA programming experience, making me the perfect fit for your project. What I Offer: 1. Streamlined Import Process: Single form for feed import, column mapping, and vendor profile management. 2. Enhanced Export Functionality: Export templates with customizable columns. 3. Read-Only Data: Enable in-line editing only when required. 4. Dynamic Row Addition: Add preformatted rows with one click. 5. Category Automation: Map vendor categories to AGB alternatives with an intuitive management feature. 6. GB Designer: Build and manage bundled designs and inventory components. I’ll deliver an upgraded and efficient solution tailored to your needs. Looking forward to collaborating. Best regards, Abhay

$150 USD in 2 days

5.0

(3 reviews)

3.1

@SajidaSaqira

Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Visual Basic, Excel, Shopify, Data Analytics, Data Analysis Lets connect in chat so that We discuss further. Thank You

$135 USD in 7 days

5.0

(1 review)

2.6

@nenad45

Hello, I am an experienced Excel/VBA programmer with a strong background in data analytics and a proven track record of upgrading complex macros. I can efficiently implement the required upgrades to your existing inventory program, ensuring a seamless data import process and enhancing export functionality. With my expertise, I will incorporate the new features you've outlined, including the GB Designer and the ability to manage vendor categories effectively. I am committed to delivering high-quality results in a short timeframe, all while maintaining a low budget. Could you provide more details about your preferred timeline for this project? Thanks, Nenad

$300 USD in 5 days

5.0

(1 review)

2.3

@lizin3

Hello, I'm fullstack expert, with over 13 years experience dealing with web, I can help update excel Inventory macro by excel macro. I've previously worked on the exact similar project for American Rudy employer. When do you need this finished by? I understand how annoying it is, and can finish this project for you quickly! Please send me message, so i can understand details for your project. Waiting for your reply. Best regards. Lizi

$140 USD in 4 days

5.0

(1 review)

2.0

@bytesblitzz

Dear Davee, I am excited to apply for this project. At BytesBlitzz, we specialize in designing exceptional and extensive websites and mobile applications using Figma and Adobe XD and then using modern technology stacks which includes Custom Languages and all CMS (WordPress, Shopify, WebFlow, etc) we develop them with having keen eyes on the details and user-experience. Also, you can have a glance at our profile here www.freelancer.com/u/bytesblitzz Our commitment to excellence means we not only meet but exceed expectations. We approach every project with a blend of creativity and technical prowess, ensuring your vision comes to life seamlessly. Key offerings include: • Unlimed revisions and multiple variations (On Mockups) • Dedicated Project Manager for clear communication and daily updates • 24/7 chat support for ongoing assistance • Delivery within agreed timelines • Post-Deployment maintenance up to 45 days • Free Deployment • Quality Assurance (Manual/Automation) • Video tutorials at the end for better understanding of how to manage things later We are eager to giving you a warm welcome at BytesBlitzz and ready to discuss how we can contribute to your project's success. Please let us know a convenient time to connect so we can escalate the QNA session and can get started. Best Regards, BytesBlitzz ••••••••••• P.S.: Our portfolio will be shared in Chat •••••••••••

$140 USD in 7 days

5.0

(2 reviews)

1.8

@skinginfotech

Hello, I have checked your requirements and really interested in this job. I am ready to start work immediately. I have 12+ years of experience in PHP, Laravel, Wordpress, Shopify, Magento and Opencart. I am to deliver our best service and you can check my profile and best reviews by clients.

$80 USD in 2 days

4.6

(1 review)

1.4

@jamesr695

Hello, As an experienced Full Stack Developer, I approach this Excel/VBA macro upgrade project with a firm background in both front-end and back-end development, languages such as Java, Python and C#, and a profound understanding of the Shopify platform. I recognize the need for your inventory program to be revamped to fit the Shopify data import/export structure. I've worked on similar projects before, so I am well-versed in transforming complex data structures and implementing advanced VBA macros that automate data handling tasks adeptly. One key strength that sets me apart is my proficiency in web technologies. In addition to Excel/VBA, I am also comfortable with HTML, CSS, and JavaScript. This combined skillset empowers me to not only improve your existing macro but also enhance the overall usability of your program through an intuitive single-form import process, enabling efficient handling of multiple vendor feeds Thanks!

$200 USD in 1 day

0.0

(0 reviews)

0.0

@flowdezign

Hello, As a seasoned freelancer with deep expertise in both Excel/VBA and Shopify, I can confidently say that I am perfectly suited for your project. Over the years, I've worked on numerous projects involving data synchronization, manipulation, and building macros to streamline inventory processes - experiences that align perfectly with your needs. Plus, my proficiency in working with Shopify means I will hardly need a learning curve. In particular, let's talk about how I can bring value to point 1 - 6 of your project. From creating a single form for importing data, mapping column names, handling data read-only access to easily adding new rows - I have done it all before with accuracy and efficiency. Moreover, the feature of automatically renaming categories aligns with an increasing hassle-free inventory management system that is always on my radar. Another notable addition to my skills set is the development of GB DESIGNER and GB COMPONENTS. As someone who actively works in the realm of SaaS and MVP Apps, building dynamic forms with intricate details like bundling designs using components doesn't intimidate me - it inspires me! I am confident in replicating that passion into making your GB system ultra-efficient and user-friendly as well. So why wait? Partner with an experienced professional ready to understand your vision and deliver excellently within defined timeframes. Together we can bring your inventory management process Thanks!

$30 USD in 3 days

0.0

(0 reviews)

0.0

@efanntyo

Hello Davee C. Hope you are doing well! This is Efan , I checked your project detail carefully. I am pretty much experienced with Shopify, Visual Basic, Data Analytics, Data Analysis and Excel for over 8 years, I can update you shortly. Cheers Efan

$100 USD in 2 days

0.0

(0 reviews)

0.0

@miroslavg1

✋!!STOP HERE!!✋ Dear client, Thanks for your job posting and hope you are doing well. I am writing to express my interest in the open Excel/VBA Macro Upgrade for excel Inventory Program. With over seven years of specialized experience in Data Analytics, Data Analysis, Excel, Visual Basic and Shopify, I'm passionate about crafting solutions that truly meet your needs. I'm genuinely excited about the prospect of contributing to you and would love to share more about my previous work. Thank you for considering my application, and I look forward to the possibility of discussing this further. Warm regards, Miroslav G.

$149 USD in 1 day

0.0

(0 reviews)

0.0

@ayesha0124

Hello, How r u doing? I have gone through the project and i believe that i can handle it well having experience related to Excel, Visual Basic, Data Analysis, Data Analytics and Shopify. Please have a look at my profile to have an idea of my previous work: https://www.freelancer.com/u/ayesha0124 Regards, Ayesha

$250 USD in 7 days

0.0

(0 reviews)

0.0

@Pearpixels

Hi, Your job post for Excel/VBA Macro Upgrade for excel Inventory Program caught my eye because it aligns perfectly with my skill set. Having thoroughly reviewed the requirements, I am confident in my ability to deliver high-quality results for your project. My expertise in Visual Basic, Excel, Shopify, Data Analytics, Data Analysis makes me a strong candidate for this position. If you think I’m a good fit, please start a chat so I can ask a few questions to better understand your needs. Sincerely, Yasir

$250 USD in 7 days

0.0

(0 reviews)

0.0

@deanmercer68

Hi, I went through your project description and it seems like I am a great fit for this job. I am a fullstack and AI developer with 7 years of experience on Visual Basic, Excel, Shopify, Data Analytics, Data Analysis Please come over chat and discuss your requirement in a detailed way. Thank You

$140 USD in 7 days

0.0

(0 reviews)

0.0

@benjaminb22

My experience working on an array of similar projects affords me the confidence to excel in this project

$300 USD in 7 days

0.0

(0 reviews)

0.0

@ShreejiPowerBI

At Shreeji Data Analytics, we specialize in delivering tailored solutions that optimize workflows and enhance efficiency. With over 12 years of expertise in data solutions and as a Microsoft-certified partner, we are ready to upgrade your existing Excel VBA program to meet your evolving needs seamlessly. Our Approach: Streamlined Import Process:Create a single form for feed imports with the ability to select vendor profiles, map file columns, save profiles, and automate imports. Enhanced Export Functionality:Implement export templates with customizable columns for multiple export options. Improved Data Management:Enable read-only compiled lists with optional in-line editing. Add functionality for quick single-line additions with pre-filled formulas and repetitive data. Automated Category Mapping:Program vendor categories to map automatically to AGB category names. Build a "Category Reconcile" feature to view, add, and manage category assignments. New Features:GB Designer: Design and manage bundle components using a popup form, complete with options to edit/delete designs. GB Components: Maintain an inventory of components, with the ability to add/edit/delete items seamlessly. Why Shreeji? Proven Expertise: Delivered robust solutions for global clients like Siemens and Walmart, streamlining operations and improving productivity. Technical Excellence: Mastery in Excel VBA, T-SQL, and process optimization ensures precise and scalable results. Let’s connect

$150 USD in 2 days