Excel vba inventory programsmunkák

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I'm looking for a skilled developer to integrate my POS system with Swiggy and Zomato. The integration should focus on automated order processing and menu synchronization. Key Features: - ...Skills and Experience: - Experience with integrating POS systems with external platforms, particularly in the food industry, would be highly beneficial. - Proficiency in building robust, real-time data synchronization systems is key. - Prior experience with Swiggy and Zomato APIs and understanding of their order processing mechanisms is a distinct advantage. Please note that I do not require inventory updates from Swiggy and Zomato orders. The focus is solely on order processing and menu synchronization. Looking forward to hearing from skilled developers with proven experience in si...

... Instagram, and Shopify, ensuring seamless user experiences and efficient sales processes. Monitor and analyze store performance, making data-driven decisions to improve sales and customer satisfaction. Customer Acquisition and Retention: Identify and target key customer segments through market research and data analysis. Develop and implement customer retention strategies, including loyalty programs, personalized marketing, and excellent customer service. Performance Tracking and Reporting: Track and report on key performance indicators (KPIs) to measure the success of marketing campaigns and e-commerce activities. Use analytics to identify trends, insights, and areas for improvement. Qualifications: Bachelor's degree in Marketing, Business, or a related field. Proven ex...

...customized inventory management app using Google AppSheet and MySQL. The app will cater to a user base of less than 50, but it needs to be designed and optimized for scalable growth. It should be intuitive, easy to use, and have a professional interface. Key features that need to be incorporated into the app include: - Real-time inventory tracking - Sales and purchase order management - Product barcode scanning As the app will be handling crucial data for my business, security and reliability are of utmost importance. The developer should have experience in creating and integrating secure databases, as well as a track record of building robust, scalable applications. The successful freelancer should have: - Proficiency in Google AppSheet and MySQL - Experience in deve...

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

...a new, customized solution. While experience with Zoho Creator is not a strict requirement, it would be beneficial. The main goal of this project is to develop an ERP system that will handle inventory management and sales/order processing. We will need to connect for already created ERP system first. Key aspects of this project will include: - Developing a customized ERP solution from scratch - Implementing inventory management features - Integrating sales and order processing functionalities Ideal candidates should have: - Proven experience in developing ERP systems - Strong understanding of inventory management and sales/order processing - Proficiency in Zoho Creator (or any other ERP system if not Zoho Creator) This is an urgent requirement, so please only app...

...professional to assist in integrating 2 instances of Unleashed. The primary goal is to optimize 3pl, ordering and inventory management by streamlining the process across both instances. Must be able to get Unleashed platform to talk to our clients unleashed account. Providing live stock updates order from one to another live and automating all this. This will need to be completed this week and no later as we have a tight deadline to achieve this. Flow Chart, Shopify Order > Unleashed > (Updates stock levels on clients unleashed as well as our own)> Send order to clients unleashed. Client uploads new stock > updates our unleashed account. Key Tasks: - Inventory Management: Ensure that inventory data is synchronized in real-time between the two insta...

...aims to replicate the functionalities of Tally. The portal should have the following main features: - Accounting Features - Inventory Management Features - Sales Management Features In terms of the accounting features, I require: - General Ledger - Accounts Receivable - Accounts Payable For the inventory management features, it's essential that the portal includes: - Inventory Tracking - Stock Alerts - Purchase Order Management Given the complexity of the project, I am looking for a professional with prior experience in creating similar online portals. Proficiency in both back-end and front-end development is crucial. A good understanding of accounting and inventory principles is a bonus, as this will help in making the portal more intuitive and use...

I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets - Understanding of conditional formatting and ot...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

...31 to Akta machine - Verify that the connection is functioning correctly - Ensure the automation process is smooth and operational - Provide any necessary troubleshooting or support post-implementation -Ensure Fermworks and Labview are activated properly and the connection is functioning correctly with the bioreactor. -No additional purchases of software. - Familiarity with VMware as a couple programs are located on these virtual machines. Ideal proposals should include: - Experience in connecting different machines - Proven track record in automation projects - A detailed project proposal outlining how you would approach this task, ensuring successful automation Please note, you'll need to have expertise in driver connections and automation to be successful on this proje...

...sending/receiving data packets, and handling socket errors. Additionally, I need help in creating a small WooCommerce database interface. The specific requirements: - Socket Programming: You will be responsible for establishing a server connection, sending and receiving data packets, and managing socket errors. - WooCommerce Database Interface: We will be integrating a small interface to manage product inventory. In this case, we are looking for basic integration - primarily focused on reading product data. The ideal candidate should have: - Proven experience in C# programming, particularly with a strong understanding of socket programming. - Prior experience working with WooCommerce or similar e-commerce platforms for database interface design. - Ability to deliver precise a...

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...

...our intranet. Here are the specifics: IA definition: (below you can see my own) - We need the inventory management, manufacturing, service contracts and human resources management features to be properly configured. - The system must be set up for 1-10 users to access on our intranet. Customizations and integrations: - We may require custom reports or dashboards, although the specifics for these are not yet entirely defined. - There may be other custom integrations needed as the project progresses. Ideal Skills and Experience: - Proficient in Dolibarr installation and configuration - Previous experience in setting up Dolibarr for small businesses - Strong understanding of inventory management and HRM - Able to propose and implement customizations as they...

...Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Summary (2-3 pages): - Overview of the preliminar...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I'm seeking a professional capable of driving immediate revenue and setting up sustainable income streams for my e-commerce website. - Revenue Models: - I aim to create generational income, rather than focusing on one-time sales. Your task will be to: - Create and sell digital products - Build a loyal customer base for repeat purchases - Implement successful affiliate marketing programs - Expertise Required: - Proven experience in e-commerce revenue generation - Proficiency in setting up and managing digital product sales - Strong track record in customer retention strategies - Successful implementation of affiliate marketing schemes If you have the right skills to drive revenue and set up sustainable income streams, I'm excited to hear from you...

[NO AUTO GENERATED APPLICATIONS… WILL BE DELETED] I need someone familiar with affiliate marketing programs and sites. Someone that can find me some good affiliate products for me to ask. I'm hoping you can find impressive products that have potential to go viral. Tell me some good affiliate products into Instagram. You will search programs like Clickbank, Sharesale, etc. In your application tell me about some products that you have found for clients. Have you ever sold affiliate products through Instagram?

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...

French-speaking candidates only! My organization is currently leveraging several Zoho applications including CRM, Books, Inventory, People, Recruit, Shifts, Project, Survey, and Forms. I am seeking a skilled freelancer who can effectively integrate these applications with our existing ERP system. Key project aims include: - Customer data synchronization: Ensuring consistent, accurate customer information across platforms. - Order management integration: Streamlining order processes for increased business efficiency. - Inventory management synchronization: Maintaining real-time, synchronized inventory data between Zoho and ERP. With 11-50 users expected to utilize this integrated system, the ideal freelancer should not only possess strong experience with Zo...

I'm in need of a skilled and experienced freelancer to create a WordPress website for my jewelry brand. Key Requirements: - E-commerce Functionality: I want the website to have a smooth and secure checkout process, with the ability to add products, categorize them, and manage inventory. - Responsive Design: The website should be mobile-friendly, given that a significant portion of my target audience falls within the 25-45 years old age group, who are likely to access the site through their smartphones and tablets. Design and Layout: I don't have a specific design in mind, so I'm looking for a professional who can understand my brand and create a visually appealing, user-friendly website. Copywriting: Additionally, I'll need assistance with the copywriting ...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tab...Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and share th...

I'm looking to develop ...requirements include: - Integration of Credit Card payment method: I want to provide a seamless shopping experience for the customers and to do so, I need to integrate credit card payment method. This will be the primary payment gateway for the website. - Product Management: I need to be able to easily add, edit and manage products through an intuitive interface. I'd like some simple features like inventory tracking and discount codes, but I'm open to suggestions on how to best manage the products. The ideal freelancer should have: - Proven experience in E-commerce website development - Expertise in integrating credit card payment systems - Understanding of product management systems - Good communication skills and ability to suggest idea...

Kérjük, regisztráljon vagy jelentkezzen be a részletek megtekintéséhez!

...will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy are highly valued. - Understanding of basic financial jargon will be beneficial. This role requires someone who is organized, reliable and able to work independently. The workload will be part-time with flex...

...ideal candidate is someone who has experience in integrating online stores with various marketplaces and who preferably has worked with Trendyol before. Key Requirements: - Product Synchronization - Order Management - Inventory Updates - Implementing Special Price Rules for the Marketplace Sales: Specifically, I would like a price increment for certain items. Ideal Skills and Experience: - Strong experience with Prestashop, especially versions 1.7.8 and 1.8 - Prior experience with Trendyol integration is a huge plus - Proficiency in managing product synchronization, inventory updates, and order management - Extensive experience in setting up special pricing rules in e-commerce platforms, particularly price increment strategies Please only apply if you have demonstrable...

I'm looking for a ready-made ERP cloud accounting system like that offers these key features: - Inventory Management - Sales and Purchase Tracking - Financial Reporting I'm specifically seeking a system that has a: - Modern and sleek design I plan to integrate this ERP system with other software via API. Ideal Skills and Experience: - Experience with ERP cloud accounting system development - Proficiency in UI/UX designing - Proven ability in API integration with other tools - Familiarity with inventory management, sales tracking, and financial reporting systems. I want similar to

Necesito crear ficheros XML para ser importados a un ERP (software contable y de producción basica), generados en base a: 1. Una tabla de Excel con información a ser importada. 2. Una estructura XML predeterminada para la creación de ordenes de producción 3. Unas condiciones que hay que cumplir para que se pueda generar correctamente el fichero XML Probablemente una vez realizado el proyecto, se podría se necesitar realizar algunos ajustes o cambios puntuales, que en todo caso serán pagados. El diseño tiene que ser modificable en Visual Basic Busco seriedad, profesionalidad y mucha rapidez.

...relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need acc...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking for a 5-star review.

Buscamos una persona española que ayude a limpiar los datos de un CRM nuevo, subir datos de excel, validarlos o buscar nuevos con herramientas de Marketing.

...seamless and efficient dropshipping automation system. Key Responsibilities: - Develop a system for order processing and tracking to ensure smooth operations - Implement inventory management solutions to prevent stockouts or overstocking - Enable price monitoring and adjustment features to stay competitive Ideal Skills and Experience: - Previous experience in setting up Amazon dropshipping businesses - Proficiency in automation tools and software - Solid understanding of ecommerce and dropshipping best practices - Strong analytical skills for monitoring and adjusting prices - Excellent problem-solving abilities to manage inventory effectively If you're a proactive, detail-oriented freelancer with a talent for automation and a strong grasp of the Amazon dropshipping...

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source mate...

...also contain information about ticket prices and how to purchase them. Location: Willesden Sports Centre Date: June 10th - July 22nd - 2024 Days: Mondays, Wednesdays and Fridays Times: 10pm-2pm (subject to change) Age: 14-16 year olds Price: £500 Ideal candidates should have: - Graphic design expertise, particularly in creating event promotion materials. - Experience in designing for sports programs would be a plus. - Strong communication skills to ensure the flyer conveys the information effectively and engagingly. Please provide a portfolio of previous relevant work if possible. Thank you....

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

I'm in need of a Flutterflow expert to handle specific backend requirements for my e-commerce marketplace app. You'll be focusing on product inventory management and order tracking/fulfillment. Key Responsibilities: - Implement a robust product inventory management system from scratch as I currently do not have one in place. - Develop an order tracking and fulfillment system that is efficient and user-friendly. Ideal Skills: - Proven experience with Flutterflow and backend development. - Strong background in e-commerce and order management. - Ability to create intuitive UI for quick order processing. Please note that I am looking for an expert who is capable of delivering a seamless and efficient system as my marketplace continues to grow. Your expertise in this...

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The idea...

...BIDS****************************************** ****************NEED TO BE NO MORE THAN 3 HOUR DIFFERENCE IN TIME FROM UK********************* I'm in need of a proficient report designer/builder to create some Sage 50 reports in Business Central. The designer should be able to create and design reports in a visually appealing manner. Key Requirements: - Design and build Sales, Purchase and Inventory reports. - In the Sales report, include Sales revenue, Sales quantity, and Customer names. - Present the Sales report in a table format. Ideal Skills and Experience: - Proficient in Sage 50 and Business Central. - Expertise in report design and building. - Ability to present data in a visually appealing way. - Good communication skills and able to deliver the project within a...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.