Excel vba jobs
I am looking for a freelancer who can help me extract data from a 700mb files in and format. The extracted data needs to be in Excel format. I do not have a preferred structure for the data organization, so I am looking for someone who can use their best judgment to organize the data. Additionally, I am not sure if I need any specific data points prioritized or filtered out, so I am looking for someone who can advise me on this matter. Ideal skills and experience: - Experience in data extraction and organization - Proficient in Excel - Strong communication skills to advise and collaborate with me on data prioritization and filtering
An excel database with monitoring and a dashboard
500 email sent through outlook by using Excal VBA
I am looking for someone to help me with data entry for my small dataset. The data consists of numerical values that need to be entered into an Excel spreadsheet. The ideal candidate should have experience with data entry and be familiar with Excel. Attention to detail is crucial to ensure accuracy with the data entry. The project should take minimal time to complete, given the small dataset.
We are looking for a virtual assistant to assist in creating and editing documents in PDF format. It requires proficiency in data entry, Microsoft Excel, Microsoft Word, and PDF editing. The ideal candidate should be detail-oriented, organized, and possess strong communication skills. Your responsibilities will include creating and editing PDF documents, data entry, and using Microsoft Excel and Word to organize and manage files. You will be required to complete tasks in a timely manner and communicate effectively with our team. Please apply only if you can work now. Thank you!
I would like a CSV / excel file of a list of up to 5,000 Nutritional Supplement Companies (such as , , or ) and their emails. Rather than a generic company email, it would be ideal to have an email of a contact at the company, for example, the CEO or Head of Marketing. Ideally a three column sheet with company name, company contact email, company website.
Copy contacts from pdf to excel in csv file.
Have a Spreadsheet to figure profit. Something is not adding up and I need help getting it right. Need you to be able to work now. Should be a quick fix for anyone that works in Excel.
I am looking for someone to collate contact information of companies from a provided list and record the details on an Excel sheet. I have a template for the sheet that I would like to use. The ideal candidate should have experience in data entry and should be proficient in using Excel. The details to be recorded include company name, website, email address, phone number, and address country and products Accuracy and attention to detail are essential.
Hello, I am looking for an experienced freelancer to create an Excel workbook to help me manage my small business. Specifically, I need a workbook that tracks my inventory (based on receiving, loading & unloading), Purchasing, Sales & P&L on a daily basis. I currently do not have a sales tracking system and need a new one created. This workbook must be updated daily. The freelancer must be proficient in Microsoft Excel and have experience creating and managing detailed data. A keen eye for organization and attention to detail is required. I am looking for a freelancer who is reliable and will be available to communicate progress updates to me on a regular basis. If this project sounds like something you can help me with, please feel free to submit a bid. I look...
I need a Python developer to assist me in adding columns to an excel sheet for the purpose of data manipulation. The ideal candidate should have experience working with the Pandas library. The new columns will contain numerical data. Key requirements: - Experience with Python and Pandas library - Ability to manipulate data in excel - Attention to detail to ensure accuracy of data input and manipulation.
Please don't apply if you don't have project management certification. Note: This is not a website design project, it is writing articles in project management,. Looking for someone to write 6-10 articles per month in our WordPress website. The articles should be: - Topics: PMI Certifications, Project Management, Project Risk Management , Agile Project Management, Microsoft Project, Primavera, Excel. - SEO optimized. ( Short sentences, images, keywords, internal links to our products) The writer should have Project management background (PMP Certified is preferred) and good knowledge of WordPress and SEO. In addition, we want to add comments in social media ( Reddit and Quora) to promote our products. The comment should includes links to our website. If you are in...
I would need help with code for an excel file I have that contains around 18 thousand rows. I have productname that are of the same name but differ in variants. I then want all products with the same name with the number 1, the others that come after with the number 2, etc. The problem is that it varies with anything from 4 to 8 with the same name. I am sending a file with two tabs of examples of what I mean. One how it looks and one how I want it to look with numbers. Hope I was clear enough.
We are looking for a Tally Add-On Developer to help us import Excel data into Tally Prime. The ideal candidate should have experience in Tally Prime and be comfortable working with CSV files(Sales Invoice). The project requires the following skills: - Expertise in Tally Prime - Experience in developing Tally Add-Ons - Knowledge of working with CSV/excel files - Ability to develop custom codes to import CSV data into Tally Prime The project includes the following tasks: - Develop a Tally Add-On to import CSV data into Tally Prime - Customize the Add-On to fit our specific requirements - Test the Add-On to ensure it works with our data - Provide documentation and support for the Add-On We are looking for a reliable and experienced developer to help us complete this project....
I am looking for a excel expert engineer for a very small project. There is live data coming to certain cells and that needs to be copied to another cells by using a macro or other means. Should not be more than 10 mins job for anyone who knows excel and macros
I am looking for a freelancer to create a Microsoft Excel sheet for data analysis purposes. The ideal candidate should have experience in advanced functions and formulas. Layout and Design: - I have a specific layout in mind that I would like the freelancer to follow. Level of Complexity: - The Excel sheet requires advanced functions and formulas. Skills and Experience: - Advanced proficiency in Microsoft Excel - Experience in data analysis - Knowledge of advanced functions and formulas.
7000+ items daily issue report automatic reorder daily stock
Looking for someone on a monthly long term basis Daily 2-3 hours of work Requirements: Proven experience as a Virtual Assistant, preferably with experience in hiring Excellent verbal and written communication skills in English Strong organizational and time management skills with the ability to multitask Proficient in Microsoft Office Suite (Word, Excel, PowerPoint, Outlook) Familiarity with online communication tools, project management software, and applicant tracking systems Adept at conducting online research and data analysis High level of discretion and confidentiality People from Pakistan, India, Bangladesh Please don't apply
I am looking for an experienced Excel expert to help develop a Power Query solution in order to collate and clean up my data. I have up to 100 Excel spreadsheets with forecast data for individual projects that I need someone to create a new query in order to efficiently collate and clean up my data. My main goal is to have a simplified, organized view of the data in order to make sense of what I have. We also have many other reporting templates that we require assistance with creation, ongoing support and customisation.
I am looking for a data entry specialist to assist with copy-pasting data into an Excel spreadsheet. The dataset is relatively small, with less than 500 entries. The ideal candidate should have experience with copy-pasting and be proficient in using Excel. The data must be entered accurately and efficiently.
excel project for lookup prices
I am looking for someone to create a training tracker and dashboard in Excel for my company. The ideal candidate should have experience in Excel and data analysis. The project will involve the following: - Tracking employee attendance for training sessions - Creating a combination of tabular and graphical formats for the dashboard to display attendance data - Updating the dashboard on a weekly basis If you have the skills and experience necessary to complete this project, please submit your proposal.
We make extensive use of (Projects) and wish to explore API integration from and to From Syspro OBDC files into projects (desk) custom fields and from Teamwork Projects projects custom fields to PowerBI/Excel and back into Syspro.
I am looking for a freelancer to help with creating an Excel sheet to track valuable metrics for my call center. Specifically, I would like to be able to track call volume as well as average handle time. I do have some ideas for the format and layout of the sheet, but I'm open to suggestions. To make sure the sheet is as accurate and up to date as possible, I'd like it to be a combination of automated updates, as well as manually updating from time to time.
We are seeking a skilled Excel developer to create a simple (1 type of product with different ) inventory management program in Excel. The program should be user-friendly and able to track inventory levels, sales, and purchases. The ideal candidate should have experience in Microsoft Excel and be able to complete the project within 5-7 days
I am looking for a freelancer who can create HSE dashboard excel templates for me. The project requires the following skills and experience: - Experience in creating HSE dashboards - Advanced knowledge of Excel - Strong analytical skills Specific requirements for the project include: - Tracking of training hours - Both interactive and static dashboard options - High-level overview of HSE metrics If you have the necessary skills and experience, please submit your proposal with examples of similar projects you have completed in the past. Thank you.
I am looking for a freelancer to create a highly customized Excel dashboard to visualize my financial data. I need suggestions for specific KPIs and metrics to track. The ideal candidate for this project should have experience in creating customized Excel dashboards, as well as a strong understanding of financial data visualization.
I am looking for a freelancer to create a PDF to Excel data scraping tool. The PDFs that I need to scrape are a mix of both scanned and text-based formats. The tool must be able to perform Optical Character Recognition (OCR) to extract the data accurately. I need all data fields extracted from the PDFs, and the tool must be able to handle large volumes of data. Ideal skills and experience for the job would include knowledge of data scraping tools, OCR technology, and proficiency in Excel. The tool must also be user-friendly and easy to navigate. Thank you for your interest in my project.
I am looking for a freelancer who can help me find businesses in specific areas. The areas to focus on are provided in a list, and I am looking women's hairdressers specifically. I need the freelancer to provide details such as the name, email, and address of each business. I am looking for 10-20 businesses per area. There are 50 locations. Ideal skills and experience: - Experience in research and data entry - Attention to detail and accuracy in data collection.
I'm looking for the development of a custom tool that will extract valuable information from PDFs and convert it into an Excel table. Specifically, I need the ability to extract Tables and Charts from the PDFs for the output. Language preference is open – however, I would prefer whichever language is best for this particular tool. The desired output format for the extracted information should be in an Excel file. If you have the skills and experience to develop this project, I would love to hear more about the tools and solutions you can provide.
I need to create a matrix for grading pigs to create and invoice. I would like to be able to select the supplier from a drop down box. I have included a template of an invoice that was created as an example the levy and swine duty are constant at the moment but need to be able to be changed if there is an increase. I also need to be able to add transport as a description. We copy and paste a kill sheet into the template. From the kill sheet I need the information to be sorted by type, eg female, male, castrate, sow, gilt, boar, sucker I need to be able to select a weight range , a P2 range and also a price/kg for example female 0kg - 300kg P2 0 - 40 and put this on the invoice So for each kill sheet it might look like there are 30 female pigs weighing up to 60kg and P2 up to 14 are $...
... The app should have the following features: - allows users to follow videos on the screen and casting options - connect to Spotify and Chromecast to tv - Available on both iOS and Android platforms - around 320, 1 min videos that are run off a workout plan. 25 videos each workout with 1 rest every 5 videos. 255 workouts need to be built from an excel sheet. eg level beginner, no equipment, workout 1 = 25 VIDEOS IN CORRECT ORDER FROM THE EXCEL SHEET. - 5 options of levels from beginner to advanced - 3 options of equipment use. - full access to all information and data, eg source code. - tutorials video at the start of every level with option to skip. - intro video when opening the app - subscription based with a week free trial with a referral discount code to receiv...
I am seeking a freelancer who can assist me in performing data analysis for my project. The main objective of this project is data analysis, and I will provide the dataset for the freelancer to work with. The results should be presented in a static report format. Ideal Skills and Experience: - Advanced Excel skills - Proficiency in PowerBI - Experience in data analytics - Strong analytical and problem-solving skills - Ability to work with large datasets - Attention to detail and accuracy - Excellent communication skills - Ability to deliver the project within the given timeframe
My project requires the transfer of data from a PDF file into Excel, and involves data cleaning and formatting to match a provided template. I understand that the database will need to be accessed and the manual input of some information may be necessary. I am looking for someone with the skills and knowledge to follow the template closely while ensuring the integrity of the data is preserved. Ultimately, I require a high-level of accuracy, reliability, and attention to detail when transferring data. Additionally, I will need the correct formulas applied to get the desired outputs in the spreadsheets.
Help me create an excel sheet. The purpose of the excel sheet is to create email nurturing campaigns to a list of emails with a click of a button using the Developer Tab > "insert" > "button" on excel. Sheet 1, Labeled as Emails, will have Column A with First Name, Column B with Last Name, Column C as Email Address. Column D will be date in which the first Email address was sent. Column E is the time in which the first email was sent. Column F is the date in which the second email is scheduled to send. Column G is the time in which the second email is scheduled to be sent. Column H is the date in which the third email is scheduled to send. Column I is the time in which the third email is scheduled to be sent. There should be a button on Emai...
I am looking for a freelancer who can help me with Excel and editing. The purpose of the Excel sheet is data management, specifically for customer information. I need assistance with both data entry and data analysis. Ideal Skills and Experience: - Advanced Excel skills - Experience with data management and analysis - Attention to detail - Good communication skills - Ability to meet deadlines The freelancer must be able to work efficiently and accurately, ensuring that all data is entered and analyzed correctly. They should also be able to provide valuable insights and recommendations based on their analysis.
I am looking for a freelancer who can correct the pivot tables in my Excel file related to sales tracking. Currently, there are issues with incorrect calculations, which I need to be fixed to achieve improved accuracy. The ideal candidate should have experience with pivot tables and advanced Excel functions. Additionally, attention to detail and accuracy are crucial for this project.
I am looking for a skilled Software developer to create a Windows software with the below mentioned features: 1. login 2. Add product details and save data in MySQL database (database already exist) 3. Encode RFID tags and Print the above added data 4. Fetch & display all added data in server 5. Export added data in excel file 6. Creating custom printing templates in which the added data can be printed (ex. Logo, number etc.) Experience required: 1. .Net 2. ZPL printer language (RFID printer)
I am looking for a freelancer who can convert my TradingView PineScript code into Python, specifically in an excel format. The PineScript code is available and may be moderately complex. The ideal candidate should have experience in both PineScript and Python, as well as a clear understanding of how to convert one into the other. The output format should be an excel file.
Create dashboard using excel sheets
Hi Lead Studio, You completed a project for me a coupld of weeks ago, creating a program that updates an excel worksheet with data from a pdf. I have a question that I hope you can answer. The resulting excel worksheet data is not being read as numbers. I cannot manipulate (add, subtract, etc) the data on the output worksheet. Can this be modified so that the data on the excel worksheet can be manipulated. I have tried several ways to reformat the data, without success
I am looking for a Python expert who can fetch Bollinger Band indicator values in real-time for multiple stocks in Excel. The following are my project requirements: Stock Exchange: NYSE Technical Indicators: Only Bollinger Bands Data Update Frequency: Daily time frame Ideal Skills and Experience: - Expert in Python programming language - Proficient in Excel - Familiarity with real-time data fetching - Experience in working with financial data and indicators
MY BUDGET IS $80 USD, SO PLEASE NO PLACEHOLDER PROPOSALS. I need a node.js regex (not-a-scraping) application that will have the following (a) input and (b) o...output only the 8 most recently created customers of the domain. - If the user selects a payment plan on the / route, we will redirect to the Stripe checkout page of that plan so the user can make a one-time payment. - If the payment is successful, we will redirect to the /plans/[planId] route so the user can click on a button to export a specific number of customers (based on the plan) as an Excel file. But if the payment failed, we will redirect to the /plans/failed route. We will use node.js for the backend, for the frontend, MongoDB/mongoose for the database, and Stripe no-code payment links for the payment processi...
I have a .pdf file (also converted to .xlsx) with visitor data for an event. The data includes fields such as Company Name, Address, Postal Code, City and State, Phone Number, Website and Email Address. I need to separate each data field while preserving its structure, and create a .csv file (suitable for creating contacts in Outlook) or contact cards with all the information.
I am in need of a freelancer who can perform data analysis for performance analysis purposes. I have a specific statistical method and visualization technique that I prefer to be used. The project needs to be completed ASAP. Ideal skills and experience: - Expertise in data analysis and statistical methods - Proficiency in visualization techniques - Strong knowledge of Excel and other relevant tools - Ability to work efficiently under tight deadlines - Excellent communication skills to keep me updated on the progress of the project.
I am looking for someone who can help me secure an Excel file that contains personal information. The ideal candidate should have experience in password protection and should be able to ensure that only authorized personnel can access the file. Additionally, I need the cells in the Excel file to be protected, to prevent any accidental changes or deletions.
Looking for excel person who can deploy excel in multi user environment.
...The primary purpose of the video cartoon is to entertain and captivate the audience, while subtly advertising our brand. In this role, you will need to voice over the video, following the provided script. Your creativity will play a crucial role in making the videos more impressive and memorable. Each episode will be delivered on a bi-weekly basis, and you will be compensated per episode. To excel in this position, you should have experience in 2D animation and a talent for bringing stories to life through engaging visuals and fluid animations. Attention to detail is key, as we want to create videos that leave a lasting impression on our viewers. If you are ready to showcase your animation skills, bring characters to life, and contribute to an exciting brand marketing project,...
I am looking for an Excel expert to create a formula that will determine the 30-second block based on the value data in an entire spreadsheet. The desired output for the calculation should be a whole number. Ideal Skills and Experience: - Advanced knowledge of Excel formulas and functions - Experience in creating complex formulas for large datasets - Ability to work efficiently and accurately with numerical data - Strong attention to detail and ability to troubleshoot errors.