Inventory vba excelงาน

I need a talented and experienced designer who can help me execute an extensive redesign of my Canva project. Ideally, you should have excellent skills in working with Canva and a keen eye for aesthetics. Specifically, the project will involve: - Text modifications: The font style will have to be changed while al...- Image replacements: Replace existing images with those I will provide. Skills and Experience: - Proven experience in managing Canva design projects - Excellent eye for detail - Strong graphic design skills - Good understanding of fonts, colors and layouts - Excellent communication skills to understand and translate my vision into the project design If this sounds like a project you can excel at, I invite you to place your bid. I look forward to seeing your ama...

I'm looking for a skilled professional who can create a VBA solution in Excel that can interact with a MySQL database. The system should be able to perform the following CRUD operations: Insert, Select, Update, and Delete. This will be a continuous requirement. Key requirements: - Proficiency in MySQL and Excel VBA - Strong understanding of SQL ODBC connections from Excel VBA - Ability to deliver the project within timelines. Your main task would be to create a reliable, easy-to-use, and efficient system to automate the specified database operations from Excel. In addition, the final solution should be well-documented for future reference. If you have experience in similar projects and can commit to the timeline, I'd love to he...

...servicing, maintenance schedules, and any upcoming service requirements. - Inventory Management: An essential component of the software would be the ability to manage and track equipment inventory, including stock levels, procurement, and storage. - Service Request Tracking: The software should have a comprehensive system for users to log service requests, track progress, and receive updates on the status of their requests. Integrations: - Equipment Database: The software should be able to integrate with an equipment database, to facilitate seamless data interchange. - Email Notifications: Integration with email notification systems would be essential to keep users informed about upcoming service appointments, inventory changes, and other relevant information. - Ca...

I have less than 10 columns of text and numbers data, currently in scanned documents that need to be accurately typed into an Excel sheet. I am looking for someone highly detail-oriented with: - Proven experience in data entry or similar roles - Excellent typing speed and accuracy - Proficient in using Excel - Experience in digitizing scanned documents is a plus Responsibilities include: - Typing text and numbers data from scanned documents into Excel accurately - Ensuring no data is missed or misrepresented - Completing project within the agreed deadline. Looking forward to working with a diligent and efficient freelancer.

I am looking for an experienced individual or team to create an e-commerce store that strictly sells physical products. This digital marketplace should be user-friendly for both myself (as the admin) and for customers. The critical requirements include: - High functionality in organizing and listing the varied inventory - A seamless and secured checkout system - An easily manageable back-end for edits, additions, and removal of products - A comprehensive tracking system for orders I need the project completed as soon as possible. Ideal skills: - Experience in building and maintaining e-commerce stores, specifically for physical products - Proficiency in platforms like Shopify, Magento, WooCommerce, or similar - Strong understanding of UI/UX principles - Mastery in SEO and product...

I need assistance to convert an Excel file into the RES2DINV software for the purpose of visualizing and interpreting my data. The Excel file's content type isn't specified but it may contain geophysical measurements, soil resistivity, or survey data. This turnaround for this task needs to be as soon as possible. Ideal skills and experience: - Proficiency in utilizing RES2DINV software - Strong understanding of geophysical data interpretation - Experience in data conversion from Excel to RES2DINV - Ability to work on tight timelines.

I am in need of an Excel expert who can create a formula that will allow for real-time updating across multiple sheets. This formula should automatically transfer all inputs from sheet one to both sheet 2 and sheet 3. Key requirements: - Expertise in Excel and formula creation - Experience with real-time data updating in Excel - Ability to automate data transfer across multiple sheets The assignments from sheet 1 should appear as the words written and not "assignment" in the weekly and monthly calendars.

I need a straightforward internal order confirmation system to streamline the purchasing process and manage inventory. The ideal system for me would: - Create weekly order templates when at office - Open ordertemplate and write in customer and order - Generate automatic emails and printable PDF documents for order confirmations - Include detailed information in the confirmations such as products, quantities, prices, and customer's name and contact details - also save order on webserver in text file or database - installation on internal webserver See example of weekly order See order Freelancers with experience in inventory management systems and programming automatic emails would be a good fit for this job. Strong knowledge in creating PDF documents will be

I have a...developer to integrate a back-end using MongoDB. The tasks that need to be accomplished are: * User authentication * CRUD operations (Create, Read, Update, Delete) * Data filtering and sorting In addition to integrating these functionalities, I also need assistance with the design of the admin panel. The intention is that this panel will help to manage site content, user accounts, and product inventory. Optimal skills and experiences for this project: * Proficient in and MongoDB * Experience in designing admin panels * Familiarity with handling user authentication and CRUD operations * Knowledgeable in data filtering and sorting If these skills align with yours, and you have a knack for balancing functionality and design, I look forward to our potential collaborati...

I'm in need of an expert web scraping developer who can extract textual data from specific Wikipedia pages. This should be a one-off task as there is no requirement for handling updates or changes to these particular pages. Key specifications: - Targeted content: Textual data - Pages to scrape: Specific, to be provided Ideal skill...one-off task as there is no requirement for handling updates or changes to these particular pages. Key specifications: - Targeted content: Textual data - Pages to scrape: Specific, to be provided Ideal skills and experience: - Proven expertise in web scraping - Previous experience with Wikipedia or similar tasks preferred - Ability to deliver accurate data in a structured format such as CSV, Excel, etc. Please avoid any unnecessary or redunda...

I am in need of a personal assistant to professionally handle phone calls, answer emails, and meticulously track rental payments and expenses for 6-10 rental propertie...some responsibilities of a bookkeeper; hence, an understanding of and experience in basic to intermediate accounting is highly preferred. Key duties will involve: - Efficient management of rental properties - Timely tracking and recording of rental payments - Accurate accounting of expenses - Handling telephone and email communications A candidate with skills and experience in these areas will excel at this role: - Bookkeeping - Accounting (Intermediate level) - Property Management - Communication. For my peace of mind and the smooth operation of the rental properties, a meticulous, detail-oriented individual ...

I'm looking for an Excel expert who can modify the pricing formula and user interface of my existing price calculator. It is a very basic lookup, with quite rudimentary discounts that need to be applied, and we have a working example to share which you can backsolve how to build/update as needed. Here are the specifics: 1. Update the lookup to a new pricebook tab (Both current, working example, and new example with the new price book will be shared) 2. Introduce new add-ons tick list on the calculator (basic calculations (percentage of total, and fixed price) 3. Build out a visual display of a basic discount matrix (10%, 20% etc - this will be supplied) $. User Interface Improvement: - The updated calculator should still be user-friendly and intuitive. - Experience ...

I am seeking an expert in Excel to conduct comprehensive analysis on collected customer feedback, aiming to evaluate customer satisfaction. The raw data is currently stored in Excel spreadsheets and it essentially contains the comments and feedback from our customers. Key Responsibilities: - Deeply analyze the comments and feedback - Identify patterns, trends and vital points from the feedback - Importantly, provide a detailed report on these findings to aid further business decisions Ideal candidate must have: - Proficiency in Excel data analysis tools - Past experience in feedback analysis - Understanding of consumer behavior - Excellent reporting skills.

I'm looking for an expert to convert my existing Microsoft Excel Macro into a Google Sheet function with some added enhancements. The key enhancement is auto sorting on the newly created worksheets. The sort should utilize multiple columns, each with a unique order, either ascending or descending. Indispensable Skills: - Proficiency in Excel and Google Sheets - Familiarity with Macros and Google Scripts - Strong attention to detail, especially with data sorting and organization When you bid for this project, please say your opening comment as "Convert Excel Macro to Google Sheet Guru" - this way we will know who had done auto bidding and who has actually bothered to read out requirements. This job should be pretty easy and straight forward for some...

...efficiency of my ecommerce venture. Key Skills Required: - Proficiency in Shopify App Development - Keen understanding of the Shopify Billing API Project Deliverables: - The creation of a polished, fully functional Shopify app Features of the App: Despite not listing specific features that the app should contain, the successful candidate should proficiently manage aspects such as: - Product inventory management - Order tracking and fulfillment - Provision for customer reviews and ratings Application Requirements: Highlight your experience in working with similar projects. Provide examples of past work, specifically Shopify apps, to strengthen your application. Note: Although the skill level for the successful candidate wasn't strictly noted, it's recommended t...

I'm in need of a meticulous professional skilled in data entry, particularly with numerical data, to populate an Excel spreadsheet for me. Key Tasks: - Processing a variety of numeric data - Entering this data accurately into an Excel spreadsheet - Categorizing and sorting this data by date Ideal Skills: - Excellent attention to detail - Ability to work with numerical data effectively - Proficiency in Excel - Data organization abilities - Ability to categorize and sort data in assigned order

I need a skilled freelancer to conduct data analysis on an array of mixed data (both numerical and textual) using Excel. The data will be provided in CSV file format. This project requires a sound understanding of data analysis concepts and proficiency in the use of Excel or similar spreadsheet software. Key Responsibilities: • Convert CSV files into a usable format for Excel • Analyze the given mixed data • Generate comprehensive findings from the data Ideal Skills: • Familiarity with CSV files • Proficient in Excel/Google Sheets • Experience in data analysis • Detail-oriented and accurate data entry • Good communication skills to effectively summarize findings.

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

...a talented PHP Laravel developer to design an online bus ticket booking system with the latest version 9.2. This system will facilitate user registration and login, allow for seat selection, and integrate a secure payment gateway. The system will have distinct user roles, each with varying levels of access: - Admin: oversee the overall site management. - Travel Agency/Partner: manage their inventory and sales. - User: register, login, select seats and pay for tickets. The ideal freelancer will have prior experience in similar projects and a solid understanding of PHP Laravel 9.2 for this complex build. A keen eye for usability design and a knack for creating seamless payment integration is a must. Design and develop a comprehensive bus ticket booking platform, including both ...

I am looking for a professional with strong data entry and analysis skills to assist with a key task. This engagement will involve entering both numeric and textual data in Excel for the purpose of data analysis. Here are the specifics: Look at the attached excel document. I need every country to look like the top 2 rows Afghanistan and Albania. Very simple and for the right person, I dont think it would take more then 2 hours. I need this done within 10 hours time. All links must be removed. All numbers must be numeric format. If this sounds like something you could excel at, then I would love to hear from you. Please include how you would approach this project as part of your proposal. I can pay $13 for this task. Bids higher then $13 will be ignored. T...

I am looking for someone to assist me with data entry in Excel for a project. The ideal candidate will have experience in data entry and be proficient in using Excel. Specific requirements for the project include: - Perform accurate and efficient data entry tasks - Organize and manage large amounts of data - Input data into Excel spreadsheets according to specific guidelines - Ensure data is entered correctly and consistently - Verify and update data as needed Additionally, the data will need to be presented in a graph or chart format. Therefore, the ideal candidate should also have experience in creating graphs and charts using Excel. Skills and experience required for this project: - Proficiency in Microsoft Excel - Strong attention to detail - Ex...

In need of a proficient Excel expert to shoulder some administrative duties. The role involves primarily data entry tasks, including but not limited to: - Simple data entry through copying and pasting - Repeat entries only need to be entered once - Looking at about 500 entries, (actual about 300 entries) Ideal candidate should demonstrate proficiency in Excel, attention to detail and data cleaning, and should be able to handle large volumes of data efficiently and meticulously. Organizational and analytical skills would come in handy to ensure data is presented in a user-friendly manner. Previous experience in data entry is well-regarded.

As part of my project, I'm dealing with a large set of data (more than 10,000 rows) in Excel, for which I require professional assistance. Key Tasks: - Apply specific Excel formulas to perform financial calculations, including NPV, IRR, and ROI. - Utilize logical and text functions such as IF, CONCATENATE, and VLOOKUP for data management and analysis. Ideal Candidate: - Proficient in Excel functions and formula calculations - Experienced in handling large datasets - Strong financial analysis background The right freelancer will help me analyze this data successfully and draw meaningful conclusions. This project requires detailed and careful work due to the extensive dataset. I appreciate your time and consideration of this project.

Hello, In formula mode, Excel only shows reference to cells and not the actual number. I need an excel function that will convert formulas (Cell B4) to actual numbers (Cell C4). The attached image will explain what is needed.

I need assistance with a large-scale data extraction from an Excel spreadsheet. The data includes about 38000 line items, from which I require certain specific pieces of information – namely, the Names, Addresses, and Email Addresses. This extracted information will be used for creating a logical and organized mailing list. Here are the important elements of the project: - Extracting Names, Addresses, and Email Addresses from approximately 38000 line items - No specific extraction criteria or conditions to follow Ideal freelancers for this job would have experience in data extraction, data entry and be efficient in Excel spreadsheet operations. Precision and attention to detail are paramount for this role, as the information gathered will directly impact the efficacy ...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

Se realizará una aplicación que se encargue de pasar los productos de una cotización en zoho books a zoho creator como un pedidos. Los pedidos en zoho creator tendrán etapas que deberán poderse manejar como un kanban, al llegar a la etapa final, deberá crear los productos del pedido con ZOHO Inventory. Deberá dar acceso a zoho books, zoho creator y zoho inventory. Es responsabilidad del usuario adquirir las suscripciones necesarias para poder soportar el flujo del programa.

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I'm in need of a proficient professional who can provide a detailed quantity take-off for a project Value RM3.4 Million equivalent to USD711,000. Key Responsiblities: - Providing a comprehensive full building quantity take-off service. - All data to be provided in Excel Format - Complete within 2 days. - Initial tender quantity will be provided, to compare it with taking-off quantity (re-measurement) Ideal Skills: - Familiar with Planswift would be a plus - Experience with industrial-type construction projects. - 5+ years experience in Quantity Surveying Field - Strong analytical skills and attention to detail. - Familiar with Malaysia standard of measurement, SMM2 By offering this service, you will provide an integral part of the planning and budgeting process for the succ...

Need a freelancer that can extract a list of cities (200 - 400) from a website and provide in an excel sheet. Quick job for the right freelancer. Pays $20

I'm kickstarting a new venture into the world of dropshipping, with an inventory of approximately 10-50 products. I need a multi-talented freelancer to help me: - Generate sales for my business - Iron out any design flaws in my website, enhancing usability and aesthetic appeal - Provide me with valuable knowledge on how to make sales effectively Ideal freelancers would have a firm grasp of digital marketing strategies, website design fundamentals and a proven track record in increasing sales for e-commerce businesses. It's crucial that they understand my target audience of middle-aged professionals in order to develop appropriate sales tactics and website design improvements. It's a bonus if they have experience in the field of dropshipping.

I'm in need of an Excel expert who can assist me in creating an advanced tracking system for specific KPI's and security measures. For the KPI tracking, you'll work with: - Sales - Profit Margin - Customer Satisfaction It's also crucial for the data we manage is secure with a well-setup security system. Data security is paramount, and I need these set up: - Data encryption - User authentication - Firewall protection Moreover, the security measures should include an effective incident tracker that, in case of any violation, notifies me through email. Skills needed: - Expert in Excel - Understanding of Data Security - Knowledge in setting up email notifications. Please, only apply if you have a strong understanding of these areas.

I require an expert who can handle a multifaceted data analysis task. This project (Excel dataset) revolves around a questionnaire survey I've conducted for research purposes. Key Tasks: - Carry out descriptive statistics - Conduct correlation analysis - Perform validity and reliability tests Specifically, I need the following tests to be utilized: - Chi-Square test - Cronbach’s statistic - Item-total correlation - Discriminant & Construct validity The ideal candidate should have solid experience in statistical analysis (no preferred Software), a strong understanding of the mentioned statistical tools, and an academic or marketing background to comprehend the intricacies of my research. Familiarity with surveys and questionnaire analysis will be a significant adva...

I'm currently working on my MBA project, and I'm looking for a statistician with a strong background in regression analysis and Excel. Here's an overview of what I'll need from you: - Perform a comprehensive regression analysis: I've chosen to focus my research on this area of statistics. - Use Excel for this project: I have decided to use Excel for this project due to its simplicity and because it's a tool I'm familiar with. - Complete the project as soon as possible: I'm running on a tight schedule, so time is of the essence. Required Skills: - Strong grasp of regression analysis - Proficiency in Excel - Ability to work under a tight deadline This project is quite urgent, so I'd appreciate a swift response from ...

...for clear display of listed cars - Featured advertisement packages enabled with payment integration - Chat function promoting direct communication between buyers and sellers - Phone authentication for user verification - Taxonomies update via .xml file on a monthly basis Ideally, I am looking for freelancers with a breadth of experience in multiplatform application development. Proficiency in inventory management systems, chat functionality design, payment integration, .xml updates and creating intuitive user interfaces are prerequisites for this job. Understanding the car industry would also be beneficial. Your flexibility in adapting to potential changes will offer a competitive edge. This is an exciting opportunity to bring tangible value to users and shape a digital market...

Hello Shofiur, the project is about building a security inventory of my servers and VMs. I'll provide around 500 IPs and their tcp and udp ports should be scanned (range 1-65535) you should delivery a csv file with 1 port for each line and format: ip address,proto,port,service,version (if you have more information, even better) Thank you.

...manage product information from an external source. The capabilities I’m looking for in my ideal freelancer include: - Proficiency in Shopify app development - Ability to automate data retrieval and management processes - Experience working with product APIs for data fetching and synchronisation The app should be able to: - Retrieve product information such as product details, price, images, inventory status, weight and location from an external source - Automatically post the retrieved information on my Shopify store - Update the product weight and location information as it changes in the product source without manual intervention I'm aiming for a solution that optimises my product management process and reduces man-hours. The ideal freelancer for this job would ...

In this project, I'll need your expertise with Excel to map names across multiple tabs - K1, K2, and K3 - against a listing in the 'mapping' tab. Before you agree, you should understand that each name could be slightly different, meaning you can't rely completely on automation; you will need to manually review and align each entry. Key Responsibilities: - Copy names directly from tabs K1, K2, and K3 into columns E, F, and G respectively. - Use unique identifiers to categorize and organize this data. - If a name in K1, K2, or K3 doesn't match any entry in the 'mapping' tab, leave the corresponding cell in columns E, F, or G blank. The successful freelancer for this project will ideally be proficient in Excel, detail-orientated and has a st...

Data Organize and Analyze Excel VBA guy with Data Analysis skills.

We need a specialist to scrape names, addresses, location, and contact details from a targeted database website. This is primarily for data analysis purposes. The scraped data will be required to be cleaned and structured for our specific data analysis tools. Therefore, attention to detail will be paramount in this project. Requi...from a targeted database website. This is primarily for data analysis purposes. The scraped data will be required to be cleaned and structured for our specific data analysis tools. Therefore, attention to detail will be paramount in this project. Requirements: - Proven experience in web scraping - Knowledge of data cleaning techniques, specifically for data analysis - Proficiency in working with Excel files - Attention to detail - Adherence to privacy r...

I'm seeking a proficient Excel expert to combine and simplify my existing Excel spreadsheets. Your main task will be: Do you think you could create a tab, call it AMC priority exercises, and consolidate the JEP & OCE tab into 1 timeline? - Consolidating spreadsheets into one, focusing on data entry and organization. For an ideal candidate: - Proficiency in Excel data manipulation and optimization is necessary. - Familiarity with event planning would be a plus. Main objectives: - Simplify data entry and make it less time-consuming. - Arrange the data by rows for easy navigation and understanding. - The data mainly consists of date or time-based data for numerous organizational events. With your help, I aim to streamline my event planning process by having ...

I'm looking for an expert marketer who is confident enough in their skills to work on a PAY-PER-PERFORMANCE basis for a marketing campaign to increase bookings and host inventory. The successful candidate will be responsible for: - Driving a measurable increase in bookings using social media advertising, search engine optimization (SEO), and email marketing - Creating and implementing a focused strategy to engage male and female customers aged 18-35 - Recruiting more hosts (or listings) from a target audience ranging from 35 years and up across Canada The ideal candidate will have: - Proven experience in SEO, social media advertising, and email marketing - A record of delivering measurable results - Exceptional skills in targeting both genders within the 18-35 age group ...

The task is centered around entering text data taken from digital documents into an Excel spreadsheet. Accuracy and attention to detail are a must. Take data out of pdf and word documents and enter into an excel file for few of the fields that are required. We can try using python or other scripts but maybe manual as well. Total of 62 reports (rows of data) to be entered. Key requirements: - Ability to convert data from digital documents to text format - Proficient in data entry - Strong Excel skills - Detail-oriented - Ability to deliver work within the stipulated timelines Please ensure you have the necessary skills and experience before placing a bid. Looking forward to your proposals.

...the top 10 companies in each of the 30 predefined categories, across UAE. Essential information to gather: Company name, headquarters location, service category, website URL, service area, and contact details (name, email, and phone number) for two key personnel, accompanied by a concise company description (2-3 sentences). Google review score as well. The deliverable is to be in one master excel sheet which can be filtered based on category & location. Ideal candidates should demonstrate strong research capabilities, an understanding of the UAE business landscape, and proficiency in data organization. Kindly provide an estimate of the time and cost for this project in your proposal. I need a lump sum price and estimated timeline to receive the information. Data to ...

...both web and mobile platforms. This application shouldn't only be easy to use, but also efficient and effective in: - Fetching current listings from Amazon. - Analyzing sales, orders, and overall performance for strategic decision-making. - Allowing for the manual addition of different types of costs to be inputted by users - Allowing for the uploading of inventory Cost of Goods by users - Periodically updating the inventory/listing prices to reflect real-time changes. An ideal freelancer should proficiently display a strong grasp of API integrations, Amazon's seller platform, and Amazon Selling Partner API. A track record of similar projects would demonstrate the freelancer's capability to deliver on my project's requirements. Above all else,...

I am in need of a seasoned professional to assist with Dental disease data collection research. While the specifics are still under wraps, you will need a knack for adaptation along with a strong understanding of both quantitative and qualitative da...Exceptional ability to interpret objectives and extract essential data - Fluent and skilled in English - Good team work - Good time management Knows how to use AI technology to collect and gather data Job description: 1) to gather and collect data using available AI technology 2) to screen and filter accurate and valid data from collected responses 3) to collect and compile data in Microsoft word/excel 4) to collect non-repetitive data with at least 3000 words 5) to identify true information and content about dental diseases wi...

I'm looking for an accurate and diligent freelancer to extract data from a scanned PDF document and enter it into a spreadsheet. The documents consist of 50 to 100 pages, each of which contains data in a table format. This project will require a careful eye for detail and experience with both Microsoft Excel and data entry from a pdf file. Typing accuracy and the ability to maintain data integrity are important skills for this task. There can not be any errors. Please provide examples of similar data entry projects that you have completed in the past.

...other sustainable building-related products and materials. Robotics educational toys for adults and children. sustainable skincare and beauty products Motor vehicle accessories import and clearly list top selling products from AliExpress, Oberlo, and Printful to streamline the process. We want the product information to be automatically updated across all platforms and to keep track of our inventory to avoid selling out-of-stock items. We also need help with logo design, branding, and payment integration. We want to integrate PayPal, escrow, and other payment options so our customers can choose their preferred payment method. Ideal candidates should have extensive experience working with Shopify dropshipping setups, especially with AliExpress integration. Proficiency in setti...

Our team is actively looking for an experienced Azure Solutions Architect well-versed in implementing Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) solutions. Your main task will be to ...be to assist us with a logistic and port management enterprise application. Ideal Skills and experience: - Extensive knowledge and experience in Azure cloud solutions - Proven track record in implementing IaaS and PaaS solutions - In-depth understanding of logistic and port management systems - Understanding of Azure OpenAI While not necessary, any experience or skill in real-time tracking, inventory, and document management would be highly appreciated as this could potentially be implemented in future. Candidate to have more than 12 years of experience and in azure around...

Hello, I have a brand on Amazon US and we sell in decoration category. One of our listing which has a lot of items on inventory started to show very low sales, so I need you to analyse why has this happened. Maybe I don’t see some potential problems. So 1)I need identification of problem and 2)possible solutions for this problem. I’ll provide you with links to the product to evaluate it.