Excel macros jobs

...looking for a freelancer who can assist me with data processing tasks. The ideal candidate should have experience in data entry and be proficient in using Excel. Type of Data Entry Work: - Data processing Software/Format Preference: - Excel Volume of Data: - Medium (1000-5000 entries) Skills and Experience: - Proficient in data processing and data entry - Strong knowledge and experience in using Excel - Attention to detail and accuracy in data entry - Ability to handle medium-sized datasets efficiently I will provide the necessary data for processing and expect the freelancer to accurately enter and organize the information in Excel. The freelancer should have a keen eye for detail to ensure the accuracy of the processed data. The project requires timely...

I am looking for a freelancer who can help me filter certain data from a CSV file and transfer it to an Excel spreadsheet. 1. I have an excel sheet with vehicle numbers in it 2. Write a macro to fetch related info matching the vehicle number in a new excel sheet every time when it is triggered… The project involves the following requirements: Specific Data to Filter: - I want to filter numbers from the CSV file. Criteria or Conditions for Filtering: - I have specific criteria for filtering the data. - The numbers should be filtered within a certain range. Skills and Experience: - Proficiency in working with CSV files and Excel spreadsheets. - Knowledge of filtering and sorting data. - Attention to detail to ensure accurate data transfer. If you are ...

I need a skilled freelancer familiar with Google Sheets programming to help automate tasks and create macros. The tasks include data analysis, visualization, and implementing formulas/functions. Completion is required within a week, and proficiency in Google Apps Script and Python is preferred, though other languages or tools are acceptable.

I am looking for a skilled freelancer to create a macro for me on Windows. I require a software application capable of generating simple macros on a PC by analyzing and interpreting images that I upload to the program you develop. I have specific requirements for the macro, and I am looking for someone who can meet these requirements. Ideal Skills and Experience: - Proficiency in creating macros on Windows - Experience with data entry tasks - Scripting Languages: Proficiency in scripting languages like Python, AutoHotKey, or Lua is essential for creating macros. - Image Recognition: Understanding image processing techniques and libraries (such as OpenCV in Python) for recognizing and analyzing images is fundamental. - Ability to understand and implement specific re...

I am looking for someone who can assist me with data entry in Excel. The specific task involves entering medium-sized data, ranging from 100 to 500 entries. I do not have a specific format or structure for the data entry and I am open to suggestions. Ideal skills and experience for this job include: - Proficiency in Microsoft Excel - Attention to detail - Fast and accurate data entry skills - Ability to organize and categorize data effectively If you have previous experience with data entry in Excel and are confident in your abilities to handle medium-sized datasets, I would love to hear from you. Please provide examples of your previous work and any relevant qualifications.

I am looking for a freelancer who can convert a PDF file into an Excel file. The PDF file contains tables or graphs and has a total of 11-50 pages. There are no specific formatting requirements for the Excel file, any format is fine. Need it in 4 hrs, Pricing will be 300INR. Ideal Skills and Experience: - Proficiency in converting PDF files into Excel files - Experience working with tables and graphs in Excel - Attention to detail to ensure accurate conversion of data - Ability to handle PDF files with multiple pages - Time management skills to complete the project within the given timeframe

I am looking for a freelancer who can assist me with a data entry project. The main fo... The main focus of this project will be data analysis and reporting. Skills and Experience: - Strong background in data analysis and reporting - Proficiency in using Excel for data manipulation and analysis - Attention to detail and accuracy in entering and organizing data Project Details: - The data for this project will be sourced from publicly available data. - The freelancer will be responsible for inputting and organizing the data in an Excel spreadsheet. - The final report should be delivered in the form of an Excel spreadsheet. If you have experience in data analysis and reporting and are proficient in using Excel, please reach out to me. Please send a 2 minute ...

2 Million Complete USA Business Database This is a complete database of 2 million USA verified homeowners. This database includes: homeowner first and last name, home addresses, verified cellphone and email address information. This list contains 30 states. All in Excel Spread Sheets. I will pay you 40% commission on sales.

Project Description: - I am looking for a freelancer who can create an income statement based on existing financial data. - The financial statement should be at a summary level, providing an overview of the company's financial performance. - The ideal candidate should have experience in financial analysis and be able to accurately interpret and present the data. - Proficiency in Excel or other financial software is required to organize and present the information effectively. - Attention to detail and the ability to work with complex financial data are crucial for this project. - The freelancer should be able to complete the task within a specified timeframe. - Previous experience in creating financial statements for businesses is preferred.

I have an Excel file with tables and graphs. However I want to be able to print it out. For A4 format it should look nice, can you format the file so that it looks good? So some pages should be optimized for long format others with wide tables for wide format. Easy job for Excel pros. 6 Tabs in total are to be optimized for printing.

I am looking for a freelancer to convert a medium-sized PDF file (11-50 pages) into an organized Excel sheet. While I do not have a preferred format for the Excel sheet, I want it to be organized and easy to navigate. I would like all data fields to be extracted from the PDF file. Skills and experience needed for this project: - Proficiency in PDF to Excel conversion - Strong organizational skills to ensure the Excel sheet is well-structured - Attention to detail to accurately extract all data fields Text needs to be divided into columns and paragraphs into individual rows to allow ease of navigation of resulting file.

I am looking for a freelancer who can help me automate specific tasks using Power Automate. I already have an existing Excel file with the data that needs to be used for automation. I need the automation to be run whenever required, as the frequency may vary depending on the project. Skills and experience required for this project include: - Proficiency in Power Automate If you have the required skills and experience, please submit your proposal. Thank you.

I am looking for a data entry specialist to help me with a project. The ideal candidate should have experience in data entry from online forms and be proficient in Excel. Project Details: - The task involves entering a medium volume of data, approximately 1000-5000 entries. - The deadline for project completion is within a week. Skills and Experience Required: - Proficiency in Excel and data entry from online forms. - Attention to detail and accuracy in data entry. - Ability to meet deadlines and work efficiently. If you have the necessary skills and experience, please submit your proposal.

I am interested in bidding for your project. I meet the qualifications you seek and a perfect fit for the job. I am available to commence work as soon as required. I am a ...and a perfect fit for the job. I am available to commence work as soon as required. I am a fast and accurate typist, very experienced and skilled in copy typing/retyping/converting documents into Microsoft Word. I have over 4 years work experience as a PA Secretary/Administrator. I am proficient in Data Entry, Word Processing, MS Word, MS Office, Copy Typing, Copy Paste, PDF, Transcription, and Excel. High standard of work guaranteed. Professional and timely services. I look forward to the possibility of discussing this further and providing any additional information you may require. Kind regards Mariame Fe...

Program Accomplish the FOllowing: 1) Allow for upload of excel spreadsheet. 2) Excel Spreadsheet will contain a code in the first column, images in the remaining column. 3) Program will download all the images and at the same time renaming it. The naming convention is: product extension (for example, B000123456 is the product identifier, than or ) 4) For the first Image it will use the variant code "MAIN", ie 5) For each subsequent column with images, it will use variant image "PT01, PT02, PT03" sequentially. Ie I was told this can be done through pyton, but you are free to use whatever easier for you. However the end result is an executable file we can easily use without additional

I am looking for a freelancer who can help me with product costing using a dynamic Excel model. I already have all the necessary data and formulas ready. Product- Industrial valves with multi-variants and sizes. Skills and Experience Required: - Proficiency in Excel and advanced knowledge of formulas and functions - Experience in creating dynamic Excel models for costing purposes - Strong analytical and problem-solving skills - Attention to detail and the ability to work with complex data sets - Knowledge of product costing principles and methodologies

... 2. Look in the left column and you will see the replay of the entire game steps by steps. 3. look in the uploaded Json and you will see the full data but it is not very readable 4. Extract the json data and map it to a new json file that will be very simple to read with at least all of the columns in the sample excel to be represented. The new json must have the map id, the map name, the player name, the player turn and the full sequence just like on the replay web page. The json should allow to see the origin coordinate and the destination coordinate for the units and when it is an attack the position of the unit attacked. Also include the unit id. All the data is in the json submitted but it is difficult

I am looking for a freelancer who can help me with typing text data into an Excel sheet. Data Type: - The data that needs to be typed into the Excel sheet is text-based. Excel Template: - I will provide a specific template for the Excel sheet. Volume of Data: - The volume of data to be typed into the Excel sheet is small, with approximately 1-200 entries. Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail and accuracy in typing - Knowledge of basic formatting and organizing data in Excel If you are reliable, detail-oriented, and have experience with data entry in Excel, I would love to work with you on this project.

I am looking for a freelancer who can create data analysis reports in MS Excel using existing data. The data is relatively basic, with few variables and simple relationships. Skills and Experience: - Proficiency in MS Excel and data analysis - Strong understanding of statistical analysis and data visualization - Experience in creating reports and presenting data in a clear and concise manner - Ability to identify trends and insights from the data - Attention to detail and accuracy in data analysis and report generation

I am looking for a freelancer who can assist me with an Excel analytical modeling project focused on historical data analysis in the stock market. Specific requirements for the project include: - Analyzing and interpreting historical stock market data - Utilizing Excel to create tables and spreadsheets for data visualization - Working with a provided list of specific markets/ETFs - Generating insights and recommendations based on the analyzed data Ideal skills and experience for this job include: - Proficiency in Excel and data analysis - Knowledge of stock market trends and patterns - Experience in historical data analysis and modeling - Ability to effectively communicate insights through tables and spreadsheets - Excellent excel and math skills required (...

I am seeking a freelancer who can assist me with a data entry project. The ideal candidate should have experience in data input and be proficient in Microsoft Excel. Specifics: - Data entry tasks will involve inputting a small amount of data, with less than 100 entries in total. - The data will need to be inputted into Microsoft Excel. Skills and experience: - Proficient in data input and Microsoft Excel. - Attention to detail and accuracy in data entry. - Ability to meet deadlines and work efficiently. If you have the necessary skills and experience, please provide examples of previous data entry work and your proposed timeline for completing this project.

Hi, I am looking for a freelancer who has great knowlege in creating VBA application for learning platform. I have done 80 percent of databases, forms and coding. I need help in finishing this application by interlinking all in to single form like a web page. Generation of payment tracker and automatic creation of payslips.

I am in need of a Shopify Website specialist who can help me with my project. Specific features needed: - E-commerce functionality - Editing the theme purchased - Import products from excel to website - Lite modification works - SEO optimization Design/Theme: - I have a specific design/theme in mind for my Shopify website Timeline: - Not really in rush but the sooner the better Ideal Skills and Experience: - Shopify expertise - Strong understanding of e-commerce functionality - Experience in customizing Shopify websites - Knowledge of SEO optimization for Shopify sites If you have the skills and experience required for this project and can meet the specified timeline, please reach out to me. Thank you!

I am looking for someone to assist me with basic arithmetic operations in Excel. I have existing data that needs to be used for these calculations. The level of automation required is a one-time calculation. Ideal skills and experience for this project include: - Strong proficiency in Excel and knowledge of basic arithmetic operations - Ability to work with existing data and perform calculations accurately - Attention to detail to ensure accurate results - Experience with creating formulas and macros in Excel

need a web appliction to be build in stages 1. Secure login 2. Dashboard 3. Import of XML or CVS file to update database Rates & Description 4. 4 Step Application to to process Custom Entry and Export to XML 5. Application to Process Motor Vehicle Estimate Duty 6. landing page 7. Aplication to to create Manifest 8. Application to create Bill o...web appliction to be build in stages 1. Secure login 2. Dashboard 3. Import of XML or CVS file to update database Rates & Description 4. 4 Step Application to to process Custom Entry and Export to XML 5. Application to Process Motor Vehicle Estimate Duty 6. landing page 7. Aplication to to create Manifest 8. Application to create Bill of Lading 9. Subcription i have created an application with excel that i will like to make in a ...

Excel Formulation project to be done

I am looking for help automating some simple workflows in Power Automate. Verson 1: Watch for new rows in a spreadsheet. For each row, send a message to the recipient (like a merge). Then move the row to another tab/sheet. That sheet will grow, and every 3 weeks, a different mailmerge will be done to all of those people. Version 1.5 - we will tap into hubspot instead of using an excel sheet. Version 2: The process will be augmented to monitor office365 outlook sent items. Every time a message is sent, and the recipient is not in the above flows, they get "enrolled" with a simple workflow. In addition, my calendar will be monitored to watch for new meeting attendees and the flow enabled as well. Let me know if you can help me with version 1, it should be a simple proj...

I am looking for a freelancer who can assist me with automating tasks in Excel. The specific tasks that I need to automate include data entry, formulas and calculations, and data analysis and reporting. For this project, I would like to create quotes using drop-down menus that reference an Excel-database. I do not have a specific template or format in mind for the automated Excel sheets, so I am open to suggestions from the freelancer. The complexity of the data that I will be working with is moderate, with some variables and basic calculations. Ideal skills and experience for this job include: - Advanced knowledge of Excel, including formulas and data analysis - Experience with creating automated Excel sheets and databases - Strong attention to d...

Project Description: VBA work to format, save and print selected sheets in excel I am looking for a skilled VBA developer to assist with formatting, saving, and printing selected sheets in Excel. The project requires the following tasks: - Cell formatting: The selected sheets need to have specific cell formatting applied. - Column/Row formatting: Formatting of columns and rows should be implemented as per the requirements. - Conditional formatting: Conditional formatting rules need to be applied to the selected sheets. The ideal candidate for this project should have experience in VBA development and be familiar with Excel's formatting capabilities. Specific requirements for the project include: - VBA code should be editable: The client wants the flexibility to mod...

Small excel task / vb script to create batch 'Names' and 'Refers To' in the Name Manager section from a table I have provided. Excel Sheet (name manager xls) is attached and provides in table showing each of these and have also added the Excel sheet (Final Call Forward) that these entries need to go into. I have also provided an image with example of where it is and how they are entered. As this is a small task I will offer $35 AUD to complete this.

Project Description: I am in need of a proficient programmer to develop a batch processing tool leveraging ChatGPT 4, designed for analyzing a large quantity of Excel spreadsheets, specifically focusing on leave occurrences. This tool will be tasked with processing over 300+ .xlsx files, applying a series of specified prompts to extract and analyze relevant data. Key Requirements: 1. Initial Analysis Capability: - The tool should efficiently load each Excel spreadsheet, applying a filter to concentrate solely on leave occurrences, as defined in the "Prompt for Spreadsheet Analysis of Leave Occurrences." - It must exclude all unrelated data, adhering to set parameters including type of leave and specific date ranges. - The tool is expected to group, list, ...

I am looking for an expert in Excel to assist with a data analysis and reporting project. The specific tasks include: - Analyzing and interpreting data - Creating reports and visualizations - Generating insights and recommendations based on the data - Must know how to write subroutines Requirements: - Knowledge with subroutines -Knowledge in Statistics - Proficiency in Excel and data analysis techniques - Strong attention to detail and accuracy - Ability to meet tight deadlines The ideal candidate should have experience in data analysis and reporting, and be able to work efficiently and effectively within a short timeframe. The dataset will be provided by me, and the project must be completed within 1-3 days.

Add the leading zero to the postal zip code column. There are 5 different methods to do this. I uploaded a csv file and all I need is to add the leading zero in the postal zip codes so there are 5 digits not 4. So for example what happened is a zip that is normally 07003 gets shown as 7003. I need the leading zero added to the front of all these zip codes. ...uploaded a csv file and all I need is to add the leading zero in the postal zip codes so there are 5 digits not 4. So for example what happened is a zip that is normally 07003 gets shown as 7003. I need the leading zero added to the front of all these zip codes. HERE IS AN ARTICEL ON 5 ways to do it. I rather have someo0ne who knows this do it for me

Add info fields to the existing data base. Add check boxes for info that is needed. Export info that has been inputted into the data base to a microsoft word form. Fix export to excel button that has a bug. Have some type of red flag reminder pop up a week prior to Purchas Orders expiring. A few other changes and additions as they come up.

I am looking for a freelancer who can help me transfer the content of a PDF into an Excel file. The project requires the following skills and experience: - Expertise in converting PDFs into Excel files - Proficiency in handling moderate complexity layouts, which include images or charts - Ability to create an editable Excel file, allowing for easy updates and modifications If you have experience in these areas and can deliver accurate and high-quality results, please submit your proposal.

I am looking for a ChatGPT expert who can assist me with generating output in Excel template. I already have an existing Excel template that I would like to use, and I will provide it to the freelancer. The output generation is a one-time programming task, so I need someone who can efficiently complete the job. Ideal skills and experience for this job include: - Expert in ChatGPT & AI. - Expert in generating output in Excel format. - Expert in enhancing the prompts for better output of products - Familiarity with all ChatGPT versions and its capabilities - Attention to detail and accuracy in generating the output. You need to be available until the project is completed and then payment will be released and hence only bid if you are keen earning money and su...

...for a freelancer who can recreate a large spreadsheet from a photo into an Excel file. I have a spreadsheet printed on A4 paper, totaling 67 pages. Each page has 50 rows. Each row contains 10 columns. Each row has an average of 95 characters. As mentioned, I have this printed spreadsheet, but now I need the Excel file again. Therefore, I need someone to transfer this data to Excel, and for that, I will send photos of the spreadsheet. The work can be done through direct conversion or typing. Please ensure that it is identical to the original and corrected if necessary. I need the freelancer to create an exact replica of the spreadsheet, while also making it editable. I do not require any additional features in Excel such as formulas, charts, or pivot tab...

I would like to make an app or a spreadsheet in Excel to calculate the diameter of the ventilation of stainless steel tanks for sanitary use or food processes. This program must have as input information the volume of the tank, the initial temperature, the final temperature, the time of temperature change, the safety factor, and the air velocity in the pipe, as shown in the image. If it is possible to add more information to the calculation to be more precise I would like it.

I am looking for a freelancer who can convert a PDF document containing more than 100 pages into an Excel spreadsheet. The purpose of this conversion is for data entry. I would like all the information from the PDF to be extracted and organized in the Excel spreadsheet. Ideal skills and experience for this job include: - Proficiency in PDF to Excel conversion - Attention to detail in data entry - Familiarity with organizing and formatting data in Excel

1. **Bulk Customer Addition:** - Implement Excel file import for customer data. 2. **WhatsApp Invoice Sending:** - Integrate WhatsApp API for invoice delivery. - Ensure secure and formatted message content. 3. **Invoice in Messages:** - Develop module for displaying invoices in messages. - Optimize for user-friendly experience.

I am looking for a freelancer who can create an excel file for me that will help with scheduling meetings. The spreadsheet should be able to schedule meetings based on the responses we receive from clients through a survey. Survey Template: - I already have a specific survey template that I would like to use. Key Parameters for Scheduling: - The spreadsheet should consider the availability of participants when scheduling meetings. Flexibility in Scheduling: - The spreadsheet should be designed to accommodate changes in the meeting schedules and should be editable by me. Ideal Skills and Experience: - Experience with creating customized excel spreadsheets - Strong understanding of scheduling and survey data analysis - Attention to detail and ability to accurately...

...which will calculate the results based on input and generate report, for which I intend to use it for internal analysis. The reports should be delivered in an Excel spreadsheet format, ensuring an easy interpretation of the data received. By having the ability to generate this data in an Excel spreadsheet, I can easily capture and analyze the data collected in order to make well informed decisions in our internal analysis processes. As well as this, I will have accessible data available to me to present to my clients, should I need to do so. This input report generator project is ideal for someone with a strong understanding of both Excel and textual data. The reports generated from this project will streamline my internal analysis processes, providing me with t...

I am looking for a freelancer who can help me with an Excel project. The specific task that I need assistance with is adding links to my Excel sheet. I already have a template that needs to be used for this project. I would prefer to have this project completed within a week. Skills and experience required for this job include proficiency in Excel and knowledge of data entry and linking functions. The ideal freelancer should also have experience in working with templates and meeting deadlines.

I am looking for a freelancer to create a programme dashboard in EXCEL to track financial data. & Project & Portfolio data Management Data with Charts/ Pie Charts Easy to pull from other sheets Skills and Experience: - Proficiency in EXCEL - Experience in creating and designing dashboards - Understanding of financial data and metrics Requirements: - Create a dashboard in EXCEL to track and display financial data - The dashboard should be designed in a user-friendly and visually appealing format - The data on the dashboard should be updated daily Please provide examples of previous dashboard projects you have worked on.

Excel scrape data & extract data from a tab in website. I will show you my screen and you advise how to this with excel. No software please and excel web quiry is not connecting with the correct data

Title: Excel Tutoring for Professional Advancement Skills and Experience Required: - Proficient in Excel with a focus on formulas and functions - Intermediate level of Excel proficiency - Able to provide practical examples and explanations - Knowledge of data analysis and visualization techniques Project Description: I am seeking a skilled Excel tutor who can help me advance my knowledge and skills in formulas and functions. As someone with an intermediate level of Excel proficiency, I am looking to enhance my abilities to utilize complex formulas and functions for data analysis and visualization. My main objective for learning Excel is professional advancement. I believe that mastering Excel will not only improve my current job performan...

I need someone expert in Excel to show correct number here on Excel that using VBA. More details please chat me.

I am looking for a freelancer who is experienced in Excel and VBA to help with a project involving the condition-based processing of source data. The ideal candidate will have the following skills and experience: - Proficient in Excel and VBA programming - Familiarity with working with Excel spreadsheets - Ability to apply specific conditions to data processing, particularly data transformation - Experience in sorting, filtering, and transforming data in Excel - Ability to understand and work with a sample output provided by the client The project involves processing data from Excel spreadsheets based on specific conditions, with a focus on data transformation. The freelancer should be able to apply the desired conditions to the data processing in order...

I'm looking for a skilled individual proficient in Excel to meticulously transfer data from my bank statements for the years 2022 and 2023 into an organized Excel file. The task involves categorizing each transaction or entry from the bank statement. Although the exact number of entries is unknown, it's estimated to be around 200-300 annually. The bank account in question is structured into three distinct "sub-accounts," and careful attention is required to ensure each transaction is placed correctly for smooth tracking and analysis. This project demands someone with a strong background in Excel and detail-oriented file management. Write "Statement" before starting your bid

.../ Salary if below is true SElect * from function_user where menu_id=12 and sp1=1 and user_id=1 From the Documents we can take pictures from there as Activity Customer Picture from RefTable and put that as in detailed as url to show select * from REFTABLE where reftype='KUPF' and refsubtype='DocType' and SHORTNAME='Applicant Photo' SYSTEM BACKUP Backup thru database to your local means dump in excel sheet etc thru script Service Setup + kindly please add Allow Sponser Yes/No, Allow Number of Documents Number + I have noticed that it is not working properly when we use Allow Discount SERVICES + All the Supported services if Total Amount is zero than let the system allow to save as it may have zero Amount, No of installments might be zero + The Rema...