Excel vba jobs
...freelancer who can create a multiple price list in Excel for my business. The ideal candidate should have experience in Excel and be proficient in creating spreadsheets. Pricing Information: - The Excel file should include product prices, discounts, and tax rates. - The prices should be easily adjustable and editable. Format/Layout: explain while talk - I do not have a specific format in mind, but I am open to any format that is clear and organized. - The freelancer should have the ability to create a professional and visually appealing price list. Updating Frequency: - The price list will need to be updated on a monthly basis. - The freelancer should be available to make the necessary updates and adjustments. Skills and Experience: - Proficiency in Excel...
I am looking for a freelancer to help me set up an Airtable inventory management system for my manufacturing process. The specific features I need for the system are inventory tracking. I currently have an excel system in place that needs to be migrated to Airtable for automation - specifically related to bill of materials so that we can minimize use of in and out entries. The size of my inventory is small, with less than 100 items. Ideal skills and experience for this job include: - Proficiency in setting up and customizing Airtable - Experience in inventory management systems - Knowledge of barcode scanning and production scheduling would also be beneficial.
I am looking for a freelancer who can help me with my Excel work dashboard project. The ideal candidate should have experience in data analysis and visualization. Tasks to be performed: - Analyze and visualize operational data using Excel - Create custom dashboards to present the analyzed data Data to be analyzed: - The project involves analyzing operational data Visualization tools and charts required: - The project requires the use of custom dashboards for data visualization Skills and experience: - Proficiency in Excel and data analysis - Experience in creating custom dashboards - Strong understanding of data visualization techniques
Dashboard required for operational data, the raw data is attached with basic info. 1) Column define for day, week, month. 2) need to declare table with info by Product 3) sheet 1 Dashboard and rest in the following sheet Sample attcahed view Job complete review then payment
I am looking for a freelancer who can assist with a data entry project. The project involves typing data into Excel. Key Requirements: - Experience in data entry and proficient typing skills - Attention to detail and accuracy - Familiarity with Excel and ability to navigate through spreadsheets - Time management skills to ensure timely completion of the project Project Details: - The volume of data to be entered is small, with less than 1000 entries - The data should be entered in Excel format If you meet the above requirements and are available to start immediately, please submit your proposal. Thank you.
Project Title: Finish an excel project I am looking for someone to help me with data entry in Excel. The task involves entering data into Excel spreadsheets accurately and efficiently. Key Requirements: - Proficiency in Excel and data entry - Attention to detail and accuracy in entering data - Ability to complete the task within 24 hours Preferred Skills: - Experience with standard Excel formatting - Familiarity with organizing and categorizing data in Excel If you have the necessary skills and can complete the task within the given deadline, please bid on this project.
Project Title: Excel dashboard Description: - I need an Excel dashboard to track sales on defferent parameters and month and month tracker on different parameters - The dashboard should be interactive, allowing me to easily explore and analyze the data. - I prefer a combination of charts and tables in the dashboard format. - The ideal freelancer for this project should have expertise in Excel and data visualization. - Experience in creating interactive dashboards with a combination of charts and tables is a plus. - Attention to detail and the ability to present complex data in a user-friendly manner are essential skills for this job. And VBA including is also added advantage Will connect on remote desktop and explain what I need
I am looking for someone with excellent Excel skills to help me with a data merge, extraction, and functions project. Here are the details: Data: - The project involves merging and extracting both text and numeric data. Format: - The extracted data should be in Excel format. Sheets: - There are more than 7 sheets involved in the data merge and extraction process. Skills and Experience: - Strong proficiency in Excel, including advanced functions and formulas. - Experience with data merging and extraction. - Attention to detail and accuracy in handling large amounts of data. If you have the necessary skills and experience, please bid on this project.
Looking for a webscapping expert who can help in extracting text data from certain websites. Post extraction the data could be organized in excel spreadsheets. Ideal skills and experience for the job include: - Proficiency in web scraping tools and techniques
...developer to create an Android app that will track uniform (PPE) inventory. The app should have the following features: - Ability to capture uniform photos and store them in an organized manner - Integration with Excel to keep records of the uniforms - User-friendly interface for easy navigation and management of inventory - Ability to search and filter inventory based on different criteria - Secure login and access control to protect sensitive information Ideal skills and experience for this job include: - Proficiency in Android app development - Experience with integrating apps with Excel or other database systems - Knowledge of UI/UX design principles for creating a user-friendly interface - Strong problem-solving and troubleshooting skills - Attention to detail to e...
As discussed, need to make macro as follows- 1. Sheet 1, each product "column A" has several codes "HAAD code , DDC code, SFDA code 2. Sheet 2 is already mapped with "HAAD,DDC" NDC codes 3. I want to map SFDA codes from sheet 1 into sheet 2, based on matching with either HAAD or DDC codes 4. If 2 SFDA numbers are availble"per product", only "New RegisterNumber" from "SFDA official"is to be added and , "column A" 5. Get all columns from "SFDA official sheet mapped to Sheet 2, based on the already mapped number 6. Also paste the SFDA code in sheet 4, based on the "code"from sheet 1
I am looking for a freelancer who can help me scrape contact information from a specific website. This is an urgent requirement as I need to gather data on potential investors. Specific Requirements: - Scrape contact information from the specified website - Deliver the data in an Excel Spreadsheet format Ideal Skills and Experience: - Experience in web scraping and data extraction - Proficiency in using scraping tools and techniques - Strong attention to detail to ensure accurate and complete data collection
I am looking for a freelancer to build a list of Ultra-High-Net-Worth Individuals (UHNWI) based on specific criteria. The project requires the following: Criteria: - Identify UHNWI based on their net worth and income Focus: - The UHNWI list should be global in scope Format: - The list should be presented in an Excel spreadsheet Ideal Skills and Experience: - Experience in data research and collection - Proficiency in Excel or data management software - Attention to detail and accuracy in compiling the list Please note that confidentiality is crucial for this project, as the data collected will be sensitive.
I am looking for a finance Excel expert who can help me with advanced tasks involving automation and macros in my Excel file. I have screenshots of the layout but need it to be repoicared into excel The financial model is of advanced complexity and must be familiar with maths and formula Ideal Skills and Experience: - Strong proficiency in Excel, specifically in automation and macros - Extensive experience in financial modeling and forecasting - Ability to work with complex financial models and analyze data - Attention to detail and accuracy in reporting financial data - Excellent problem-solving skills and ability to troubleshoot Excel issues - Strong communication skills to effectively convey financial analysis and insights. this is not a job for d...
I am looking for a freelancer who can convert a simple PDF file containing less than 10 pages into an Excel spreadsheet. The PDF file only has text and basic formatting, so it should be a straightforward conversion task. Template of half done excel provided. Need this done ASAP, within the next couple of hours.
Description: I need a freelancer to efficiently convert a SQL script into an Excel table, ensuring each SQL statement is split into columns for easy analysis. The SQL script includes various statements such as CREATE TABLE and DROP TABLE. Task: Transform SQL script into an Excel table, splitting each statement into separate columns. Clean up unnecessary characters and comments for clarity. Apply consistent formatting to enhance readability. Requirements: Proficiency in Excel, with expertise in creating and formatting tables. Familiarity with SQL syntax is advantageous.
Development of data management modules on existing PHP Code Igniter Application. A full list of the field requirements within (SRS document) will be provided, and screenshots will be provided of the Excel files where the data was previously entered to indicate data types. Work Overview Development of Data Management Modules (CRUD) Filtering of the entered Data based on data, location, and other specified fields Generating aggregated totals within modules where specified. Generating reports based on date ranges (exported in PDF and Excel) Integration of existing Permission on the newly developed modules
I am looking for a freelancer to create a Profit Sharing excel template for my company. The template should have the following specifications: Financial Metrics: - The excel template should track the Profit Margin of the company. Profit Sharing Plan: - The template should include calculations for a Variable profit sharing plan. Forecast/Projection: - The template does not need to include forecast or projection capabilities. Skills and Experience: - The ideal freelancer should have advanced knowledge of excel and financial analysis. - Experience in creating templates for profit sharing plans is highly preferred. I am looking for a freelancer who can deliver a high-quality and user-friendly excel template that accurately tracks our profit margin and calculate...
Project Title: Learn Excel through Live Online Sessions Skills and Experience: - Expertise in Formulas and Functions in Excel - Proficiency in teaching beginners in Excel - Experience conducting live online sessions for teaching purposes Project Description: I am looking for someone who can teach me Excel through live online sessions. I am a beginner with no previous experience in Excel and I specifically want to learn about formulas and functions. Requirements: - The ideal candidate should have a strong understanding of formulas and functions in Excel. - They should have experience teaching beginners and be able to explain concepts clearly and concisely. - The teaching sessions should be conducted through live online sessions to ensure real-ti...
I am looking for a freelance developer to help me develop a simulation model in MS Excel for catalyst performance and design. Skills and Experience Required: - Strong background in chemical engineering and simulation modeling - Proficiency in developing chemical reaction models - Knowledge of fluid dynamics and multi-phase flow modeling is a plus, but not required - Familiarity with various simulation software is preferred, but I am open to using any software that is suitable for the project Project Details: - The primary goal of the simulation model is to predict catalyst performance - The model will be used to analyze and evaluate the behavior of different catalyst designs - The developer will need to work closely with me to understand the specific requirements and parameters o...
I am looking for a skilled programmer who can develop a program that meets the following requirements: 1. Input: The program should take both audio and text input. The text input will be provided in Microsoft Word format. The Audio input will be provided in mp3 file format. 2. Output: The program should generate the start and end time of each bible verse in the audio file. These start and end times should be in the XLSX format. 3. Audio Length: The program should be able to handle audio files that are up to 10 hours in length. Skills and Experience: - Proficiency in programming languages and tools necessary for audio processing and text analysis. - Experience with working on projects involving audio and text data. - Familiarity with the XLSX file format and the ability to generate dat...
...by gathering company data through an API. The ideal candidate should have experience in retrieving data through APIs and be proficient in Excel Spreadsheets. There will be a ready excel report on the computer. A new program will be created (preferably in Python). The new program will read 2 of the excel fields from the ready report, and the data will be selected through an API by using those 2 excel fields. The gathered data will be added to the new excel columns. Requirements: - Gather company data through an API - Retrieve and organize the data in Excel Spreadsheets Skills: - Proficiency in retrieving data through APIs - Advanced knowledge of Excel Spreadsheets Experience: - Previous experience in gathering and organizing company da...
...Allow users to create and manage their profiles, including personal information and preferences. We are open to integrating the app with specific external services or APIs, but we are not sure about the specific requirements at this time. We are looking for a developer who has experience in developing similar apps and is capable of handling any necessary integrations. We are currently using an excel spreadsheet so we already have data we are just looking to make it more user friendly so our consigners can see their inventory, what has been bought and how much they’re owed. If you have the skills and experience to develop a high-quality consignment app that meets our requirements, we would love to hear from you. Please provide examples of your previous work and any relev...
...The main purpose of this application is to both monitor air quality in real-time and visualize historical air quality data. Our project aims to calculate air pollution distribution using a trained computer vision model from satellite images. The output file from our model is an Excel sheet that has pollutants occurrences corresponding to longitude and latitude In brief way, What we want currently?: -Map based view, with detailed view example: pollutants per bounding box that are generated from our ai model (excel file). - integrating our heavy model that process high definition images into a powerful server( based on python). The web application should be accessible on both PC and mobile browsers, so proficiency in both platforms is required. While I don't ha...
I am looking for a skilled programmer who can extract text data from PDF files & EXCEL for analysis purposes. Skills and Experience: -Python user /AI - Proficiency in extracting text data from PDF files - Strong understanding of data analysis techniques - Experience in working with PDF files - Attention to detail to ensure accurate extraction of data Responsibilities: - Extract text data from PDF files - Clean and format extracted data - Perform data analysis and provide insights If you have experience in extracting text data from PDF files and are proficient in data analysis techniques, please submit your proposal.
I am looking for a freelancer to assist with data cleaning and formatting. The ideal candidate should have experience with Microsoft Excel and be proficient in data manipulation. Requirements: - Expertise in Microsoft Excel for data cleaning and formatting tasks - Ability to handle small datasets (less than 1,000 entries) - Attention to detail and accuracy in data entry - Familiarity with common data cleaning techniques - Strong organizational skills to ensure data is properly sorted and formatted If you have the necessary skills and experience, please submit your proposal.
SAP ABAP Support required on Tasks: 1. Date is not transferring in Excel sheet from custom report. 2. Quantity fields are appended with zero, it should not transfer with zero. 3. 5 Custom fields to be added in one existing report.
Data Entry Project - I am looking for a freelancer to assist me with a data entry project. - The project involves entering a large volume of text data (500+ entries) into an Excel spreadsheet. - The ideal candidate should have experience in data entry and proficiency in using Excel. - Attention to detail and accuracy are crucial for this project. - The freelancer should be able to complete the task within the given timeframe. - This is a remote project that can be done from anywhere. - The project budget will be discussed and agreed upon with the selected freelancer. - If you have previous experience in similar projects and can provide references, it will be a plus.
...pricing plans (Deal Package) that can be purchased with 4 payment plans that need to be included in the table. I should also have the ability to edit the table after it is purchased. The Highlighted Deal Package is the $600 The Highlighted Pricing Plan is the Single Payment The second payment starts on the start date, followed by every week afterwards until balance is paid. I have attached an excel screenshot of the pricing plans, and deal packages sheet with whats included in each deal. I want it to look attractive, modern, and organized. You can also view our current packages online at Ideal Skills and Experience: - Experience in designing and creating pricing tables - Knowledge of UI/UX design principles - Ability to showcase different pricing plans
I am looking for a PHP developer with experience in CodeIgniter. Requirement - Website Admin Design Super Admin 1- Category, Sub categories 2- Users - Admin, Team, Client --- Export in excel 3- Products - Product, Add on items, add on services 4- Support - Ticket, Message (team chat) 5- Order - New Orders list - Export in excel - 011 - Approve >> Team 6- Coupon and discount Stripe, paypal ------------- Client 1- Profile Setting 2- Orders List - 011 3- Tickets 4- Discussion Projects 5- Notifications ---------------- Team 1- Profile Setting 2- Orders List (Assigned only from admin ) 3- Tickets 4- Ongoing Projects 5- Notifications Website frontend Design -
Simple automate to run everyday at 9am; - Collect All the Calendar events including the Body message from the event - Populate an Excel file with all the events and body message from each event. Next day at 9am clear all the rows and start again
I am looking for a freelancer who can help me convert an Excel file into a GIS layer. The Excel file is in .xlsx format. I am not sure if I need any specific spatial references or projections for the GIS layer, as well as any specific attributes or fields. Skills and experience required: - Proficiency in GIS software and tools - Knowledge of Excel file formats and conversion processes - Familiarity with different spatial references and projections in GIS - Ability to work with and manipulate attribute data in GIS layers The file contains Crash Data and is in New York State in Westchester County along NYS Route 9. After Crash Layers/Shapefile is created, would like a kernel density layer created based on crashes throughout the corridor.
I am seeking a highly skilled and informed professional who can assist in sourcing exceptional blank clothing manufacturers. This project is centered around finding manufacturers that provide not only superior quality clothing but also excel in private labeling and dropshipping services. Key Requirements: Product Quality: Essential focus on manufacturers known for their high-quality blank clothing. Attention to fabric, stitching, and overall craftsmanship is a must. Private Labeling Services: The manufacturer should offer comprehensive private labeling options, including: Digital Printing: Advanced digital print techniques for vibrant and long-lasting designs. Flocking: Capability for adding textured designs. Embroidery: High-quality embroidery for detailed designs. Leather Patc...
Office Manager Needed for Administrative T...incoming and outgoing mail and packages - Assisting with scheduling and coordinating meetings - Managing office budgets and expenses - Maintaining office files and records - Assisting with HR tasks such as onboarding new employees and maintaining employee records Requirements: - Mid-level experience in office management or administration - Proficiency in Microsoft Office Suite, including Word, Excel, and PowerPoint - Strong organizational and time management skills - Excellent communication and interpersonal skills - Ability to multitask and prioritize tasks effectively - Attention to detail and accuracy in work If you have the skills and experience we are looking for, please submit your proposal with your relevant experience and quali...
Excel and Tally Operator Needed for Regular Data Entry Tasks Skills and Experience: - Proficiency in Excel and Tally software - Strong attention to detail for accurate data entry - Knowledge of formulas and functions in Excel - Experience in data analysis is a plus Tasks: - Data entry in Excel and Tally - Inputting and organizing data accurately - Ensuring data integrity and quality - Collaborating with team members for data analysis and reporting Deadline: - No specific deadline for the tasks Frequency: - Regular assistance required for Excel and Tally tasks You have to visit the office to complete task. Office is in Nashik. Note: Please provide examples of previous work or relevant certifications in Excel and Tally.
I am looking for a skilled data en...for a skilled data entry specialist to help me organize a small data set of up to 500 entries in an Excel spreadsheet. The ideal candidate will have experience in data organization and be proficient in using Excel. Skills and experience required: - Proficiency in Excel and data entry - Strong attention to detail - Ability to accurately organize and categorize data - Excellent organizational and time management skills Responsibilities: - Inputting data into an Excel spreadsheet - Organizing and categorizing data according to specific criteria - Verifying the accuracy of data entries - Ensuring data is well-structured and easy to navigate The completed data entry must be in the form of an Excel spreadsheet. The proje...
I am looking for someone to help me with data entry in an Excel sheet. The specific task is to enter simple data such as names and addresses. I am open to suggestions regarding the format or template to be used. Skills and Experience: - Proficiency in Excel and data entry - Attention to detail - Ability to follow instructions accurately
Example: Shiprocket, NimbusPost Features 1. Integration with Shopify, Woocommerce to fetch orders. 2. Integration with courier companies like Bluedart, DTDC, Xpressbees, etc. 3. Ability to book orders by comparing prices. 4. Ability to process NDR 5. A Billing Section where entries need to be made for each order placed 6. A report section where user can download excel file 7. A settings section where user can add warehouse details, KYC, Bank details, label settings,
...to websites. The specific tasks I need assistance with include filling out applications to affiliate networks. Filling up the updates in an excel sheets. I will provide the list of products, the assistant will find them on Offervault or offerzone and apply using the details i provide. Skills and Experience: - Experience with applying to websites and filling out applications - Basic Use of Excel - Research skills to gather information about companies -Communicates well I will provide a list of products that I need assistance with. The virtual assistant will be responsible for applying as an affiliate, updating the status, and copying the link in an Excel sheet. This is an ongoing project with potential for more websites to be added in the future. The ideal candi...
Data analysis - I have numerical data that needs to be analyzed. - The type of analysis needed is descriptive analysis. - I prefer to use Excel for the analysis. Ideal skills and experience: - Proficiency in Excel for data analysis. - Strong understanding of descriptive analysis techniques. - Ability to interpret and communicate insights from numerical data.
Project Title: Need help in creating resume for RTL design engineer Role/Position: RTL Design Engineer Skills/Experiences to Highlight: - Knowledge of RTL design principles and methodologies - Proficiency in hardware description languages such as Verilog or VHDL - Familiarity with ASIC/FPGA design flow and tools -...co-op experience in the field of digital design - Familiarity with industry standards and protocols - Strong communication and documentation skills Note: The above description is tailored for an entry-level RTL design engineer looking to create a resume that highlights specific skills and experiences in the field. The ideal candidate should possess the necessary knowledge and qualifications to excel in RTL design and demonstrate a strong foundation in digital design p...
I am in need of a freelancer who can assist with data entry from PDF to Excel. The volume of data to be entered is more than 500 entries, and I require completion within a week. Skills and experience required for this project include: - Proficiency in Excel and data entry - Attention to detail - Ability to meet deadlines If you have previous experience in data entry and are able to work efficiently and accurately, please submit your proposal.
...field in a PivotTable. Insert a calculated field named Difference with a formula that subtracts the sale price from the list price. Change the display label for the calculated field to Variance. Format the Variance values to show negative numbers in red with parentheses. Select all the cells in the PivotTable and apply All Borders. Save and close the workbook (Figure 4-125). Excel 4-7 completed Figure 4-125 Excel 4-7 completed Upload and save your project file. Submit file for grading....
...(txt) file into excel I am looking for a freelancer who can help me convert a text file into an excel file. The text file is in the format of txt. The text file doesn't appear to be comma separated. The issue encountered is that one field in particular is of variable length which throws out other columns. The file also has other lines that need to be deleted (and if possible some of that data copied into rows below each section. Need to be able to automate conversion on regular basis (not once off). Requirements: - The excel file should have separate columns for each field in the text file. - The conversion should be completed within a week. Ideal Skills and Experience: - Proficiency in converting text files into excel files. - Stron...
I am looking for a Visual Basic expert who specializes in VBA (Excel Macros) to help me with modifying an existing program. Requirements: - Proficiency in VBA (Excel Macros) is essential - Experience in debugging and modifying existing programs in Visual Basic - Familiarity with Excel and its functions is a plus - Ability to work with existing code and make necessary modifications If you are a Visual Basic expert with experience in VBA (Excel Macros) and are available to work on modifying an existing program, please apply for this project.
I am seeking an Excel Macro Expert who can assist me with creating advanced custom formulas. The ideal candidate should have experience in developing complex formulas in Excel. This project does not have a strict deadline, as the timeframe is flexible. Skills and Experience Required: - Proficiency in Excel macros and VBA programming - Strong understanding of advanced formulas in Excel - Ability to automate data entry and generate reports using Excel macros - Attention to detail and ability to deliver accurate and efficient solutions
I am looking for a freelancer who can convert PDF calculations to Excel. The project involves both basic and advanced calculations. The formatting of the Excel file needs to be exactly the same as the PDF. We have more than 20 pages of PDF calculations that need to be converted. Ideal skills and experience for this job include: - Proficiency in PDF to Excel conversion - Strong knowledge of basic and advanced calculations - Attention to detail to ensure the formatting remains consistent - Ability to handle a large volume of pages efficiently
I am looking for a skilled freelancer to help with a data entry project. The data to be entered is alpha-numeric, and I prefer it be completed in an Excel Spreadsheet. The dataset to be entered consists of 100-500 entries. The work should be accurate and timely; any errors or delays will result in a lower score. The project will be evaluated based on the quality of the data entry work, speed, and accuracy. Flexibility and attention to detail are important requirements for this project. Please contact me if you have any questions about the project.
Read Following information of Vouchers opened via link received in email: * Discount offered by Voucher (e.g £2.50 off when you spend £30) * Voucher Code (e.g PJ-R5-M3-Q8) * Voucher Expiry Date Email containing link to these vouchers is will be read by scrapping Gmail. Deliverables: * A python script that will do what is described above and it will save that scrapped information into an excel file. * System will also save datetime of email in which we receive link to vouchers
