Inventory excel macro vba jobs
I need a data entry clerk to help with a variety of tasks. The volume of work is small, up to 100 records. Key Responsibilities: - Typing and formatting various documents - Entering data into spreadsheets - Transcribing from audio or video recordings ...tasks. The volume of work is small, up to 100 records. Key Responsibilities: - Typing and formatting various documents - Entering data into spreadsheets - Transcribing from audio or video recordings Ideal Skills and Experience: - Proficient in typing and document formatting - Experienced in data entry, particularly into Excel - Familiar with transcribing from audio or video - Attention to detail is crucial The documents you'll be working with are in PDF, Word and Excel format. Please make sure you're detail-or...
I require a meticulous professional to help transfer text data from a series of printed documents into an Excel sheet. There's no special symbols or diagrams at all, just plain text. Ideal Skills and Experience: - Thorough understanding of Microsoft Excel - Attention to detail - Proven experience of working with printed documents - Excellent typing speed with the high level of accuracy The project needs to be completed accurately with consistency and timely manner.
I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with ...
...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be done professionally. If you...
...populate my spreadsheet with data about my inventory materials. I require this task to be handled meticulously, accounting for each item's product name, quantity, and SKU number. You'll source the required information from diverse locations including supplier catalogs, our existing inventory system, and handwritten records. Your ability to efficiently organize and sift through a variety of data sources would be key to your success in this project. No specific format is mandated for the spreadsheet. Whether it's CSV or Excel, as long as the data is accurate, consistent, and easily understandable, any format is acceptable. Ideal Skills: - Meticulous attention to detail - Expertise in data entry and management - Proficient with spreadsheets (CSV, ...
need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided
Hi Sir, I can create the macro as per instruction shared . Thanks Arun
I'm looking to have a website built that will serve as a platform to showcase our car inventory. This website is crucial for our business as it will be the central point for potential customers to peruse and get to know the cars we have on offer. Key Features: - The primary function of this platform is to showcase our car inventory. Therefore, the main focus should be on the design that will effectively showcase the cars in the best possible light. - I would like the website to have a user-friendly search and filter option. This is important as it will allow our clients to easily find the car they are looking for. - It's important that the site is designed to be responsive across various devices to ensure potential customers can access it no matter what device t...
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
As a client, I'm sourcing for a diligent and detail-oriented freelancer to assist me with a data entry project. The main requirement is to enter mixed numeric and text data accurately into an Excel sheet. The data will be provided in a mix of both structured and unstructured formats. In this regard, the ideal freelancer would be one capable of efficiently handling data in various formats such as CSV, tables, PDFs, and Word documents. Proficiency in Excel, data manipulation and an ability to sort through and understand different data structures are crucial for this job. Experience in similar data entry projects could be a significant advantage. This task will require meticulous attention to detail to ensure correct and precise input of data.
As an entrepreneur, I require an adept professional to transcribe my sales data, presently in the form of paper documents, into an Excel sheet for easier inventory management. Specifics: - Enter tangible paper sales data into a well-organized Excel spreadsheet - Skillfully input data to facilitate immediate analysis and reference - Maintain high meticulousness for precise data extraction Skills and Experience: - Solid experience in high volume data entry - Mastery of Excel and data organization - Keen eye for detail, accuracy and adherence to deadlines.
As an individual currently managing a project with numerous details and a profit loss statement, I need assistance with daily tasks for our Excel sheets. This will include: - Data entry and organization to streamline workflow - Basic arithmetic calculations for accuracy - Statistical analysis to make informed decisions - Formatting and visual presentation for clarity This role requires proficiency in Excel, a keen eye for details, and strong analytical skills. Experience in financial or project management is a plus. The job will be ongoing and requires daily attention. If your expertise aligns with these needs, please apply.
I'm in need of a diligent freelancer to assist with typing text data into an Excel sheet. Key Responsibilities: - Typing textual data into Excel sheet in an accurate and efficient manner Ideal Candidate: - Proficient in typing and data entry - Familiarity with Excel - Attention to detail
I am looking for a freelancer to help with Excel data typing. The purpose is to perform statistical analysis, specifically focusing on descriptive statistics. Ideal skills and experience: - Proficiency in Excel, particularly in data analysis and handling large datasets. - Strong understanding of statistical methods and experience working with descriptive statistics. - Attention to detail and ability to deliver high-quality, accurate work.
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
I'm looking for an expert in Excel to assist with a project involving data entry and analysis. The Excel sheet you'll be working on has more than 50 columns and rows and will contain a mix of text, numbers, and dates. You'll be responsible for the following: - Accurate and timely entry of the data provided - Ensuring the data is appropriately formatted and organized - Conducting thorough data analysis, including but not limited to trends, comparisons, and any other insights that can be drawn from the data The ideal candidate for this project should have: - Proficiency in Excel and experience with large data sets - Strong attention to detail - Ability to perform data analysis and present insights - Good communication skills to provide regular updates a...
I require a skilled professional experienced in data entry and Excel. The task necessitates numerical data entry, specific to tracking sales figures. - The ideal candidate will require skills and experience in: - Excel and spreadsheet management - Data entry with precision - Understanding of financial terms and figures particularly related to sales Please make sure you can handle large amounts of numerical data and maintain confidentiality of the sales information handled. Attention to detail is paramount for this task. Understanding of finance or sales is beneficial.
I'm on the lookout for a talented virtual assistant who thrives on lengthy hours of work and enjoys every second of it! This isn't your usual VA role, though - I'm seeking someone who can confidently handle the following responsibilities: - Social Media Management: More specifically, I need someone adept at Instagram. You'll be responsible for handling and managin...our audience. Ideal Skills and Experience: - Clear understanding of the Instagram platform and how to optimally engage audience in it - Skills in crafting Instagram worthy content - visuals, captions, and stories - Experience in managing professional instagram account is a plus - Must be organized, communicative, and able to handle long hours of work If this sounds like the sort of work you'd exc...
...our platform. This is essential to cater to our B2B target audience. - Efficient Inventory Management: Adequate inventory management is crucial to ensure seamless order processing. A Shopify expert who can streamline this process is highly desired. - Payment Gateway Integration: We are looking to integrate a variety of payment gateways to ensure a smooth transaction process for our customers. Ideal Skills and Experience: - Extensive experience with Shopify development, particularly in the area of website redesigns. - Strong understanding of e-commerce and B2B website requirements. - Proven track record of improving user experience and conversion rates. - Familiarity with payment gateway integrations and inventory management. If you have a portfolio that showcases...
More details: What is the purpose of the Excel sheet data typing project? Organizing data What kind of data will be typed into the Excel sheet? Numerical data What is the expected volume of data that needs to be entered? Below 500 entries
...adept at building and managing a Shopify e-commerce platform from beginning to end. This encompasses: 1. **Website Creation**: I need to have a custom, fully functional, user-friendly, and visually pleasing design. 2. **Deployment**: I require someone with experience in efficient website launching processes and managing all technical aspects. 3. **Publishing**: Seamless integration with my inventory for product listing and publishing is vital. 4. **Marketing**: The ideal candidate has expertise in marketing strategies focused on driving traffic to the site and increasing conversions. Ideally, the right fit for this project has extensive Shopify expertise, strong design instincts, and a background in e-commerce. They should understand online consumer behavior and be fam...
For this project, I require an expert who can efficiently extract text content from two distinct webpages and input my data into an Excel file organized by rows. Given that all types of data hold equal importance to me, of essence is for the professional to: - Accurately scrape all text content from the specified webpages - Ensure no data is skewed or omitted during this process - Neatly organize the data by rows in the Excel file The ideal candidate for this job should be proficient in web scraping tools and techniques, possesses an acute attention to detail, and is experienced in using Excel to ensure data is properly formatted and easy to analyze. Please note that minimizing errors during this process is critical, as the data collected will directly influence fur...
I'm seeking an experienced developer to build an e-commerce websi...must be able to select and save multiple products or services before deciding on final purchases. - Product Search: The platform should incorporate a quick and efficient search functionality to help users locate specific products or services. On the management side, I'll be directly overseeing product/service inventory. Therefore, it's crucial that the platform integrates easy-to-use inventory management features. Previous experience in creating such platforms, with integrated inventory management functionality, will greatly be prized. Coding expertise, in-depth understanding of e-commerce functionalities, and a keen eye for detail are a must. Interested freelancers with references to ...
I require data entry services to transfer numeric data from Word documents to Excel sheets. The ideal freelancer should have: - Excellent typing accuracy and speed, focusing on numbers. - Proficiency in Microsoft Word & Excel. - Previous data entry experience, particularly with numeric data. - Ability to interpret data from Word documents. - Strong attention to detail. Responsibilities include: - Extracting number data from Word documents. - Accurately entering data onto an Excel sheet. - Cross-verifying accuracy of entered data. This is a valuable task for my project and I'm seeking a meticulous, efficient professional who can assure the most accurate transfer of data.
...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...
I require a freelancer to type text data into an Excel sheet from printed documents. Scope of work: - Convert printed text documents into digital format via Excel - Ensure data is accurately entered The project does require specific formatting: - Data should be arranged in rows Ideal candidate: - Must have proficient Excel skills - Experience with data entry - Attention to detail, to ensure accuracy in work - Able to follow specific instructions for data organization
...tenure, salary and location of our employees. Your ability to structure and organize these aspects will be key. - Creating an Excel-based system: I'm looking for a dashboard that's easy to dissect and understand. As such, I'd like the final product to be in Excel spreadsheet format. This means you should be very proficient in Excel, knowing how to integrate formulas, tables and other relevant features. - Monthly updates: The dashboard should be designed to be updated monthly. You should be dedicated to ensuring that the data is up-to-date and accurately represented. Ideal freelancer should have: - Proven experience in HR analytics and dashboards - Excellent Excel skills - Ability to present complex data in a clear and concise manner - Strong...
I have an excel sheet with intermediate complexity data, including formulas and charts. I need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accur...
I am looking for an experienced interface developer to create and implement a real-time synchronization system between the Amazon SP API and Google Sheets. Ke...looking for an experienced interface developer to create and implement a real-time synchronization system between the Amazon SP API and Google Sheets. Key Responsibilities: - Create an integration for inventory management, using Amazon SP API and Google Sheets. The candidate must ensure up-to-the-minute data accuracy. - Develop and manage product listing and catalog management on Amazon SP API, synching this with Google Sheets in real time. Skills & Experience: - Proven experience with Amazon SP API - Expertise in Google Sheets and real-time data synchronization - Strong understanding of inventory and catalo...
...looking for an Excel expert who can create a comprehensive sales target tracking spreadsheet for my customers. This spreadsheet should have several key functionalities. Features Needed: - Customer Information: It should contain a section where I can input and maintain all my customer's details. - Sales Tracking: The spreadsheet should enable me to track my sales targets daily and provide a detailed analysis of my performance. - Target Achievement: The spreadsheet should also be able to analyze the achievement or shortfall of selected items target completion by each customer. Analysis Required: - I would love to have a feature that shows how well sales targets are being achieved as per defined targets. Ideal candidate should have great attention to detail, proficiency...
I need an organized mind to help with research and data entry of a list of companies in a specific industry. Your main responsibility will be organizing this data. While basic Excel skills are a must, experience with data organization, particularly in a business context, would be highly beneficial. The data will be divided into 4 separate categories, so whoever takes on this task needs to have a keen attention to detail and an understanding of categorization. This project is perfect for an individual who thrives in organizing and systematizing data.
**Tour Costing Sheet Structure** 1. **Tour Details** - Tour Name - Tour Code - Duration - Destinations 2. **Client Information** - Client Name - Number of Adults/Children - Contact Information 3. **Accommodation** - Hotel Name - Room Type - Meal Plan - Cost per Night - Total Nights - Total Cost 4. **Transportation** - Vehicle Type - Distance - Cost per Kilometer - Total Cost 5. **Sightseeing and Activities** - Activity Name - Per Person Cost - Number of Persons - Total Cost 6. **Miscellaneous Expenses** - Guide Fees - Entrance Fees - Other Expenses 7. **Pricing** - Subtotal (Sum of all costs) - Markup Percentage - GST (Goods and Services Tax) - Final Price 8. **Payment Details** - Deposit Require...
I require a proficient freelancer to assist in data entry from printed documents into an excel sheet. You'll also need to arrange this content meticulously within columns and rows. Your responsibilities will include: - Accurate transcription of data from printed material - Effective organization of the data by columns and rows in Excel The perfect candidate for this job is someone with outstanding data entry skills and a keen eye for detail to ensure accuracy. Experience working with Excel and translating printed documents is a necessity. Accuracy, speed and confidentiality are vital.
...currency, offering a seamless shopping experience for my customers. - **Inventory Management**: I prefer an integration that can hide out of stock products from my store. This maintains a clean and updated product catalog. - **Order Fulfillment**: I intend to only allow customers to order product variants that are available on Shein. The integration should disable the purchase option for variants that are not available. Ideal Candidate: - **Shopify and Shein Experience**: It's crucial that the freelancer has prior experience working with Shopify and Shein integrations. - **API Proficiency**: A strong command over API development and integration is required for this project. - **Inventory Management Skills**: Experience with inventory management systems and str...
I'm seeking a detail-oriented professional to manually transfer valuable ...detail-oriented professional to manually transfer valuable data from Internet sources to an Excel spreadsheet. The ideal candidate for this job should have: - Proven experience in data entry and Excel - Excellent attention to detail and accuracy - Flexibility in terms of formatting as you will have to determine the most effective and efficient structure for the data The challenge of this task lies in manually extracting data from the web, an eye for detail is, therefore, paramount. Your responsibility is to ensure all the data is correctly entered and organized in a clear and comprehensible manner. Your creativity and critical thinking are appreciated when deciding the layout and formatting...
I'm looking for a freelancer to help with a simple Excel data entry task, as well as some basic formula work. I have a spreadsheet that primarily contains numbers. Your role would be to accurately type this data into the sheet, ensuring that every entry is correct and in the right format. This task is meant for particular record-keeping purposes, so precision and attention to detail are crucial. In addition to the data typing, I need some basic Excel formulas applied. Experience with Excel and knowledge of formulas is essential to ensure the data is well-organized and easy to work with. This task is not overly complex but will require someone who is proficient with Excel's formula functions.
I'm looking for a Python script that uses PyAutoGUI to control keyboard inputs, with a specific focus on interacting with a Firefox web page. I am open to creative ideas on how to do this differently then I have described below. Key Requirements: This is basically like a macro, or autohotkey, (if you do a gui then I can determine the winner as soon as whoever finishes first with working code, wins. The gui for the python code is up to you but maybe it could work well if I can have section one establish focus on right scrolling panel and ignore the left panel. Second section: because this is sendkeys basically we will use the keyboard to navigate. A text box stating how many tabs until we get to the first web object button to select, Then a second text box to state how man...
I'm seeking a freelancer who is adept at typing for a task that involves transcribing handwritten notes into Excel. The legibility of the handwriting is average, so this job demands patience, careful observance, and excellent data entry skills. - Your task would be to transcribe the data from handwritten notes into an Excel file. - The content you'd be dealing with primarily includes text. I'd prefer individuals who have previous experience in data entry, especially tasks that require extracting data from handwritten sources, and are proficient in using Excel. Attention to detail is a must, as accuracy is paramount in this job. Your ability to decipher moderately legible handwriting would be a great advantage. Please bring a keen eye for detail, and ...
I'm looking for an experienced web scraper to access and download specific information and images from the Used Inventory section of the White Rock Honda website. Here are the specifics of what I need: - Car make and model - Year of the car - Price of the car For each car listing, I need ALL available images downloaded. Furthermore, I require the images in JPG format. Candidates applying should have successful experience in web scraping, data extraction, and handling myriad images. Efficiency and accuracy are critical for this project.
I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completi...
I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!
I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO
...implement accounting reports in Odoo saas~16.3+e (Enterprise Edition). The reports should be exportable as XLSX or CSV files. Required Reports: 1- Account Payables Display tabs for each supplier. Information on invoices issued, quantity, and payment dates. 2-Inventory Summary Display existing inventory as of a specific date. Price and cost information. 3-Sales Tax Display total sales within a specified time period. Consider both taxed and untaxed sales. Additional Features: *Ability to specify dates for the report results. Example: For the "Inventory Summary FEB 2024" report, be able to search for results for January or other previous months. Access and Meeting: Upon project acceptance, access to our Odoo system will be provided. A video call will be re...
I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
...should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the given fr...
I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I'm launching a small startup and I need a Shopify website. My primary goal with this website is t...small startup and I need a Shopify website. My primary goal with this website is to sell physical goods. The project will involve: - Setting up a user-friendly e-commerce Shopify website - Customizing the website's theme to match my brand's style and message - Ensuring the website is mobile-responsive and easy to navigate - Integrating essential e-commerce features such as payment processing, inventory management, and customer reviews I'm looking for a web developer with experience in e-commerce and specifically in creating and customizing Shopify websites. Experience in UI/UX design and a good understanding of branding will be a plus. Please include your Shopi...
I am in need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - Expertise in Amazon SEO and PPC ads, with a specific focus on product listing optimization. - Experience ...listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to optimize listings. Through these efforts, the ultimate goal is to increase the visibility of my coloring books on Amazon, targeting a better ranking in search results, and thereby improving sales. If you have the skills and experience to excel in this role, I would be thrill...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
