Inventory vba excel jobs
I'm seeking an expert in Excel who can help me with three key areas. Tasks include: - Data entry: I have an Excel spreadsheet with around 100-1000 rows and columns that require data input. - Data analysis: Extracting meaningful insights and patterns from the data provided. - Spreadsheet formatting: Ensuring the data is presented in a clear, professional manner which is easy to interpret. Specific functions and formulas required include: - Basic operations like Sum, Average, and Count. - Conditional formatting, to highlight key data points. - Pivot Tables, to present the data in a clear and organized manner. The ideal candidate should have a strong track record in data handling, analysis, and visualization using Excel. Great attention to detail and the abil...
I need an expert in web scraping, either in Python or by utilizing Google Chrome extension, to extract text data from a particular website. Should be delivered within 3 hours. The scraping is a one-time task, not requiring routine updates, and the extracted data needs to be saved in an Excel file (or CSV). This will be hidden behind a login wall - so I suggest that the Python script will go to the website and then wait one minute, where I will manually log in. Ideal Skills and Experiences: - Proficiency in Python for web scraping - Experience with scraping text specifically - Ability to deliver the required output in a CSV format
I require the expertise of a skilled data scraper who can quickly retrieve text data from a specified website. The site in question is I need the following specific information delivered in Microsoft Excel Format: - Country Name - Grand Lodge Name - Website address - Email address - Phone - Address - Grand Master name (if available) The ideal freelancer for this project would have significant experience in data scraping, particularly text data, and an understanding of the website's structure to retrieve the desired information effectively. Speed and efficiency are of the essence. Your ability to deliver this project promptly without compromising accuracy will win you this bid.
To give you a brief idea the da...seeking a Python expert who can give me 100% accurate "mapped" data without duplicates or missing information. YOU WILL BE REQUIRED TO WRITE/SEARCH NEW script to modify my data in Excel sheets - I have 3 Excel files having a total of 50000 rows, These are ingredients from recipes, I need you to do the following tasks - (A) - Assign a new ingredient ID number to all non-duplicate Ingredients. (B) - Replace "Name of ingredients" with the newly assigned number in the whole file (C) - For all ingredients - search, get the FDC ID from USDA Food Central and save this info in a separate file. Outcomes - 1. My Excel files - with names replaced with ID (non-duplicate) 2. 1 New file ie. the list of ALL ingredients (Cleane...
I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this task. They...
I'm in need of a professional software developer to create a system similar to Ship Rocket and Secure Ship. This software should include: - Order tracking: This is imperative as it will allow users to monitor their shipments in real time. - Shipping label generation: A streamlined process for producing shipping labels is a necessity. - Inventory management: The system needs to be able to effectively manage and monitor an inventory. The platform must be compatible across web browsers, mobile devices, and desktop computers. The design should be minimalistic, clean, and user-friendly. Proficiency in UX/UI design along with skills in software development will be essential for this project. Looking forward to bids from experienced developers who have previous experience in ...
...current Odoo ERP from version 13 to the latest version - Customize the ERP to include: - A proper accounting system - Human resources management - Custom report generation - Inventory management - CRM integration - Implement Odoo e-commerce to replace my existing WooCommerce. The e-commerce should: - Offer the same functionality as Woo Commerce - Have inventory management based on the warehouse location Ideal Skills: - Proven experience with Odoo ERP migration - Deep knowledge of Odoo customization - Skilled in building and customizing Odoo e-commerce platforms - Expertise in inventory management and CRM integration - Strong background in accounting systems and human resources management Prior experience in similar projects and good com...
...an experienced freelancer who can effectively perform data entry tasks involving financial data. While the specific type of data has not been specified -- it could range from invoices and expense reports to bank statements -- the chosen professional should exhibit versatility and aptitude in working with various forms of financial data. Key Requirements: - Proficiency in Excel: You'll need to be well-versed in using Excel for data entry tasks. - Background in Finance Data Entry: Experience or relevant knowledge in finance data entry is crucial. This ensures you can deliver accurate results. To apply, offer a detailed approach on how you would tackle this project. Also, provide evidence of your past work as well as your experience in the field. This will assure me of...
...smooth transactions for both us and our customers. - Inventory Management: Inventory management is crucial to our business. The app should facilitate easy tracking and updating of our product inventory. - Shipping Integration: Shipping is a significant part of the e-commerce process. The app should enable smooth integration with our preferred shipping providers, ensuring timely and accurate deliveries. User Interface: - I'm looking for a professional and sleek design for the user interface of the Linnworks Channel App. The design should be visually appealing and user-friendly. User Interaction: - The Linnworks Channel App should be highly interactive with real-time updates. We need to stay informed about the status of orders, inventory, and shipping i...
...highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required ski...
Create a form in Excel following the pre-determined options. The results of the answers must be recorded in a second tab
Hello, I am seeking an experienced web developer to create a website linked to a database for improved stock tracking. I currently manage store operations and aim to enhance our inventory management processes. Project Details: Functionality Required: Add new Entry (Item): Users should be able to add new items or remove items from the database through the website. Search Feature: Users should be able to search for items using their in-house product code (e.g., FIX001). The website will search the database and display the item along with details such as stock count and a picture. Stock Management: Interactive buttons for "Goods in" and "Goods out" to update stock levels directly through the interface. User Interface: The GUI must be user-friendly, catering to p...
I am in need of a web developer to build me an inventory management system. This system should have a good in / goods out functionality, with current stock levels. Furthermore, I would like it to include an analysis page that displays data tables and reports, as well as interactive filters and sorting. Ideal skills and experience: - Proficient in web development - Experience in developing inventory management systems - Understanding of data analysis and reporting - Familiarity with interactive filters and sorting
...of Odoo for my small business. The ideal candidate will have expertise across multiple Odoo modules and a proven track record in implementing and optimizing Odoo for small businesses. Key Responsibilities: - Integrate and optimize Odoo across Sales and CRM, Inventory and Warehouse Management, Accounting and Finance, and Human Resource modules - Ensure the Odoo system is user-friendly and efficient for a small team of 1-10 users Ideal Skills and Experience: - Strong understanding of Odoo modules, particularly in Sales and CRM, Inventory and Warehouse Management, Accounting and Finance, and Human Resource - Proven experience in Odoo implementation and optimization for small businesses - Ability to deliver a system that is user-friendly and efficient for a small team of 1-...
I intend to streamline the process of document submission and verification in relation to EDPMS entry and BRC, with a focus on customs or trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validati...trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validation purpose. Key Responsibilities: - Submission and verification of customs or trade-related documents - Verification and correction of any errors found in the documents Experience & Skills: - Experience in the customs or trade sector is essential - Proficient in Excel/CSV - Strong attention to detail and high accuracy in document handling - Previous exposure to EDPMS and BRC is...
I've already done most ...the key piece of work. - Comprehensive Review: It's important that you review my analysis comprehensively and suggest corrections or improvements where necessary. - Final Financial Year Analysis: The analysis should cover multiple financial years, ensuring a comprehensive assessment of my trading performance. Ideal Skills and Experience: - Proficiency in Excel: The data prepared to do is in an Excel spreadsheet format, so advanced Excel skills are essential. However I also have a full list of my trades that is only in pdf. - Financial Analysis: A solid background in financial analysis and portfolio management is necessary for this project. The ideal candidate will have a keen eye for detail and the ability to provide reliable, acc...
As your assistant for this project, my job will be to type data into an Excel spreadsheet. However, I currently don't have specific information on what type of data (text, numbers, dates) you require. Additionally, I need clarification on whether you have any specific formatting needs for the data and if any calculations or formulas will need to be applied. Ideal Skills: - Proficient in Microsoft Excel - Precise and quick typing ability - Understanding of Excel formulas (just in case) Your prompt response to these questions will help ensure successful completion of your project. Looking forward to working with you!
...architectural drawings in an impressive and articulate format. So, if you've got strong knowledge of residential architecture and experience with these software tools, you could be the perfect fit for this project. Your expertise is paramount for the success of my architectural drafts and interior designs. Individuals with a detailed-oriented mindset and the ability to think outside the box will excel in this project....
I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this task. They...
• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extraction from the portal]". • Automate the proce...
For my expanding fashion business, I'm on the hunt for inspired and skilled fashion designers -- those who excel in creating both underwear, swimwear, and sleepwear for Womens. But, the real cherry on top would be a knack for lingrie designs. Key Requirements: - Ability to create unique, innovative designs that target different audiences - Proficiency in both trendy and classic styles. We value versatility! - Expertise in working within a monochrome and neutral color scheme Desired Skills: - Expert knowledge of fashion trends in underwear, swimwear and sleepwear - Exceptional creativity and innovation - Strong sketching skills with attention to detail With your help, we can revolutionize the market by producing designs that encapsulate both the traditional classics and...
I'm seeking a meticulous data entry operator capable of transferring data from digital documents to an Excel sheet. This task involves: - Taking solely textual data from digital documents. - Conducting minor internet research and using ChatGPT when necessary to fully understand the instructions. - Accurately entering the required information on the provided Excel sheet. The ideal candidate for this job is one who is proficient in the use of Excel spreadsheets and has excellent attention to detail. Previous work experience in a similar data entry role is advantageous. This work is specifically in the context of creating content for product listings in e-commerce sites. So if you have specific experience in this area, that would be an additional bonus.
I require a freelancer proficient in excel to assist with data cleaning and sorting tasks for a range of diverse digital files. Your expertise in managing and optimising Excel spreadsheets will be invaluable and greatly appreciated. Key tasks will include: - Using Excel functions to clean datasets, removing discrepancies and inaccuracies - Sorting data into relevant fields and categories for easier access and analysis The optimal freelancer will have: - A meticulous eye for detail to ensure data accuracy - An understanding of Excel formulae and functions - Proven data cleaning and sorting experience - The ability to meet tight deadlines without compromising quality. Your primary role will be to untangle and streamline my Excel spreadsheets, making t...
I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial for successful output.
I need a freelancer well-experienced in VBA to automate the generation of reports for my business, specifically in Gmail. It's critical for this project to be completed as soon as possible, and here are the specific needs: - Develop VBA scripts that will automatically generate and send specified reports. - Must have a deep understanding of Gmail infrastructure in order to correctly implement the automation process. - Must demonstrate a proven track record in completing similar automation tasks. Your expertise in ensuring efficiency and accuracy is important. If you believe you're the perfect candidate and can deliver this project promptly, please reach out.
As discussed I have completed the template for Home Team Workbook.
I'm seeking a home-based freelancer proficient in Microsoft Word, Excel, PowerPoint, Outlook, and Tally ERP 9 for a variety of tasks. Key Responsibilities: - Data Entry: Accurate, timely, and efficient data entry support is a core requirement. - Document Formatting: Assistance with formatting a range of documents, ensuring a professional and consistent appearance. Ideal Skills & Experience: - Proficiency in Microsoft Office Suite: You should have a strong command of Word, Excel, PowerPoint, and Outlook. - Data Entry: A proven track record in data entry, with a focus on maintaining a high level of accuracy and meeting deadlines. - Tally ERP 9: Experience in using Tally ERP 9 is preferred, but training can also be provided. - Organizational Skills: Ability to manag...
I'm seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a user-friendly, efficient, and reliable ...
...ERP for accounting and inventory control, develioped using Spring Boot and Angular. I am in need of an experienced developer who can assist in integrating various PDF formats of invoices through the use of Optical Character Recognition (OCR) technology. The primary objective of this task is to streamline and automate the processing of invoices. Initially we can focus only on Sales Modules in which we have 2-3 formats of invoice and which need to be imported automatically in the entry module. Key Project Details: - The PDF invoices I frequently deal with come in both scanned image and digital (text-based) formats. - The extracted data from these invoices must be: - Directly integrated into Sales and Purchase Invoice Module for further processing - Exported to Excel...
I need a system that can take data from the existing Excel files and convert them into customized PDF reports. Key Points: - The primary data source is existing Excel files. This means you need to have the ability to efficiently extract and interpret data from these files. - The PDF reports need to be customized with personalized data fields. So, you should be able to dynamically merge data from Excel into the PDF reports. - Proficiency in PDF generation tools and Excel data manipulation is essential. Your responsibilities will include: - Developing a system that can accurately generate customized PDF reports using data from Excel files. - Ensuring that the system is user-friendly and can be easily adopted by non-technical team members. - Working with...
I want to build anything which enables me to send customized whatsapp message as well as images from excel sheets
I want to get a extension which can send messages and images from whatsapp web using numbers and other data from excel sheet
I'm looking for a professional experienced in Odoo, POS systems, and Python to integrate a weight scale with our Odoo ERP system. Key Features: - Real-time communication between the weight scale and the Odoo inventory management module. - Automated pos billing via the scale's measurements. Required Expertise and Skills: - Proficiency in Odoo ERP and POS systems - Knowledge of weight scale integration (preferably digital scale) - Python language skills - Familiarity with ERP modules, particularly Accounting and CRM components The ideal candidate will be able to deliver an efficient, error-free integration that simplifies our operations and improves our customer service.
I need help setting up and configuring an FTP server for a specific project. We use an inventory management system that only supports sharing data via SFTP or FTP transfers. We aim to establish our own FTP server to gather this data and integrate an automated process that transfers the data to our Facebook catalog. The feed should update once or twice daily. If you have experience with this, I would appreciate a discussion with you.
Here is a list of 35000 phone numbers. I need the american country code, +1, added to each entry. There is a way on excel to do this pretty quickly, I just dont know if, hoping you do.
I have an Excel data set that encompasses 5-10 sheets. I need support in: - Data entry: Entering new information into the existing sheets. - Data cleaning: Checking and correcting any errors in the data, removing redundancies. - Data analysis: Conducting basic analysis of data. Ideal applicants should have beginner proficiency in these tasks. Your experience working with Excel data files, especially handling entry, cleaning, and analysis tasks, will greatly benefit this project.
...website designed particularly for selling physical products. This website should have: - An efficient inventory management system kicking my business into high gear, enabling accurate tracking of product stock levels. - A user-friendly shopping cart and checkout system making it absolutely convenient for businesses to make their purchase. - A reliable customer reviews and ratings system to provide transparent feedback about products which will help other businesses make informed decisions. Ideally, the freelancer taking up this task should carry a strong background in ecommerce website development, with a focus on B2B platforms. Proficiency in integrating key functionalities such as inventory management, shopping cart systems and review systems is crucial. Looking forwar...
I'm looking for an intermediate Excel expert to create a user-friendly database system for managing contacts and tracking outgoing information. Key Requirements: - Develop a simple yet effective database system within Excel. - Design a user interface that is intuitive and user-friendly. - Ensure the system is structured to manage contacts efficiently. - Implement a feature to track when and what information is sent to each contact. What I'm looking for: - A freelancer with a proven experience in working with Excel and developing databases. - An intermediate level of proficiency in Excel. Advanced skills are not necessary, but a basic understanding won't suffice. - Ideally, I'd like the freelancer to have experience in designing user interfa...
I'm in need of an experienced developer...online business selling sunglasses and I have both high-quality images and descriptions ready to use. Your task will involve: - Developing a clean, user-friendly e-commerce website. - Setting up a product catalog and managing inventory for one product. - Ensuring secure payment processing pathways are integrated. This must include the popular credit and debit cards, along with other online payment systems. - Integrating the site with social media platforms for increased visibility and customer interaction. Key skills include Shopify development, e-commerce, inventory management, payment gateway integration, and social media integration. Previous experience in developing single product stores would be appreciated. I look forw...
I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.
I'm in need of a professional proficient in Excel and data entry to support two key tasks: data analysis and spreadsheet management. Here are the tasks in detail: - Data Analysis & Visualization: I've collected customer feedback data which need to be efficiently analysed and visualized. - Spreadsheet Creation & Management: The data mentioned above should be incorporated into comprehensible spreadsheets. In terms of analysis, the focus should be on customer segmentation. Ideal candidates should have: - Advanced proficiency in Excel for data analysis and visualization - Strong understanding of data cleaning and formatting to ensure accurate analysis - Experience with customer segmentation based on feedback data.
I'm aiming to develop a new website, from scratch, focusing on the automotive niche. Integral parts of the site should be WordPress set up and AI for auto blogging. Here's a roundup of essential features: - Vehicle listings and inventory: It should be easy for users to view and manage these. - Car industry updates: This should be a primary focus for the site's content. - Car news: Regular updates should be published. - Comparisons: Provide detailed comparison between various makes and models. - Interactive Reviews: Allow users to leave reviews and read reviews from others. - Insights and analysis: Keep a keen eye on industry trends and provide analysis. Ideal skills for this project: - Extensive experience with WordPress - Knowledge of AI blogging - A good grasp of ...
I'm looking for an experienced data analyst who possesses expert skills in Excel and/or Google Sheets and a proficient understanding of Football, Basketball, and Baseball data. Ideally, someone who is skillful with analyzing and interpreting commercial level sports data into the form a betting model that understands, quantifies, and predicts based on specific metrics. The key characteristics of the models are: - Focus on the following sports: Football, Basketball, Baseball - Analyze the following data: Team performance, Player statistics and Game score projections to forecast point spread, totals, and moneyline bets. I have historical data ready to be applied to these models. This is a project where being communicative, organized, and knowledgeable in sports data ana...
I'm in need of a simple and clean website for my company. The main purpose of the website is...site information, I need someone with a creative flair to bring it to life. Successful collaboration on this project may lead to additional WordPress opportunities with my other clients in the near future. I already have domain and hosting setup. As this is an informational site only and it should be pretty simple I'm looking to stay around $50-$75 Required Pages: - Home - About Us - Current Inventory - Contact Us Content for the About Us Page: - Primarily company history Please include samples of your previous work and your proposed cost in your bid. I already have domain and hosting setup. As this is an informational site only and it should be pretty simple I'm looki...
as per communication, transfer data from DPF to excel.
I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.
...functionality: The primary function of this website will be to facilitate the sale of products online. This should include a sleek product catalog display, secure shopping cart, and seamless checkout process. - Admin Panel: An intuitive and easy-to-use admin panel is crucial for managing the website effectively. This should allow for adding, editing, and removing products, monitoring sales, and adjusting inventory levels. - Payment Gateway Integration: The website must support payment processing through both Stripe and major credit/debit cards. The integration should be secure, reliable, and seamless for users. - Product Diversity: The platform should be designed to accommodate both physical and digital products. This means having the ability to accurately display and manage the ...
I'm looking for a skilled freelancer who can create an automated Excel spreadsheet calculation for me. I need this spreadsheet to perform calculations based on cumulative data, specifically organized by date. You will need to be adept at Excel and have experience in creating automated spreadsheets. Knowledge of data organization and basic statistics would be a plus. I'm looking for a quick turnaround on this project. Please watch my videos for more details on what exactly is required.
