Vba macro excel inventory jobs
I'm in need of someone who can assist with data validation and verification tasks in Microsoft Excel and help with managing payroll. Key Responsibilities: - Data Validation and Verification: This involves assessing the data's accuracy, completeness, timeliness, and consistency. Proper validation ensures that our records are reliable and correct. - Payroll Management: This task involves ensuring that all employees are paid correctly and on time, calculating wages, tracking work hours, and making necessary deductions. Experience in payroll systems or software is a plus. Ideal Skills: - Proficiency in Microsoft Excel - Experience with data validation and verification - Previous payroll processing experience - Attention to detail and accuracy in data entry - Strong or...
I require a freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong atte...freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong attention to detail - Data categorization - Data verification - Data conversion The applicant should be proficient in Excel, CSV, and PDF. This role is likely to involve handling various types of data, so versatili...
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...
...looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and r...
I need a freelancer to google search email addresses (also few addresses which are missing) & copy paste in to an Excel sheet. Need approximately 800-950 records done in 1 day. Will go with the lowest bid.
I require a freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong atte...freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong attention to detail - Data categorization - Data verification - Data conversion The applicant should be proficient in Excel, CSV, and PDF. This role is likely to involve handling various types of data, so versatili...
Excel sheet pahun tuze Mark chukale asle tar por pathvin hai na ki tu khana kha liya ky
I'm in urgent need of an experienced thumbnail creator to generate striking, ...experienced thumbnail creator to generate striking, vibrant thumbnails for various platforms such as YouTube, websites, and social media. *Style and Theme* Your designs should exude a colorful theme that's enticing and eye-catching. *Thumbnail Content* Each thumbnail should have captions incorporated in the design. The text should be readable without distracting from the overall appeal. To excel in this project, you need to be a skilled designer with a knack for creating visually stunning and colorful thumbnails. You should also have practical knowledge of designing for different platforms, and understand how to incorporate text seamlessly into your work. Past experience in a similar role w...
I'm seeking a Unity 3D programmer to help me seamlessly connect several key game systems. The project involves integrating the following: - **Skills System**: This is primarily managed through an existing asset from the unity asset store which forms the basis...future npc creator system) if budget is enough npc creator menu Also if possible i would like to help with this proyect and pay per hour if you have a desired rate per hour i want to know it . Ideal skills and experience for this job include: - Proven experience with Unity 3D, particularly in integrating game systems - Familiarity with AI programming and NPC interactions - Understanding of inventory management in games Please demonstrate your relevant experience and provide a clear overview of how you would approac...
I am looking to innovate my paintshop's inventory management by implementing a QR Code system. The system will involve each paint tin being assigned a unique QR code, which will be printed onto a sticker. This QR code will have the product name and product code printed underneath it. Key Tasks: - Generating a unique QR code for each paint tin - Printing the QR code and product details on a sticker in color - Ensuring the QR code can be scanned by mobile devices - Ensuring the product name and code are prominently displayed - Ensuring the stickers are durable and able to withstand the paintshop environment This system will serve a few purposes: - Tracking Consumption: Our staff can scan the QR code when they use up a tin, allowing us to track consumption in real-tim...
I'm seeking an Excel expert to help with a data analysis project. The spreadsheet is set to a high level of complexity, requiring a mix of data analysis and data cleaning tasks. Key Tasks: - Data Analysis: I need someone who can set up the spreadsheet as a dashboard, and perform data analysis tasks. - Data Cleaning: You need to handle the data cleaning part of the project. This involves removing duplicates, handling missing values, and standardizing data formats. The ideal professional for this job will be experienced in: - Advanced Excel functions, including data analysis and building dashboards. - Proficient in data cleaning techniques. - Able to work with complex data sets. The project will require attention to detail and a high level of accuracy. If you have the r...
I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus
I have a data entry task that involves inputting text data into a digital format (e.g., Excel, Word). The primary goal of this task is record keeping. Key Points: - Data Type: The task involves handling text data only. - Data Source: The data will be provided in a digital format. - Task Goal: The primary objective is to maintain records in a systematic way. Ideal Freelancer: - Proficient in Text Data Entry: The ideal freelancer should have experience with accurately and efficiently entering text data. - Familiarity with Excel/Word: Proficiency in using Excel and Word is necessary for the task. - Attention to Detail: Given that the task involves record keeping, the freelancer should have good attention to detail to ensure the accuracy of the entries.
I'm in need of a professional who can build a tool that scrapes product data from Walmart and exports it into an Excel spreadsheet. Key Requirements: - Develop a web scraping tool specifically for Walmart website - Extract essentials (price, upc, title) Skills and Experience: - Proficiency in web scraping using Python, Scrapy, or similar tools Please let me know your availability and estimated time for completion. This is an urgent project, so a quick turnaround would be highly appreciated.
I'm looking for an experienced professional to create a user form macro in MS Project Professional. The macro should have the following capabilities: The key functionality that the macro should have is the ability to filter the project based on selected criteria in the user form, including: - Project Phase: This is a custom field, or Text1 - (And) Work Phase: This is a custom field, or Text6 - (And) Custom Look-Ahead Formula's for 15, 30, & 60 day look-aheads. See attachment but the end user will select one of the three look-ahead options. For the Look-Ahead formula, it should be defined as: IIf(([Start]<([Status Date]+15, 30, or 60) And ([% Work Complete]<100))). It's extremely critical that the candidate has strong proficiency and unders...
I have a real estate development company, and I'm looking for a dedicated Excel expert to help me streamline my expense tracking process. Key Requirements: - I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab. - The data should be ordered by date to ensure clarity and easy reference. - I have created a macro to change the debit figures to negative amounts in the spreadsheet. - I am open to changes/ideas on if it requires a different setup. Ideal Skills and Experience: - Advanced Excel skills are a must. You need to be comfortable working with complex formulas to manipulate data. - Experience...
I'm seeking help with creating line charts in Excel. My dataset is small but involving multiple data series. Requirements: - Generate line charts from provided multi-series data - Ensure the charts are clear and visually engaging - Basic understanding of trendlines and data labels would be a plus, though not mandatory Ideal Skills: - Proficiency in Excel, with a focus on charting - Prior experience working with complex, multi-series datasets - Strong attention to detail and an eye for creating visually appealing charts
I'm in search of a robotics expert with advanced experience in working with Vex V5 parts. The goal of this project is to build a robot that strikes the right balance between speed and strength, specifically for a high school robotics competition. Key Responsibilities: - Building a competitive robot that can excel in a high school robotics competition - Optimizing the robot for a balance between speed and strength Ideal Skills: - Proficiency in working with Vex V5 parts - Previous experience in high school robotics competitions - Strong understanding of robot design principles Communication for this project is crucial, and I would prefer to have in-person meetings to discuss progress and updates. Please consider that you must be able to meet in person in Connecticut west ha...
...bank transactions from PDF format into a spreadsheet. My accountant needs this data to be organized and easily accessible. Tasks for the freelancer include: • Extracting transaction information from my downloaded PDF bank statements • Compiling this data into an Excel spreadsheet • The project will need to include the date, transaction description, transaction amount, resulting account balance, and transaction category The ideal candidate needs: • Strong attention to detail • Proven experience working with both PDF and Excel files • Fluent in English for effective communication Expectations: • Maintain rigorous data accuracy • Finished product will closely replicate the information found in the original bank statements using...
As a small organization, we are delving into Odoo and seek expertise in its full implementation. We n...Development: Adapting Odoo to fit our unique business requirements. Not just basics, we need significant customization, especially within modules tailored for CRM, Accounting & Finance, Point of Sale, and Inventory. - Training and Documentation: Our team is fairly new to this, hence we count on your descriptive training sessions and comprehensive documentation to bolster our in-house competencies. Your affinity with small-sized teams and hands-on experience in extensive Odoo development and customization will make you the perfect addition. Familiarity with CRM, Accounting & Finance, Point of Sale, and Inventory modules is a must. Join us to make our Odoo journey ha...
I need an expert to create a comprehensive Excel report and sheet using the 7QC Tool. The main purpose of this project is to analyse process data, identify quality problems, and improve process efficiency. Key Project Details: - The Excel report and sheet should incorporate data analysis, financial calculations, and performance metrics. - The type of data to be stored in the Excel sheet will be sales data, employee information, and inventory records. The ideal freelancer for this job will have a solid understanding of the 7QC tool, advanced Excel skills and knowledge in data analysis. Experience with managing sales data, employee information, and inventory records within Excel is highly beneficial.
Looking for someone to engineer a shared to-do spreadsheet in Microsoft Excel that supports real-time collaborative editing for our team. The successful candidate should have: * Advanced Excel skills; * Experience creating custom spreadsheets for project management; * Understanding of user permissions in Excel with the aim to allow full control access to every team member; With your help, we'll revolutionize how we tackle tasks as a team. The ideal freelancer for this project should be prepared to propose and implement a solution promptly. Familiarity with Microsoft Teams is a plus.
I'm seeking a reliable freelancer to import vendor pricing data into Sage. The data is currently stored in a CSV formatted Excel spreadsheet, with data cleaning required prior to import. The project will entail: - Cleaning the vendor pricing data as required - Successfully importing clean data into Sage Ideal Skills: - Proficient in Excel and its functionalities, especially CSV format - Experience in data cleaning - Demonstrated proficiency in Sage, particularly in data import functions - Attention to detail is crucial for this task This task requires a freelancer with the right blend of skills in Microsoft Excel and Sage software to ensure smooth, error-free integration of vendor pricing data.
I'm seeking a skilled Excel developer to help me create a tracking system. Key Requirements: - The system should monitor the month over month membership growth for our community PCPs. - The PCP targets should be identified by name and location. Please note that this needs to be completed as soon as possible. Ideal skills for this project: - Strong proficiency in Excel and data tracking - Experience with creating dynamic systems in Excel - Attention to detail to ensure accurate tracking This will be a key tool for our organization moving forward, so I'm looking for a freelancer who can deliver high-quality work efficiently.
The report will consist of the following tasks: 1. Identify and justify your chosen global target market and present a market analysis that identifies the macro and micro trends and issues that are currently facing the industry in which your organisation operates and how these relevant factors may impact your market sector. 2. Evaluate and align the organisation’s current approach to expand and operate in relation to at least one competitor. 3. Propose, with justification a customer value proposition supported by academic theory/frameworks for the business strategy for your new ethical product, service, brand extension that addresses one or more of the identified global trends or issues. 4. Create an original customer persona for a specific, sustainable target segment, outlini...
I'm looking for a freelancer to create a line graph in Excel. This graph will be utilized for report analysis, showcasing the trend for a single data set. Key Responsibilities: - Develop a line graph in Excel - Present the data trend effectively - Ensure the graph is tailored for report analysis Ideal Skills and Experience: - Proficiency in Excel, particularly in creating graphs - Prior experience in crafting visuals for reports - Ability to convey data clearly and effectively This project specifically does not entail comparing different data sets, as it solely focuses on illustrating the trend of a single set. The ideal candidate will deliver a polished graph that can be seamlessly integrated into a report.
I'm looking for experienced web developers to build an e-commerce website for my business. Here's what you need to know: - Purpose: The main goal of the website is to sell my products online. I plan to list between 100 to 500 different items, so the website should be able to accommo...difficulties. - Functions: The website must include a shopping cart and a payment gateway. These features are essential to the operation of my business as they will allow customers to make purchases directly from the site. Ideal Skills: - Experience with e-commerce web development, specifically with shopping carts and payment gateways - Knowledge of best practices for listing and managing a large inventory of products If you have these skills and experience, I'd love to hear from you...
Need an Excel expert to create a complex forumula to get desired results from big set of data. Budget is placeholder/estimate. final amount will be discussed during work.
...assistance in incorporating 2D Data Matrix barcodes within both BI Publisher and Oracle EBS. The primary goal of this integration is to enhance our current inventory tracking systems by printing the Labels with 2D barcode and business users can scan the barcode by using the RF scanner in the inventory. This project should be relatively straightforward for someone who is proficient with BI Publisher, Oracle EBS, and barcode implementation technologies. Key requirements and considerations include: - Proficiency in both BI Publisher and Oracle EBS - Strong understanding of 2D Data Matrix barcodes - Proven experience in integrating barcodes into inventory management systems The successful candidate will be able to not only implement the barcode system but also provide...
I'm looking ...Assistance in setting up a new store, ensuring it's user-friendly and optimized for sales. - Inventory management: Teach me the best practices for handling and tracking inventory. - SEO knowledge: I'm also in need of basic SEO training to make sure my store is discoverable online. I'm at an intermediate level in my understanding of drop shipping and need someone who can provide practical, hands-on guidance on these topics. The tutoring sessions should be flexible, as I may require more or less frequent sessions based on my requirements and progress. Ideal Skills and Experience: - Proven experience in drop shipping and eCommerce. - Strong understanding of supplier management, online store setup, inventory control, and SEO. - Previou...
...steel pipes, valves, pumps, and spare parts for inventory management. Key Responsibilities: - Source and purchase a variety of steel pipes, valves, pumps, and spare parts - Prioritize cost efficiency while maintaining quality standards - Ensure items are delivered through standard shipping Ideal Skills: - Proficiency in procurement and supply chain management - Strong negotiation skills for cost-effective purchases - Knowledge of industrial materials, particularly steel pipes, valves, pumps, and spare parts - Experience in inventory management and maintaining stock levels Your goal will be to secure these items at the best possible price without compromising on quality. The right candidate will be able to maintain a steady flow of inventory, thus ensuring we have...
I'm in need of a skilled developer to create a web-based accounting app mimicking functionalities of excel for my business. Key Features: - Accounting functionality: This app must allow me to insert product details and their price, record the amount they were sold for, and at each day's end, it must generate a profit and loss table. - Inventory tracking: The application should effectively manage my inventory, keeping a track of products, their quantities, and changes over time. - Customer Database: The app should store customer information in an organized and easily accessible manner. - Invoice Generation: It should also have the capability to generate invoices for customers. Design Aesthetics: The preferred design is minimalistic. It must be clean, clear ...
I'm seeking a skilled professional to develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN a...
...preferences, and purchasing decisions. It then lays the foundation for meaningful interpretation and analysis of empirical research. 2. To explore the attitudes of thrift store customers towards purchase and return procedures, inventory management, and loyalty programs This objective is based on finding out the customers' opinions based on the observations of this segment from qualitative research methods. This enables the thrift shops to identify their customers' perceptions and attitudes towards many operational aspects such as check in and out procedures, inventory management and consumer experiences so as to rectify weak links and take advantage of the highlighted strengths. Customers' views on the service provided are the key to improving the quality of...
I have multiple Excel spreadsheets containing contact information, and I need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement V...
We are currently looking to add several Virtual Assistants (VA) to our team who can assist us with various tasks, including social media posts, research, data entry, and more. We are seeking individuals with a strong background in data entry, Google Drive/Sheets, and similar responsibilities, as outlined in our LinkedIn ...Key qualifications and requirements for the role: - Proficient in data entry and experienced with Google Drive/Sheets. - Demonstrated reliability and consistency in previous roles or projects. - Strong attention to detail and organizational skills. - Ability to meet deadlines and perform consistently in an ongoing work environment. If you believe you possess the necessary skills and qualities to excel as a Virtual Assistant with our company, we would love to hear...
As discussed I have delivered the excel workbook. Thanks!
I'm in need of a professional who can build a tool that can extract data from LinkedIn. The data I'm interested in includes: - Contact information (email address, phone number, etc.) - Profile information (name, job title, etc.) - Connection network (connections, mutual connections, etc.) I'd like the extracted data to be conveniently structured in a CSV (Excel spreadsheet) format. The primary use of the extracted LinkedIn data will be for lead generation. The ideal candidate for this project should have: - Expertise in web scraping and data mining, particularly with LinkedIn - Proficiency in data handling and structural organization - Proven experience with developing tools for lead generation - Strong communication skills and a good understanding of client nee...
...enhancing customer service, and ramping up overall efficiency. - Objectives: We're eagerly seeking someone who can adeptly integrate MS Dynamics Field Service into our pre-existing systems. This step is important in achieving our above goals. - Required Functionalities: The necessary functionalities needed from MS Dynamics Field Service include work order management, resource scheduling, and inventory management. - Current Systems: Our existing infrastructure includes a CRM and ERP system which will be part of the integration process. The ideal candidate for this task would be experienced in system integrations, particularly with MS Dynamics Field Service and familiar with CRM and ERP systems. The ability to work efficaciously to improve operational streamline, enhance th...
We are an Ecommerce company dealing with variety products and we are looking for a...Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have sufficient experience in Social Media Ads and ...
...high-resolution image gallery that can display my pieces in the best possible light. This is non-negotiable. - Inventory Management: I'm currently unsure of what would be the best approach for managing my inventory. Perhaps you can recommend the most suitable method based on the nature of the products I'll be selling. You should have: - Proven experience with Shopify, with a strong portfolio to showcase your previous work - A keen eye for design and aesthetics, especially in the context of an art-centric store - Good communication skills to understand my needs and translate them effectively into the store - Ability to provide guidance and recommendations, particularly in the realm of inventory management Please apply if you feel you can deliver a store ...
I'm in need of an experienced web developer who can help us launch an e-commerce website as soon as possible. We're lookin...project, we need someone who can commit to working on it promptly. Design and Platform Suggestions: - Design Features: I'm looking for specific design features to be incorporated into the site, including custom product filters, advanced search functionality, and interactive product views. - Integrations: You'll need to be able to integrate various third-party services such as payment gateways, inventory management systems, and shipping carriers into the website. Your input is also highly valued. If you have any suggestions for platform enhancements, design innovations, or any other features that could benefit our e-commerce site, please ...
I'm in need of an efficient virtual...tasks will be necessary. - Artwork Creation: A crucial aspect of the role will involve creating graphics for social media. A good eye for design and proficiency in relevant design software will be highly valued. Ideal Skills and Experience: - Proficient in data entry automation software and able to manage a variety of data formats effectively. - Prior experience with Shopify, especially in basic inventory and order management, will be beneficial. - Proven experience in graphic design, particularly for social media, is essential. Familiarity with relevant design tools is a must. The candidate should be organized, detail-oriented, and able to work independently. Effective communication skills are a plus. A creative flair and an eye for desi...
You need to build a power app for a business process of onboarding, offboarding customers. There is a data...customers. There is a database of the customers with specific users db that has access and approve a checklist. We need it on a sharepoint portal and emails are automated for every action. It is a simple process of adding a user, give them a checklist, customer completes all actions, there is an internal admin who confirms the checklist and there is a progress to track. Will provide a dummy of excel sheet, expect 3-5 screens across onboarding, offboarding, admin and customer login. Ideal Skills: - Proficiency in Power Apps, Microsoft Power Automate. - Expereince in MS dataverse, power platform - Ability to grasp business processes and convert them into efficient digital ...
I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.
We are seeking a Business Data Analyst for our team who is willing to work with... Responsibilities: - Collect and analyze data from various sources - Identify patterns, trends, and correlations in datasets - Create reports and dashboards to present findings - Collaborate with cross-functional teams to understand business requirements Required skills: - Strong analytical and problem-solving skills - Proficiency in data analysis tools such as Excel, SQL, or Python - Experience with data visualization tools such as Tableau or Power BI - Excellent communication and presentation skills This is a great opportunity for individuals who are new to the field of business data analysis and are looking to gain practical experience in a supportive en...
