Data excel sheet macro jobs
...highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the requi...
Create a form in Excel following the pre-determined options. The results of the answers must be recorded in a second tab
I intend to streamline the process of document submission and verification in relation to EDPMS entry and BRC, with a focus on customs or trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validati...trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validation purpose. Key Responsibilities: - Submission and verification of customs or trade-related documents - Verification and correction of any errors found in the documents Experience & Skills: - Experience in the customs or trade sector is essential - Proficient in Excel/CSV - Strong attention to detail and high accuracy in document handling - Previous exposure to EDPMS and BRC is...
I've already done most ...the key piece of work. - Comprehensive Review: It's important that you review my analysis comprehensively and suggest corrections or improvements where necessary. - Final Financial Year Analysis: The analysis should cover multiple financial years, ensuring a comprehensive assessment of my trading performance. Ideal Skills and Experience: - Proficiency in Excel: The data prepared to do is in an Excel spreadsheet format, so advanced Excel skills are essential. However I also have a full list of my trades that is only in pdf. - Financial Analysis: A solid background in financial analysis and portfolio management is necessary for this project. The ideal candidate will have a keen eye for detail and the ability to provide reliab...
As your assistant for this project, my job will be to type data into an Excel spreadsheet. However, I currently don't have specific information on what type of data (text, numbers, dates) you require. Additionally, I need clarification on whether you have any specific formatting needs for the data and if any calculations or formulas will need to be applied. Ideal Skills: - Proficient in Microsoft Excel - Precise and quick typing ability - Understanding of Excel formulas (just in case) Your prompt response to these questions will help ensure successful completion of your project. Looking forward to working with you!
...WhatsApp whenever new data is entered into an AppSheet application connected to Google Sheets. Key Requirements: Integration between AppSheet and Google Sheets is already established. Develop a mechanism to trigger notifications in real-time whenever a new entry is made in the Google Sheet through AppSheet. Create customizable message templates to populate WhatsApp messages with data from the newly entered form. Ensure secure and reliable communication between AppSheet and WhatsApp Business API. Implement error handling mechanisms to address any potential issues during data transfer and messaging. Technical Approach: Utilize the WhatsApp Business API to establish a communication channel between AppSheet and WhatsApp. Implement webhooks in AppSheet to det...
I'm seeking a professional with expert knowledge in precision analog design. Goal of the project is a small prototype board to measure K type thermocouple elements - with two different approaches. Additiona...ADC proposition the project comprisis of a full circuit and PCB creation. Additionaly also the needed firmware for the respective communication (over SPI) shall be properly implemented (well structured and with readable comments). Finally also testing should take please for measure the achievable performance of the proposed and implemented solutions. Please read carefully the attached project sheet with even more details. Looking forward to work together with an experienced engineer in the analog design and embedded domain. Feel free posing any questions before bidding f...
...architectural drawings in an impressive and articulate format. So, if you've got strong knowledge of residential architecture and experience with these software tools, you could be the perfect fit for this project. Your expertise is paramount for the success of my architectural drafts and interior designs. Individuals with a detailed-oriented mindset and the ability to think outside the box will excel in this project....
I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this tas...
...integrate my Google Sheet board into my WordPress website. To make it simple I want to do the same as this plugin without using this plugin: Key Project Details: - **Data Types**: I need to display text content, numerical data, and images from the Google Sheet. - **Update Frequency**: I would like the data to be updated on the website in real-time, so it should be refreshed every time there's a change in the Google Sheet. - **Design**: I already have a specific design in mind for how this data should be displayed. Ideal Skills and Experience: - **Google Sheets API**: You should be familiar with the Google Sheets API and how to fetch data from a Google Sheet. - **WordPress Development**:
• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extr...
For my expanding fashion business, I'm on the hunt for inspired and skilled fashion designers -- those who excel in creating both underwear, swimwear, and sleepwear for Womens. But, the real cherry on top would be a knack for lingrie designs. Key Requirements: - Ability to create unique, innovative designs that target different audiences - Proficiency in both trendy and classic styles. We value versatility! - Expertise in working within a monochrome and neutral color scheme Desired Skills: - Expert knowledge of fashion trends in underwear, swimwear and sleepwear - Exceptional creativity and innovation - Strong sketching skills with attention to detail With your help, we can revolutionize the market by producing designs that encapsulate both the traditional classics and...
I'm seeking a meticulous data entry operator capable of transferring data from digital documents to an Excel sheet. This task involves: - Taking solely textual data from digital documents. - Conducting minor internet research and using ChatGPT when necessary to fully understand the instructions. - Accurately entering the required information on the provided Excel sheet. The ideal candidate for this job is one who is proficient in the use of Excel spreadsheets and has excellent attention to detail. Previous work experience in a similar data entry role is advantageous. This work is specifically in the context of creating content for product listings in e-commerce sites. So if you have specific experience in this area, tha...
I require a freelancer proficient in excel to assist with data cleaning and sorting tasks for a range of diverse digital files. Your expertise in managing and optimising Excel spreadsheets will be invaluable and greatly appreciated. Key tasks will include: - Using Excel functions to clean datasets, removing discrepancies and inaccuracies - Sorting data into relevant fields and categories for easier access and analysis The optimal freelancer will have: - A meticulous eye for detail to ensure data accuracy - An understanding of Excel formulae and functions - Proven data cleaning and sorting experience - The ability to meet tight deadlines without compromising quality. Your primary role will be to untangle and streamline my Exce...
I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail w...
...that allows users to input data, which will be used to generate a PDF report periodically, specifically on a monthly or quarterly basis. Key Points: - The system should support user data input with ease, ensuring a smooth experience for those entering the information. - The PDF report generated should resemble an Excel sheet, with a detailed summary of the data provided. - We require the PDF report to be accessible at any time, allowing us to retrieve the most recent data whenever needed. - The system needs to be designed in a way that ensures the totals in the PDF report can be used for various purposes, such as tax filings and sharing information with third parties. Ideal Skills and Experience: - Proficiency in web development with a focus ...
As discussed I have completed the template for Home Team Workbook.
I'm seeking a home-based freelancer proficient in Microsoft Word, Excel, PowerPoint, Outlook, and Tally ERP 9 for a variety of tasks. Key Responsibilities: - Data Entry: Accurate, timely, and efficient data entry support is a core requirement. - Document Formatting: Assistance with formatting a range of documents, ensuring a professional and consistent appearance. Ideal Skills & Experience: - Proficiency in Microsoft Office Suite: You should have a strong command of Word, Excel, PowerPoint, and Outlook. - Data Entry: A proven track record in data entry, with a focus on maintaining a high level of accuracy and meeting deadlines. - Tally ERP 9: Experience in using Tally ERP 9 is preferred, but training can also be provided. - Organizatio...
...seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The f...
I require a coder proficient in Ctrader Indicator development to execute my vision. I need an indicator that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the s...vision. I need an indicator that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the size of a body and total size of the CURRENT candle in the current time frame. It should also display the following on a new line according to this Excel formula: =IF(BODY<=(CANDLE/2);"LLX";"...
...Key Project Details: - The PDF invoices I frequently deal with come in both scanned image and digital (text-based) formats. - The extracted data from these invoices must be: - Directly integrated into Sales and Purchase Invoice Module for further processing - Exported to Excel/CSV files - Directly integrated into accounting software Ideal Skills and Experience: - Proficiency in OCR technology - Strong background in invoice processing and automation - Experience with integrating software systems, particularly accounting and invoicing modules - Ability to work with both scanned image and digital PDFs - Proficient in data export to Excel/CSV files If you have a track record of successfully implementing OCR-based automation solutions and you...
...experience for end users - Incorporate Task/Project Management functionality Ideal Candidate: - Extensive experience in UI/UX design for SaaS platforms - Having prior experience in creating interfaces for large enterprises - Background in designing platforms to streamline business processes - Understanding of how to design for ATS and Recruitment Management tools. This is a new project with a blank sheet of paper to start with. I need an experienced SaaS designer to take ownership of all UI and UX aspects, you must understand the ATS and recruitment space and be able to design modern Admin dashboards and think creatively about workflow management. Initially, the requirements will be to create a Figma design and then a clickable prototype. This will be an ongoing role for th...
Edit sheet music book in pdf for proper UK English and any other issues. I have set the maximum hours at 2 hours for the work.
...system that can take data from the existing Excel files and convert them into customized PDF reports. Key Points: - The primary data source is existing Excel files. This means you need to have the ability to efficiently extract and interpret data from these files. - The PDF reports need to be customized with personalized data fields. So, you should be able to dynamically merge data from Excel into the PDF reports. - Proficiency in PDF generation tools and Excel data manipulation is essential. Your responsibilities will include: - Developing a system that can accurately generate customized PDF reports using data from Excel files. - Ensuring that the system is user-friendly and can be easily adopted by...
I have a Google sheet where bi I want to send automatic WhatsApp message to people when I enter something on the Google sheet cell this should be automatic and real time
I want to build anything which enables me to send customized whatsapp message as well as images from excel sheets
I want to get a extension which can send messages and images from whatsapp web using numbers and other data from excel sheet
I would like a script, where i take entries from my customers based on their choices and preference and their budget and then i allocate a salesman to the customer, I would like to automate the process by writing a script in google sheet which will check for various variables from past 1 month and then allocate the sales which did best for that customer requirement.
...experience for end users - Incorporate Task/Project Management functionality Ideal Candidate: - Extensive experience in UI/UX design for SaaS platforms - Having prior experience in creating interfaces for large enterprises - Background in designing platforms to streamline business processes - Understanding of how to design for ATS and Recruitment Management tools. This is a new project with a blank sheet of paper to start with. I need an experienced SaaS designer to take ownership of all UI and UX aspects, you must understand the ATS and recruitment space and be able to design modern Admin dashboards and think creatively about workflow management. Initially, the requirements will be to create a Figma design and then a clickable prototype. This will be an ongoing role for th...
Here is a list of 35000 phone numbers. I need the american country code, +1, added to each entry. There is a way on excel to do this pretty quickly, I just dont know if, hoping you do.
I have an Excel data set that encompasses 5-10 sheets. I need support in: - Data entry: Entering new information into the existing sheets. - Data cleaning: Checking and correcting any errors in the data, removing redundancies. - Data analysis: Conducting basic analysis of data. Ideal applicants should have beginner proficiency in these tasks. Your experience working with Excel data files, especially handling entry, cleaning, and analysis tasks, will greatly benefit this project.
I'm looking for an intermediate Excel expert to create a user-friendly database system for managing contacts and tracking outgoing information. Key Requirements: - Develop a simple yet effective database system within Excel. - Design a user interface that is intuitive and user-friendly. - Ensure the system is structured to manage contacts efficiently. - Implement a feature to track when and what information is sent to each contact. What I'm looking for: - A freelancer with a proven experience in working with Excel and developing databases. - An intermediate level of proficiency in Excel. Advanced skills are not necessary, but a basic understanding won't suffice. - Ideally, I'd like the freelancer to have experience in designing user interfa...
I need a Laravel programmer with FreeScout experience to develop a custom module that will introduce up to 4 additional links to the navigation or menu bar. These links will open a new browser tab to external websites not related to the FreeScout/Laravel installation. For example, a link to a Google Doc or Google Sheet. Key requirements: - The custom Module must be compatible with the latest version of FreeScout. - The custom navigation bar options should continue the existing FreeScout top menu bar. - The links should work in both light and dark modes without errors. You will be required to: - Program the custom FreeScout Module so it can be installed onto any installation. - Ensure the custom Module works with the latest version of FreeScout and is bug-free. - Ensure there are...
I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.
Hi, Minimum requirements: 1. text images (exam style questions) are loaded to Google Drive. (we have already done this) 2. Scan the Google Drive folder for new images. 3. Run new image through Google OCR/Document AI service. 4. Save to master file (e.g. Google Sheet, Doc) that can be accessed by multiple people Ideal scenario (optional): 5. Link to ChatGPT api (we have this already setup) 6. Run question/prompt and return answer to the sheet.
...the SEO strategy based on data Ideal Skills: - Advanced SEO techniques - Domain Authority building - Backlinking strategies - Education sector knowledge Please provide examples of previous work in the education sector and your approach to achieving the outlined goals. Can I have a concrete plan for SEO, DA and DR () keywords for music teaching supplies elementary music education books general music curriculum music lesson plans for elementary students music teacher curriculum music curriculum kindergarten music curriculum music sub plans for elementary general music unit plans elementary music curriculum free homeschool music curriculum music resources for primary teachers music books music theory books music theory sheet lesson plans for music teachers
I'm in need of a professional proficient in Excel and data entry to support two key tasks: data analysis and spreadsheet management. Here are the tasks in detail: - Data Analysis & Visualization: I've collected customer feedback data which need to be efficiently analysed and visualized. - Spreadsheet Creation & Management: The data mentioned above should be incorporated into comprehensible spreadsheets. In terms of analysis, the focus should be on customer segmentation. Ideal candidates should have: - Advanced proficiency in Excel for data analysis and visualization - Strong understanding of data cleaning and formatting to ensure accurate analysis - Experience with customer segmentation based on feedbac...
...looking for an experienced data analyst who possesses expert skills in Excel and/or Google Sheets and a proficient understanding of Football, Basketball, and Baseball data. Ideally, someone who is skillful with analyzing and interpreting commercial level sports data into the form a betting model that understands, quantifies, and predicts based on specific metrics. The key characteristics of the models are: - Focus on the following sports: Football, Basketball, Baseball - Analyze the following data: Team performance, Player statistics and Game score projections to forecast point spread, totals, and moneyline bets. I have historical data ready to be applied to these models. This is a project where being communicative, organized, and kno...
as per communication, transfer data from DPF to excel.
I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.
...from Excel sheet to What's app Number (At certain condition and without opening the internet browser). Ideal Candidate: - Strong experience in integrating Excel with external systems. - Proficiency in WhatsApp and Excel automation. - Ability to create a reliable and efficient sync process. - Understanding of data processing security and privacy. So, If you're able to send notifications into my what's app number from excel sheet, Then; You're welcome and this contest is for you. Details: I'm engineer, Working for an industrial company and really want to handle the spare parts with the inventory and purchasing managements for assuring that all spare parts available with certain quantities all the time. Requireme...
I want to rank in the top three google results on average for the following keyword phrases Target Country is USA 1 - Accident L...work with me to achieve great rankings. If I say something needs tweaked a bit, I expect the team to listen to my desires as long as those desires will reach the end goal. While working on the main keywords, I expect additional keyword phrases to be used in Chat GDP blog and wiki articles that would benefit the website. That way not all backlinks will be from the list of 20. We can use our excel sheet from previous projects for this. I should see a drastic increase in DA and PA of the website. Do not click on adsense advertisements. This is grounds for dismissal of project. Post the phrase #seoGuru so I know you read and understand and agre...
I want to rank in the top three google results on average for the following keyword phrases Target Country is USA 1 - Accident Lawyers 2 - Truck Accident Lawyers 3 - Car Accident Lawyers 4 - Boat Accident Lawyers...work with me to achieve great rankings. If I say something needs tweaked a bit, I expect the team to listen to my desires as long as those desires will reach the end goal. While working on the main keywords, I expect additional keyword phrases to be used in Chat GDP blog and wiki articles that would benefit the website. That way not all backlinks will be from the list of 20. We can use our excel sheet from previous projects for this. I should see a drastic increase in DA and PA of the website. Post the phrase #seoGuru so I know you read and understand and agre...
I'm looking for a skilled freelancer who can create an automated Excel spreadsheet calculation for me. I need this spreadsheet to perform calculations based on cumulative data, specifically organized by date. You will need to be adept at Excel and have experience in creating automated spreadsheets. Knowledge of data organization and basic statistics would be a plus. I'm looking for a quick turnaround on this project. Please watch my videos for more details on what exactly is required.
Google sheet has 5 columns. From the user interface you have to select 4 choices from left to right via drop-down boxes. Once the choices have been made, which must lead to the selection (if possible) of one or more choices, the final result selected in the fourth column must print in the user interface, the contents of the fourth and fifth columns (the latter is a link) . The interface must have a background color, a text with a provided font, and two small images.
...construction firm, we have accumulated vast financial data that requires thorough analysis. Our motivation to perform this task is to better understand what the data says about our operations and ultimately enable us to make strategic project decisions. Details - The task involves analyzing complex financial data associated with our road construction projects. - We need to focus on key financial metrics, including project costs, ROI, profit margins and forecasting future financial scenarios. Skills and Experience - Proficiency in Excel at an advanced level - Background in finance, ideally with a focus in project finance. - Experience in construction sector would be an advantage. - Ability to analyze and interpret complex financial data and present i...
...(say 3 years, but flexible according to the data) on all of 1-3 above 5. All of above (1-4) presented in editable charts with editable excel files and all referenced by source of info and date NICE TO HAVE a. Total existing value of savings and investments in the UK and EU by investment media/category. b. total existing value of current accounts (and separately) savings accounts in banks/bldg societies in the UK and (ideally separately) the EU c. Average spend on accommodation of holiday-makers (or by household) vacationing each year by UK or EU country and trends/expectations for future c. Least important - comparisons/splits of any of 1-5 and a.-b., between UK and different EU countries The required timeframe for this data is annually. Data should be not...
1. Redesign website. 2. Structure website and informative data according to target customers to be easier for them ( Projects/consultant , Distributers and end users ) for Projects/consultant (They are more likely looking of in depth technical deals, data sheet ,specification and pre-qualification and approvals and Distributers more price oriented and for end users they are the customers who are googling for piping and thermal insulation solution for their houses , villas and private projects. 3. One domain and three factories. 4. Adding our corporate identity theme to the website.
I'm looking for an Excel expert to automate various tasks relating to our tracking system and create an intuitive dashboard. The tasks will involve automation of formula calculations and report generation, to streamline our data processing workflow, and reduce human error. Key tasks include: - Automate formula calculations: Efficiently automate intricate excel formula calculations. - Automatic report generation: Create a mechanism for generating immediate, error-free reports that highlight key aspects. - Dashboard creation: Design a user-friendly dashboard displaying information based on Automatic report Generation. The ideal freelancer for this job should have: - A deep understanding of Excel's advanced features; - Previous experience with automatio...