Vba excel inventory example jobs

I need an experienced professional to help me set up an e-commerce website on Shopify, specifically geared towards selling baseball, basketball, football cards, and Pokemon cards. Key Project Requirements: - Integration with Shopify POS: I want to use Shopify's POS system to manage our inventory and process transactions. - Inventory Management: I need a user-friendly way to add & update inventory promptly, including images. - E-commerce Features: The site needs to have search functionality, sorting options, and a simple, engaging design. Skills and Experience: - Proficiency with Shopify: You should have a good track record of setting up and customizing Shopify stores, with an understanding of how to integrate POS. - E-commerce Development: A solid grasp of...

As a registe...and manufacturing my own line of gym items rather than reselling existing brands. I'm searching for an Amazon FBA expert who: - Understands the gym product market well - Has proven experience with listing and selling gym products on Amazon - Can assist me in effectively managing the whole FBA process - Has experience with product sourcing and manufacturing strategies - Can advise on pricing, inventory management, product descriptions, and answer customer queries effectively Knowledge of fitness-oriented products is a plus. This project requires strong problem-solving skills and a thorough knowledge of Amazon's policies and procedures. If you're a detail-oriented professional with a knack for maximizing profit while maintaining customer satisfaction, I...

...demo or screenshot and then I decide to purchase your system. Ideally, the system will fulfill the following requirements: - IMEI/Serial Number Tracking: I need the ability to keep track of devices according to their unique identifiers. - Label Generator: The system should facilitate creation of labels showing a mobile's condition and price. - Inventory Management: To prevent discrepancies in stock counts, the software should also track inventory using the IMEI numbers. In addition, the system should incorporate key functionalities from WooCommerce, my e-commerce platform: - Product Management: Integration of the billing system with my product listings on WooCommerce is mandatory. - Customer Accounts: Simplifying customer dealings is crucial hence, a smooth connec...

...record includes creating and designing courses that resonate with diverse audiences, driving engagement and delivering tangible results. ⏰ **Timing Mastery**: You understand the importance of pacing and timing in course delivery. You'll orchestrate the flow of content to keep participants engaged and motivated every step of the way. ✍️ **Copywriting Skills**: Beyond just instructional design, you excel in crafting compelling copy that speaks to our target audience. Your words will inspire action and drive enrollment. ? **Quality Assurance**: Attention to detail is your middle name. You'll conduct thorough testing of the course materials to ensure seamless functionality and a superior learning experience. But that's not all! In addition to course creation, you&#...

I need a freelancer with a deep understanding of Excel ,data management and social media to extract info from profile list that we have . As the project involves organizing approximately 20,000 rows of data, proficiency in handling large datasets will get you far in this task. Key Project Details: - Data Type: The data primarily comprises email addresses and phone numbers. - Links in Profile - Other profiles in the profile - Formatting: The data files contain labels, so you'll need to distinguish this information keenly. Ideal Skills: - Proficient in Excel - Expertise in data management - Data Scraper

I need an expert with strong Excel skills to create two simple line graphs. Though I didn't provide specifics, these will be used to illustrate financial data, so experience in creating graphs for financial analysis would be ideal. Fast turnaround is critical. I will share 2 images of sample graphs. You need to put same data but have to create it line graph and in excel. I need this now. If you can't do now then please dont waste my time.

I require a professional who can develop a detailed sales forecasting report leveraging Power BI. The project needs to be done within one day. Key Requirements: - Utilize data from Excel spreadsheets for the forecasting. - The sales forecast should be detailed, breaking down sales by product/service. - The forecasting model should be based on regression analysis. Ideal Skills: - Proficiency in Power BI. - Strong experience in Excel data analysis. - Proven track record in regression analysis for sales forecasting. - Ability to work under tight deadlines.

I'm in need of an experienced WordPress Developer to create an Wordpress e-commerce POS system for me. This will be a platform for selling various products. Wordpress POS system A wordpress plugin to manage restaurant products, inventory, order and payments. The system must support: - taking food orders - taking drink orders - manage inventory - taking multiple orders - Keeping tabs and (adding items to a customer order until payment) - track states of food orders It does not need to support payment gateway (a NULL gateway for V1 is OK) Key Requirements: - Developing an E-commerce Website: The primary goal of this project is to create a fully functional e-commerce website using Wordpress. The site should be user-friendly, sec...

I am in need of a Visual Basics code in Excel that specifically focuses on equipment check-in and check-out functionality, while also automatically creating a record for each transaction. Key Features: - Equipment Check-in and Check-out: The primary purpose of the program is to allow users to easily check equipment in and out. - Automatic Inventory Status Update: The program should update the inventory status automatically, ensuring that the availability of each item is always up to date. Additional Features: - Daily Reports: The program should generate daily check-in and check-out reports - this would be beneficial for managing equipment usage and tracking. - Statistics: The program should also provide statistics on equipment usage. This could help in determining pa...

Transferring data from a jpg file to an excel table. With online access via google

I'm looking for a Power BI expert to help me set up a robust sales forecasting system. Responsibilities: - Integrate my Excel spreadsheets into Power BI Desktop - Design visually appealing and intuitive dashboards that clearly display sales forecasts - Utilize Power BI's capabilities to predict sales trends Ideal Skills: - Proficiency in Power BI Desktop - Expertise in Excel spreadsheet integration - Proven track record in sales forecasting - Strong communication skills to understand my business and its sales forecasting needs This project requires someone who can not only set up the technical aspects but also has a deep understanding of sales forecasting.

I have a set of less than 10 excel spreadsheets that I use for various purposes. I'm looking for a talented professional who can re-work these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirements in more detail. ...

Need after effect animation exactly same like that ribbon style with new text See animation and then placed the bid write " RIBBON " in the bid

I am seeking a proficient web data scraper to extract specific information from a prominent South African property portal and organize it in an Excel spreadsheet. Key Project Requirements: - Extracting and organizing the following data: property information (e.g., price, location) and size. - No need for continual updates, just a one-time extraction. Filtering Criteria: - The data to be scraped should be from a particular property portal and should extract information like : property type (industrial/retail/office), size, address, price. Ideal Skills: - Proficiency in web scraping techniques and tools. - Strong experience with Excel and organizing large sets of data. - Familiarity with the South African property market would be a plus. The goal of this project is to ob...

...can provide me with detailed information on the location of secondary schools with sports facilities within a 10-minute walk of zones 1 and 2 of the London Tube. An example of 2 schools would be expected before any contract starts, please do not provide before being contacted as I will share the list. Key Requirements: - Research: This project demands high-quality research skills. You will need to locate and verify the schools that meet our criteria. - Mapping: Proficiency in using online mapping tools is essential. - Data Management: The final report should be in Excel format. Experience handling and analyzing data in Excel is a must. - Need to confirm they have sports facilities - Data needed is Name of school - distance to tube - address - Phone number off t...

convert gramms per second to litres per m thermodynamics fluid in excel calcualtor pv=nrt

I have a number of JPEG images with text which I need to be transcribed into an Excel spreadsheet. The task should take around 2 - 3 hours to complete. Key Requirements: - Convert text from JPEG images to an Excel spreadsheet - Organize the data into categories as requested - Implement numeric data validation checks for accuracy Ideal Skills: - Proficient in data entry and data management - Familiarity with Excel and its functionalities - Strong attention to detail and accuracy - Experience in implementing data validation checks Please ensure that before submitting, you are confident in your ability to deliver an error-free and well-organized Excel spreadsheet.

I have a PDF catalogue that I need converted into an Excel spreadsheet. The PDF contains a mix of text and images which are crucial for the data. Key requirements: - Extract the data from the PDF and input into an Excel sheet. - Embed the images within the corresponding cells in the Excel file.

I require an accurate and efficient individual to input a combination of numeric and text data into a spreadsheet. This will involve less than 1000 entries. The primary task will be to input shipment data from Bills of Lading (BOLs) into an Excel file (.xlsx). The data must be organized based on specific categories found in the BOLs. Therefore, attention to detail and a keen eye for categorization is crucial. NOTE: BOL's shipped to the same location (multiple BOL's) must be added together on the same line. EXAMPLE: 1/1/2024 (5 Pallets) To Store #2595 2/1/2024 (4 Pallets) To Store #2595 NOTE: There are two types of BOL's a. Multiple Stop BOL"s. These will have 4-5 store location drops / entries to be made. b. Single Stop BOL&...

I'm seeking a skilled UI/UX designer to create an aesthetically pleasing and user-friendly Point of Sale (POS) software for my restaurant and retail business. The software will be used on both desktop and mobile platforms to handle tasks that include inventory management, sales tracking, and customer management. Key Requirements: - Create a modern and minimalist design: As a designer, you should be proficient in creating sleek, clean, and easy-to-navigate interfaces that align with the modern and minimalist aesthetic. - Design for both Desktop and Mobile: The software is intended to be used on both desktop and mobile platforms. Experience in designing for cross-platform applications is a plus. - Prior experience with POS software: Experience in designing for POS software, esp...

I am seeking an experienced Django developer to make specific modifications to the Single Invoice Page on my current POS web application. The chosen candidat...simplify our processes. These strategies include: - Streamlining our checkout process to quicken and optimize customer transactions - Implementing barcode scanning for products to speed up the billing process, with a preference for integrating barcode scanner hardware - Integrating an inventory management system to ensure our stock levels are always accurate and up-to-date Ideal candidates should have experience in Python's Django framework, implementing barcode scanning technologies, and integrating inventory management systems. A keen eye for design, detail, and a commitment to functionality are also highly va...

Please Sign Up or Login to see details.

Expert in MS excel for automation of sheets

I'm looking for a skilled freelancer to help me customize my Excel alerts with WAV files. - I have the specific sounds in mind for each type of alert, but I need someone who can skillfully integrate these into Excel's alert system. - You should have experience in both Excel and sound file manipulation, in order to create a seamless and professional system. - Please provide examples of past work to showcase your compatibility with this project.

I'm looking for a talented virtual assistant specifically experienced in Amazon Seller Central to help me with major tasks for my Amazon Europe store. Key Responsibilities: - Listing Optimization: You will be responsible for ensuring that our product listings are of top quality, SEO-optimized and attractive to potential buyers. - Inventory Management: Keeping track of inventory levels, ensuring items are in stock and monitoring reordering processes. - Advertising and Promotions: Crafting and executing advertising campaigns to boost visibility and sales. You should be proficient in using Amazon Seller Central, particularly for the European market and have a proven track record of positive results. Strong SEO and marketing experience would be a great plus. Your understan...

I have an Excel file that I'd like to convert to a Google sheet. I need the Google sheet to keep all the formulas that are present in the Excel file. Key Requirements: - The Google sheet should have all the formulas intact from the original Excel file. - Include Data validation rules to ensure the data entered is accurate and meets certain criteria. - Implement Conditional formatting to visually highlight important information. - Custom scripts or functions to automate certain tasks and enhance the sheet's functionality. - Preserve font styles and retain cell borders from the original Excel file. - Maintain the column widths as in the original Excel file. Skills and Experience: - Proficiency in Excel and Google Sheets, including advanc...

I'm looking for a professional who can help me develop a comprehensive Excel workbook for RFQ analysis and purchasing. The primary goal of this tool is to streamline our purchasing process. Key Responsibilities: - Develop an Excel spreadsheet for RFQ analysis and purchasing. - Implement basic formulas and functions to automate data analysis. - Ensure the tool is user-friendly and easy to navigate. Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of its functions. - Experience in developing purchasing and analysis tools. - Ability to streamline processes through automation. This is an exciting opportunity for someone with a keen eye for detail and a strong understanding of purchasing processes. Looking forward to your proposals.

...and should be able to demonstrate a clear understanding of the specific challenges and nuances of the field. Key Responsibilities: - Creation of performance metrics and KPIs: The specialist will be responsible for developing and implementing key performance indicators for the transportation and warehouse operations. The KPIs should primarily focus on improving delivery efficiency, increasing inventory accuracy, and reducing transportation costs. - SOPs Development: The candidate will also be in charge of creating comprehensive Standard Operating Procedures that are tailored to our specific operations. These SOPs should be clear, concise, and align with the performance metrics established. Skills and Experience: - Proven experience in 3PL management: The candidate should have a...

I'm looking for a diligent researcher who can compile a list of tire processors across different US states and organize the information in an Excel spreadsheet. Key Responsibilities: - Conducting online research to identify tire processors in each state. - Collating specific information (company name, contact person, phone number) for each processor. - Inputting the data into an Excel spreadsheet with consistent formatting. The ideal candidate should have: - Proficiency in web research and data entry. - Excellent attention to detail. - Strong Excel skills, with knowledge of maintaining consistent formatting. - Prior experience in conducting similar research would be an added advantage. The final list should be organized by state, with each entry clearly indicat...

I'm looking for an expert in data analysis to assist with a project in Excel. The data provided is well-structured and needs extensive examination to extract meaningful insights. Ideal Candidate Skills: - Proficient in Excel and its data analysis tools - Strong analytical abilities - Excellent understanding of data organization Deliverables: - Clear analysis of the structured data - Relevant insights extracted from the data - Detailed reporting on the findings This project is particularly suited to those with a keen eye for data and the ability to utilize Excel's functionalities efficiently. Thanks!

I am looking for a dedicated and detail-oriented data entry operator to assist with a large volume of data entry tasks. Key Responsibilities: - Typing, copying and pasting, data validation - Handling a large volume of entries Ideal Skills and Experience: - Proven experience in data entry - Expertise in handling large datasets - Proficiency with text documents (Word, PDF) and spreadsheets (Excel, Google Sheets) - Attention to detail and accuracy - Time management skills to handle large volumes of data

I need an Excel spreadsheet that allows me to input a starting point's latitude and longitude, a heading (in degrees), and a distance (in kilometers), and then calculates the new latitude and longitude based on a rhumb line calculation. This tool will be primarily used for navigation purposes. Key Features: - Input fields for starting latitude, starting longitude, heading, and distance (all in kilometers) - Calculation of a new latitude and longitude based on the input - Utilization of the Rhumb line formula for the calculation Ideal Skills: - Advanced Excel proficiency - Understanding of geographical coordinate systems and navigation - Experience with mathematical calculations in Excel - Prior experience in developing navigation tools would be a plus This proj...

I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.

I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management proces...

I'm looking to set up a Tiktok shop specifically for FMCG items. A single store for the specific grocery store. I am working with an Amazon seller so basically mirror their store and sell the same items on tiktok. Key Functionalities: - I need the shop to be linked to FBA (Fulfilment by Amazon) and the Amazon seller account. This is crucial for the timely and efficient delivery o...shop to be linked to FBA (Fulfilment by Amazon) and the Amazon seller account. This is crucial for the timely and efficient delivery of our products directly from the existing amazon seller. Ideal Skills: - Experience in setting up e-commerce shops on Tiktok - Proficient in managing and linking stores to FBA/Amazon store/Option to add other seller links. - Understanding of selling online and inventory...

need to websrapp amazon , flipkart and get current prices of sa list of laptop models on an excel sheet

...platform based in New Delhi, we're searching for a proficient accounting resource who's well-versed with Zoho Books, Zoho Inventory, and Zoho Analytics. Our primary goal is to establish an efficient and accurate bookkeeping system and provide training to our in-house team. Key Responsibilities: - Setting up Zoho Books: The freelancer should have a proven track record in setting up Zoho Books for e-commerce platforms. This includes configuring chart of accounts, integrating bank feeds, and setting up automations. - Setting up Zoho Inventory: Extensive experience in setting up and customizing Zoho Inventory for an e-commerce business is crucial. This will involve inventory optimization, SKU management, and order fulfillment streamlining. - Setting up...

...intuitive, comprehensive online exam system similar to that of IELTS. Key Features and Interface Requirements: - User registration and login: Prospective test-takers should be able to register themselves and log in independently. - Payment platform integration: Users should be able to pay directly on the website before taking the examination. -Ability to import questions and exam material from excel or csv - Exam result delivery: Post-exam, users must receive their scores directly presented as a percentage score on their screens and via email. Successful applications to work on this project should include past work that directly speaks to these requirements. Experience in developing online exam systems or similar educational platforms will be a strong advantage. A thorough...

...Brokerage website, grab financial statement data and inject that data into an Excel worksheet. Key Requirements: - The program should be able to access Fidelity Brokerage website. - It should grab financial statement data and inject it into Excel. - Specifically, the program should insert this data row by row into a Microsoft Excel Worksheet. - Each stock symbol which the program should enact on will be in one column - The data rows should be organized by having one row per stock symbol. Ideal Skills: - Experience in API and data extraction. - Strong proficiency in Python, VBScript or other programming languages suitable for this task. - Prior experience in creating Excel macros or programs that interact with Excel. - Knowledge of finan...

Extract data from pdf documents into an excel template. No software needed for the job. This is a complex project that requires accuracy and being organised. Must have strong numeracy and proven track record of attention to detail. Knowledge of European languages an advantage. We have over 100 files that will be allocated depending on ability and capacity. If you are interested please get in touch. Work will begin in April.

...Linux-based barcode printing application that supports both QR codes and 1D barcodes. The application must also be capable of importing data from Excel/CSV files. Key Components: - A Linux-based application: The application should be specifically designed to run on Linux operating system. - QR Codes and 1D Barcodes: The barcode printing application should support both QR codes and 1D barcodes. - Excel/CSV data import: The application should be able to import data from Excel/CSV files for generating barcodes. Ideal Skills: - Proficiency in Linux application development. - Experience with barcode generation and printing. - Ability to work with Excel/CSV data import. - Understanding of QR codes and 1D barcodes. If you have prior experience in developing sim...

...business and integrate the Telegram API into my system to enhance my customer service and inventory management. Key Points: - The integration should facilitate message sending and receiving, user authentication, bot creation, and linking the bot to my inventory system. - Real-time inventory updates are a critical requirement for this project. Ideal Skills: - Extensive experience with the Telegram API and bot creation. - Proven track record of integrating systems and ensuring real-time updates. - Strong understanding of customer service automation and inventory management. The primary goal of this project is to improve customer service through efficient communication and ensuring real-time inventory updates. A successful integration will help my bu...

I'm looking for an experienced programmer who understands MATLAB inside and out. Specifically, I need someone capable of optimizing a data analysis script. This script primarily uses arrays and matrices as its predominant data structures. It's crucial that you excel in: - MATLAB programming - Optimizing code for efficiency - Deep knowledge and understanding of working with arrays and matrices data structures If you are an expert with these requirements and have the know-how to streamline and optimize for speed and stability, your skills are highly valuable in this project. I look forward to reviewing your bid!

I'm seeking a Shopify assistant with a good design eye to manage several aspects of my store. - **Design Focus:** Your primary task will be customizing template layouts to ensure an appealing and coherent design throughout my Shopify store. You'll help maintain a consistent look and feel across all pages. - **Inventory Management:** You'll be responsible for creating, uploading, and editing new products. This will involve setting pricing, promotion terms, shipping rules, and ensuring accurate stock levels. - **Photoshop Skills:** Basic Photoshop skills for editing and optimizing images will be required. This includes making simple adjustments such as brightness and contrast. **Ideal Skills & Experience:** - Proficiency in Shopify store management and desig...

I'm seeking an expert in Excel who can efficiently merge two sets of numerical data sourced from different spreadsheets. Key tasks include: - Cleaning similar columns to create a unique identifier for perfect merging - Conducting statistical analysis on the merged data to find the mean, median, mode Ability to analyze data meticulously, professional experience in using Excel and familiarity with advanced statistical functions are essential for this project. Stringent attention to details is appreciated, as the data to be handled is delicate and the outcomes crucial. An understanding of data cleaning techniques in Excel would be an added bonus.

Proyecto de automatización con sharepoint, Excel, power automate y power bi

I am seeking an Excel expert capable of preparing a comprehensive document comprising more than 10000 rows and columns. The scope of the project involves processing substantial data sets, namely: Organizing Scanned documents and extracting the data, organizing the data in different corporations by department and years. Be able to extract a P/L and AR for all companies. Project is to be done in stages - Text - Numerical data - Date Information The ideal candidate for this job should have: - Expert knowledge of Excel and related functionalities. - Strong attention to detail. - Proven experience of data entry in large volumes. - Familiarity with basic mathematical operation functions within Excel. The deliverable will be a well-structured Excel document cr...

I need an expert to set up my WooCommerce dropshipping store with my chosen jewelry supplier. Key responsibilities: - Set up WooCommerce dropshipping store - Seamless integration with my chosen supplier - Enable automatic updates via API for efficient inventory management Ideal skills: - Clear understanding of WooCommerce and dropshipping - Experienced with API integrations - Specialization in jewelry eCommerce is a plus. I am looking for something fast, sleek, and robust, with a keen focus on making it both functional and appealing. Your proposal should include relevant previous work samples.

I need an expert to set up my WooCommerce dropshipping store with my chosen jewelry supplier. Key responsibilities: - Set up WooCommerce dropshipping store - Seamless integration with my chosen supplier - Enable automatic updates via API for efficient inventory management Ideal skills: - Clear understanding of WooCommerce and dropshipping - Experienced with API integrations - Specialization in jewelry eCommerce is a plus. I am looking for something fast, sleek, and robust, with a keen focus on making it both functional and appealing. Your proposal should include relevant previous work samples.

...3000 invoices (PDF files) from a server to my computer. I already have this task semi-automated in an Excel macro, but I want to do it easier. I need a tool (also in Excel/VB/Macro) where: - I'll write the day, month and year - I'll write the first invoice number and last invoice number that I want your tool to search - I'll hit a button "START" and your tool will search and download to my computer every invoices from that range that were issued on that specific day from an specific URL. The URL for these files is a standard URL. It's always an URL like this: The only part that changes is day, month, year and invoice number. Example: if I want to download any available invoices between numbers 5000 and 10000 that were issued on Febr...