Need excel macro jobs

...seeking a skilled developer to create database or programme to accurately reconcile multiple csv files of data from different time periods into a single spreadsheet. Individual csv files need to be imported to create a single worksheet or report keeping the time period data distinct. The project includes: - Understanding of multiple CSV databases. - Accurate importation of each CSV file into a worksheet report. - Ensuring the integrity of the data during the importation process. Ideally, the candidate should possess: - Strong data analysis skills. - Experience with handling large CSV files. - Proficiency in Excel or similar spreadsheet application with understanding of database structures. - Attention to detail to maintain data accuracy. - Knowledge on data reconcil...

I'm in need of a data analyst, capable of performing descriptive statistics and correlation tables, along with two linear regressions using Excel. I aim to identify trends and patterns that will help in improving operational efficiency and bolstering data-driven decisions. • The project involves analysis of data sourced from a Spreadsheet/Excel file. • The ideal freelancer should be skilled in Excel, descriptive statistics, linear regression and data interpretation. • The purpose of the research is not just to understand the current state of affairs but to make strategic decisions for the future. • A background in market research will be beneficial for the project. Your task will be to provide me with a comprehensive report deta...

I'm seeking a skilled web scraper to extract valuable data from Website 1. The data to be extracted includes the company name, address, location, phone number, and email. The priority of extraction should be the phone nu...location, phone number, and email. The priority of extraction should be the phone numbers and emails first, followed by the rest. - Extract information from Website 1 - Prioritize phone number and email extraction - Populate a single Excel sheet with all fields The ideal freelancer for this job should have robust skills and experience in data extraction, web scraping, and Excel. Timeliness and accuracy are of utmost importance. If this sounds like a project that matches your skills, I'd love to hear from you! Need to Extract data from a...

I am looking for a proficient professional who can create an advanced Excel Gantt chart for me that is produced from a table extracted from Salesforce. This would involve: - Incorporating elements of task scheduling and progress tracking into the Gantt chart. - Completing the project within a span of 1-2 weeks. - Breaking down each task on a weekly basis to provide a comprehensive visualization of the project timeline. Skills needed for the job would include proficiency in Microsoft Excel, experience in creating Gantt charts, a good understanding of project management principles, excellent time-management skills and attention to detail. Familiarity with task scheduling and progress tracking would be essential.

I need a freelancer skilled in Excel who can create a sales tracking sheet for me. My focus is on monitoring the sales revenue of my business. Here's what I'm looking for: - A sheet where sales data can be manually input - A system that can effectively track AR from the customers Ideal Skills and Experience: - Advanced Excel expertise - Experience in data entry - Your role will involve not only creating the system, but also ensuring that it's easy for a person without a technical background to use. I'm hoping that this project can be completed efficiently, with minimal revisions needed.

Please Sign Up or Login to see details.

...take on fantasy romance. **What to Include in Your Proposal:** - A brief overview of your experience in fantasy and romance genres. - Samples of past work that showcase your storytelling skills and ability to capture the essence of fantasy romance. - Your approach to creating enchanting tales within the constraints of a short story format. This project is the perfect opportunity for writers who excel in delivering impactful narratives in a brief format. If you have a talent for creating worlds where love knows no bounds and every sentence is a step into the magical unknown, I invite you to submit your proposal. Let’s create something truly magical together....

I am looking for an expert in chatbot development who can construct a bot capable of engaging in meaningful discourse based on the contents of differing PDF documents. The chatbot will need to be fully integrated into an existing website, and should excel in suggesting relevant content from PDF files based on user interaction. Major functionalities include: - Ability to parse and understand content from a series of PDF documents - Skilled at suggesting relevant PDF material based on user chat inputs - Capacity to adapt dynamically to regularly changing PDF content Ideal applicants should possess strong skills in artificial intelligence, natural language understanding, machine learning, and web development. Past experience with dynamic chatbot development would be a signific...

I'm seeking an experienced software developer to create a Microsoft Office Add-in or application that could function in Word and Excel. This digital tool should be designed with artificial intelligence capable of recognizing factual and procedural questions within the documents. With a foundation in machine learning and chatgpt, it should be apt in offering answers by analyzing previous documents and accessing website information. I'd like the system to be versatile in its response presentation; it should present suggested answers both within the document and/or in a pop-up window. Looking forward to working with someone who has: - Significant experience in AI and Machine Learning - Understanding of Natural Language Processing for question detection - Proven track recor...

I'm in need of a proficient web developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: - Implement e-commerce capabilities, enabling efficient online transactions. - Integrate Skrill as the website's payment gateway. Prior experience with Skrill integration will be highly advantageous. - Execute a professional, corporate aesthetic for the website design. Preference for developers who excel in creating such layouts. Ideal Skills and Experience: - Proficiency in web development - Experience with e-commerce website creation - Familiarity with Skrill payment gateway - Strong track record in creating professional, corporate website layouts.

I'm in need of a proficient web developer to construct an e-commerce website with a methodical, corporate design. Key Specifications: - Implement e-commerce capabilities, enabling efficient online transactions. - Integrate Skrill as the website's payment gateway. Prior experience with Skrill integration will be highly advantageous. - Execute a professional, corporate aesthetic for the website design. Preference for developers who excel in creating such layouts. Ideal Skills and Experience: - Proficiency in web development - Experience with e-commerce website creation - Familiarity with Skrill payment gateway - Strong track record in creating professional, corporate website layouts.

We're a service organization that uses a customer database that can be exported into an excel format that we want our service paperwork to reference and auto-populate in specific text fields. Any changes in the spreadsheet need to be reflected in the service form PDFs. So, we're in need of a competent developer experienced in Excel, PDF manipulation, and integration. Your task will be to create functional PDFs with formulas that reference my Excel spreadsheets. Key Aspects: * Proficiency in using Microsoft Excel * Expertise in Lookup and reference formulas mainly VLOOKUP, INDEX * Ability to develop a system that integrates PDFs with Excel spreadsheet to reflect real-time changes. We're looking for an expert who can deli...

I need to create an addon for excel where I will send email using the built in mailmerge and outlook will be used to send the email. The addon needs to: 1) monitor for replies sent from these email 2) if no email is received from the domains (as replies may come from a different person) where the email was sent, outlook will trigger a calendar reminder to send a follow up email 3) an email follow up template should be automatically created in the calendar and when I click it, I shouldn't have to add anything extra, except maybe to change the name of the recipient (or if the addon can pick up the name from the first email, that would be best) and then I can click send.

I'm seeking an expert who has comprehensive skills in product analysis primarily focussing on different categories. This role involves identifying profitable items from China to sell on unique CIS marketplaces...experience using 1688, Taobao and etc. - Proficiency in product analysis. - Ability to work with Russian text and marketplaces using a translator. - Understanding of how to use Keepa, Helium10, and JungleScout software to find trending product. - The ability to use Excel/Google Sheets In this task you will need to find 10 items and analyse them. I'm looking for long term business in case of successful completing the task. I'm pinning Excel with the template how it must be filled to calculate profit from the product. Also you will need to ...

I need a freelancer with adept skills in data entry to assist with entering single random words into an Excel spreadsheet. Expertise in Excel and keen attention to detail will be necessary. No particular categorization or field-specific organization is required. However, accuracy in entry is crucial. This task will involve: - Data entry of single, random words into Excel - Ensuring accurate and error-free input - Delivering the completed project on time. Experience in data entry, particularly with Excel, is greatly preferred. Familiarity with handling text data will also be beneficial. Please ensure you're comfortable with such requirements before making a bid.

I'm seeking a skilled individual who can create a complex mathematical Excel program for me. This program will need to perform functions related to 401(K) CONTRIBUTIONS, MATCHING CONTRIBUTIONS, IRS LIMITS AND SPILLOVER. Data visualization focused on financial data. Key Requirements: - Develop financial models within Excel - Design data visualization​ techniques to present this financial data - Implement interactive graphs, allowing for visible outcomes based on different inputs. - Facilitate 'what-if' scenario changes, which will impact the outcome and must update correspondingly - Implement a system where variable inputs are updating corresponding outputs effectively. Ideal Skills & Experience: - Experience in Excel programming - Strong ...

I am in need of a Google Sheets specialist able to deliver quickly. I have a fitness brand and require the application of complex formulae to perform the following tasks: - I have a database which when I select a food it gives me the macros depending what grams I input. - I want to Enable the calculations to propose different food alternatives with the same macro attributes to automatically adjust so I can give other options (i.e., equivalent quantities of rice and potato)(i.e., equivalent quantities of chicken and mince). not exact but give or take 10% Kcal - Maintain the fundamentals of data validation rules and conditional formatting rules throughout the sheet. The ideal freelancer should be highly competent in Google Sheets functions and have experience with nutritiona...

I need a dynamic video creator who can craft compelling 1-minute videos that focus on a soccer player's goal-scoring prowess. I'm seeking an Instagram video creator to craft engaging 1-minute videos highlighting an athlete's skills from soccer matches. The ideal candidate will extract compelling moments from VEO footage to create daily Instagram posts showcasing a particular player's talents. Payment will be per video, with potential for ongoing work based on efficiency and quality. If you excel at creating captivating sports videos and can deliver promptly, this opportunity is for you. Key Requirements: - Advanced video editing skills are mandatory. Expertise in motion graphics, advanced effects, and professional color grading will be highly valued. - I...

Hlo! I have done MS in statistics. I read your job description. I have expertise in SPSS, R studio, excel, minitab, quantitative and statistical analysis. I will provide you with the finest work that perfectly aligns with your time and budget constraints. Thanks waiting for your response. Regards, Hira Mahmood

Hi, you did an excel vba macro for me in 2019. It worked fine until now but it just broke, its not working anymore. can you help fixing it?

I require an automated system, coded in Python, to perform checks on Visa card validity through the website Key Requirements: - Know-how of Python programming. - Experience with automated testing....the website Key Requirements: - Know-how of Python programming. - Experience with automated testing. Deliverable: - A Python script that can automatically run these checks and save them. Project Outcomes: - Verification of card validity. - The results need to be saved in an Excel (*.xlsx) file format or in my attachment Experience: - Freelancers with familiarity in Visa APIs, Python, and know-how of working with Excel files will find this task in their field of expertise.

I'm in need of someone who can create permanent, menus in both Microsoft Excel and OneNote - For Excel: The permanent drop-down menu should consist of various colors, always displayed on the screen ,that I don't have to click to open. - For OneNote: The permanent drop-down menu should consist of an array of tags, always displayed on the screen, that I don't have to click to open.

I am looking for an expert with proficiency in Microsoft Excel to redesign and update my current invoice template on Excel. You will maintain the agreed-upon overall structure but give it a fresh, modern aesthetic. The document must be made from scratch on a new Excel as the old design isn't saving in colour when saving on PDF. Colours must be the same as existing template. Your responsibilities will include: - Redesigning the template in accordance with the modern design principles. However, the overall structure of the existing invoice should be retained to ensure similarity. - Updating the existing invoice template to a more contemporary design yet similar to the existing document. - Potentially modifying formulas or adding new columns if necessary. Ideal ...

I require the expertise of a Power BI maestro who is proficient in creating dynamic, interactive and visually appealing reports from sales data. This project specifically involves: - Analyzing sales data I will provide in Excel format. - Constructing and designing a Power BI matrix table for reporting purposes The ideal candidate is proficient in Power BI and Excel with an in-depth understanding of sales data reporting. You should be able to translate complex data into informative visuals & interactive reports. Producing accurate, error-free analysis within arranged timeline is critical for the success of this project.

As a seasoned C# developer, I need to create a complex mapper function that can efficiently extract data from Excel. The .xlsx files contain variable patterns spread across different sheets, so having the flexibility to handle such diversity will be key for this task. Key Requirements: - Develop a mapper function in C# to process Excel files in .xlsx format. - Deal with variable data patterns having different layouts spread across numerous sheets. - Extract and process data from all sheets in the Excel file. Skills and Experience: - Profound expertise in C# programming. - Experience in handling Excel data with variable patterns across multiple sheets. - A robust understanding of data extraction processes. - Proven experience in developing mapping fu...

As the project lead, I am in urgent need of a self-driven and detail-oriented freelancer who specializes in online data entry. This project's volume isn't specifically set, but the selected individual should be prepared to handle a potentially large amount of data entry tasks. Tasks will include but are not limited to: - Prompt and accurate entry of data into our online system. Ideal candidates for this job should have the following skills and experience: - Proven online data entry experience, with references or portfolio to back it - Dedication to efficiency and accuracy - Ability to work under unknown volume pressure - Availability to start immediately would be an advantage Unfortunately, we have not yet established a definitive deadline, so freelancers with ...

I am looking for a skilled data analyst who can proficiently use Excel to perform text matching between two different Excel files for the purpose of matching the most appropriate description given to a medical service code . No significance testing is needed in this project, it is purely a direct comparison task. I have particular requirements pertaining to "Data set A". Your role will be primarily centred around: - Matching text in one Excel sheet to another. - Consolidating data based on text matches. - Focusing specifically on "Data set A". Ideal candidates should be experienced in Excel, data consolidation and comparison. Knowledge on data set handling would be a plus. Please bid accordingly, ensuring your capabilities in these areas ar...

I'm looking for an experienced data manipulator who can efficiently reformat my data according to CRM-specific requirements. Specifically, I need the address and names in my data to be split into separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split 'Names' into two separate columns: 'First Name' and 'Last Name'. This does not require any data entry, just an understanding of data structures, and layout according to CRM needs. Ideal freelancer should have relevant experience, and proficiency in MS Excel or other spreadsheet tools. Quick turnaround time is appreciated.

I am setting up a new business, selling Moodle courses online. I will be using EKM as my website / payments platform. I will need to automate the following 1) Customer order in EKM Trigger = new customer order. Automate the entry of key data into a Google Sheet or Excel File 2) Customer details added to Google Contacts 3) Integration with Moodle - Creating a new Moodle account (if a new customer) - Giving access to the particular Moodle course that the customer has purchased I am still in the set up phase, so can design my processes / workflow to make automation easier (i.e. this is, relatively speaking, a blank piece of paper). I am seeking an expert who is proficient in Zapier automation. My project revolves around streamlining the user enrollment process. Project b...

As a booming brand on Instagram, Facebook a...compelling Meta ads and formulating innovative strategies. *Key Areas of Focus:* 1. **Strategy Development:** Demonstrated experience in creating strategies to increase engagement on social media. 2. **Meta Ads Expertise:** Proven ability in leveraging Meta ads effectively. Experience creating captivating ads that drive engagement is key. 3. **Cross-Platform Proficiency:** Ideal candidate should excel in Instagram, Facebook, and YouTube; ability to create cohesive strategies across all platforms. Our perfect fit would be someone who is a pro at researching, understanding and connecting with our audience, inciting genuine interactions to foster a deeper relationship with our brand. Think you can make this happen? Then we can't wa...

I have a simple Excel VBA macro file (attached). The file shows up an additional toolbar on my personal PC, but does not show toolbar on client's PC. NOTE: The client can still run the macro code using the button placed on the grid. I just need to know the right group policy that needs to be setup correctly.

I'm seeking a proficient Excel user who can deftly analyze my amalgamation of patient's research data. The data in question comprises of medical histories, treatment outcomes, and demographic information. Further, I need an in-depth exploration of the correlation between investigations and treatment outcomes. The ideal candidate will need to: - Process and analyze lab test results, heart rate, and temperature records. - Correlate these factors with treatment outcomes. - Extract meaningful insights from medical histories and demographic data. Experience with health-related research data is a plus. Your analytical skills, attention to detail and knowledge of Excel are paramount.

As the client, I'm seeking a skilled Excel VBA macro specialist who can create an automated system for a repetitive task in our operation. The task in question involves a data entry form consisting of Product, Quantity and Price fields that needs to be automated. As a professional with deep knowledge in Excel VBA, automation and data entry, you have: - Proven experience in crafting Excel VBA macros. - Proficiency in automating repetitive tasks. - Extensive understanding of data manipulation. - Excellent knowledge of Excel formulas and functions. Your main job will be to create a macro to automate this data entry form. This will involve auto-filling data into the respective form fields where necessary. This efficiency-generating macro...

I need an Excel expert to customize specific features in my existing utility. The chosen freelancer will focus on the following: User interface modifications: I have a preference for a minimalistic design. The interface should be clean, intuitive and not cluttered for easy navigation. Formula automation: I want to automate various tasks like data validation rules, calculation automation and data sorting and filtering. You should be able to craft these tasks to improve efficiency in data administration. Data analysis enhancements: Lastly, I want to enhance the data analysis functionalities to help with strategic decision-making. The ideal person for this project should have in-depth experience with excel and particularly in building and customizing excel ...

I am looking for an expedient and detail-oriented freelancer who can perform data entry tasks for my project within 1 to 2 weeks. The task will involve entering a mix of numeric and textual data accurately into an Excel spreadsheet. Requirements would include: - Proficiency in Excel for efficient data entry - Excellent attention to detail to ensure data accuracy - Ability to meet strict deadlines to complete the task within the agreed timeframe - Prior experience in data entry, specifically with mixed data types Preferred Skills: - Proficiency in Excel - Attention to detail - Time management skills - Experience with handling mixed data types This job will entail the completion of data entry requirements with attention to detail, speed, and accuracy. Please submi...

I need expert guidance to optimize and integrate our in-house applications built on Django. Our applications range from AI chatbots for consultants to excel mapping. Django has already been installed, a main APP has been created, each application is intended to run as an API. Here's where you come in: - Optimize Application Performance: Help us enhance the speed and efficiency of our apps. - Integrate with External APIs: Guide us on how to effectively link our applications with external APIs. - AI Application Development: We want to create AI apps in a more efficient manner. Your insights will be valuable. I expect freelancers applying to this project to have: - Experience: relevant experience in Django and AI application development, and API integration. To make...

I am on the look-out for skilled individuals who excel in the spheres of web creationn and social media marketing to join my agency. The primary goal of our agency is to increase brand awareness for diverse businesses, our target audience. Required Skills and Experience: - Expertise in web creation: Being able to create user-friendly and visually appealing websites is crucial. You should also be adept at responsive design to ensure the sites function well on varying devices. - Proficiency in social media marketing: Proven expertise in developing and executing social media strategies to boost brand visibility and engagement is needed. Familiarity with marketing analytics to monitor and adjust strategies as required would be advantageous. Past experience working with businesses and ...

I need a diligent and efficient worker to help with data entry into an Excel sheet. The scope of work will be entering simple text entries. Requirements: * Reliable and fast typing skills * Prior experience in data entry * Ability to pay attention to details * Deliver on-time and with accuracy Application: In your application, kindly include your past work related to Excel data entry. I am interested to review your related experiences and proficiency. This assignment could lead to an ongoing partnership if your work is of high quality. Thank you in advance for your interest in this project.

I am seeking a proficient freelancer with solid Excel skills who can help me populate my Excel sheets. While no specific type of data is mentioned, good typing skills and attention to detail will be beneficial due to the nature of the project. The work would require timely and accurate typing of any kind of information whether it's text, numbers, or dates into Excel sheets. Since no further specific details were provided, showing an array of competencies, from past experience to detailed project proposals, in your application would set you apart. Ultimately, the main intent here is to organize information effectively without a specific analytical or reporting goal in mind.

...) Login, logout, roles (ACL if available in build) 2.) Users section with list, add, edit, delete, active and inactive user. Use ajex to check duplicate user email while adding and updating user. 3.) Categories and sub-categories 4.) Blogs (List, add, edit, delete, active and inactive), Meta title, Meta keywords, Meta description 5.) Page Manager 6.) Contact us list (With email) 8.) Export an excel having blog title, number of views, date created, user name columns and in last total of columns. Front-end: 1.) Landing page showing featured blogs and having menu of categories and sub-categories. 2.) Categories list page showing number of sub-categories of that category with categories. Sub category wies page showing number of blogs in that sub category. 3.) Blog list page (Cate...

...kinds of expenses for my business. This should include: - An understanding of how to categorize expenses into staff salaries, subbie payments, materials, and individual staff hours on a daily basis. - The ability to record relevant information for each expense entry, such as the date, description, amount, payment method, as well as individual employee details including dates and times. - Advanced excel skills and experience in financial data management will be ideal for this task. You will be building a tool that will be central to my business's financial tracking, so an attention to detail and understanding of financial data is key. - Experience in creating similar tracking spreadsheets will be highly valued. Please include details of similar projects in your proposal. A p...

I need virtual assistant, easy work just copy paste. More discusse with freelance chat...

...charges in bid for this project For this project, I'm looking for a talented programmer who is highly-experienced in working with MySQL and Excel VBA. Your task will be to create a MySQL table with 3 columns. This table will be used in conjunction with Excel VBA to import data. Here are some specifics about the project: - The Excel sheet contains similar data types in a single sheet. - The data type is primarily text strings. - We need a VBA process to export these Excel data strings into our newly created MySQL table. Ideal Skills and Experience: - Expert knowledge in MySQL and Excel VBA. - Proven experience in data import/export between Excel and MySQL. - Detail-oriented and accurate in data handling. - Focused on meeting p...

I'm seeking a skilled Python programmer to develop a software module that can retrieve and process data from an Excel file. This bespoke software needs to display the data like a railway station scroller, strictly text-based. Key functionalities required include: * Picking data: The tool should extract data from the Excel file and output each row sequentially. * Sorting: While the display should be row by row, the order should be according to a certain criterion, instead of the original Excel sequence. Ideal Python programmer would bring: * Proficiency in Python programming, particularly in handling excel files and data sorting. * Previous experience or knowledge of creating text-based scrollers would be a plus. * Understanding of data presentation and...

My project requires a proficient programmer familiar with Excel VBA and MySQL integrations. I'm seeking a solution that incorporates: - Database creation, modification, and updating - Data import and export via Excel VBA The VBA code should be capable of following tasks: - Reading data from the MySQL database - Writing data to the database - Updating existing data - Deleting data I'll be working with various kinds of data, including: - Text data - Numeric data - Date and time data - Binary data Knowledge of Excel VBA programming and MySQL database management forms the crux of this project. Experience in handling different data types and proficiency in database operations will be of paramount significance.

...in gathering emails of a list of companies I already have at hand. The job entails the following: - Extracting emails of the listed companies. Key job requirements include: - Proven experience in web scraping, data mining and Excel - High attention to detail and accuracy - Familiarity with email gathering processes The purpose of these emails is for sales and marketing purposes; thus, discretion and adherence to GDPR and other privacy laws are of utmost importance. The list I'll provide is in Excel format, therefore a good understanding and efficiency in Excel would be greatly beneficial. Please note that the turnaround time for this project is also very crucial, so your ability to work effectively within a given time frame is key. Please only bid if ...

I have a registration ...the data gets pushed to a different system. There are about 200 records that did not sync and I need someone to manually go through and resync these. I'll provide an Excel file of the records that need to be resynced. To do this: 1. Login to Wordpress 2. Go to: Forms > Entries > Choose 'Spring 2024 Flag Football Registration' 3. Search for the players last name 4. Hover over their entry and click 'Resend' 5. Wait for it to process, then do the next one 6. Here is a video of the process: 7. You need to wait for each to finish to start the next, but you can 'resync' multiple at a time if you use different tabs. Need this done as soon as possible. Please let me know if any questions.

...business and need an extensive research to be completed. I need data from US cities to be gathered, analyzed and published so the public can learn. Key Deliverables: - Collection of various data points such as population demographics, crime rates, economic indicators and items that reflect retirees. - Detailed information about the data points source such as is the data free, who is the source, etc. - Starting point will be surveys published that will be provided to you on topics such as "Best place to retire in the US." Ideal freelancers for this project should have: - Experience in market research and data analysis. - Understanding of the U.S. regions and cities. - Ability to meet strict deadlines. - Clear and concise reporting skills. - Provide your resear...

We're on the lookout for self-motivated sales reps ready to roll up their sleeves and boost their earnings with our natural herbal products. With a proven track record and satisfied customers, our products offer a lucrative opportunity for those willing to put in the effort. Responsibilities: Drive sales of our natural herbal products to prospective cus...profit-sharing opportunity. As you contribute to our products' success, you'll share in the profits generated. If you're hungry for success and eager to boost your earnings through hard work, this is the opportunity for you! Join us in spreading the benefits of our natural herbal products far and wide. Ready to seize this opportunity? Submit your application detailing your drive and determination to excel in...

Need an excel expert for an assignment