Excel macro sort data existing sheets jobs
I have a project where I need someone to extract data from PDF files and input it into an Excel spreadsheet. Key Requirements: - Extracting data from PDF files - Inputting the extracted data into an Excel spreadsheet Ideal Skills and Experience: - Proficiency in data entry - Experience with data extraction from PDF files - Advanced Excel skills - Attention to detail and accuracy
...need of a highly skilled MS Excel professional who can deliver moderate complexity tasks within a tight deadline of 10 days. The project consists of 72 individual tasks involving: - Data visualization - Spreadsheet formulation - Creation and implementation of advanced formulas and macros I am looking for someone who works efficiently, pays attention to detail and is highly skilled in all aspects of MS Excel. A proficient understanding of data analysis and visual representation is definitely a plus. The job demands the combined ability to work rapidly without compromising on quality. The ideal candidate should be ready to start as quickly as possible, adhering to the constraint of a strict timescale for completing all the subtasks. Speed and proficiency ...
...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in proces...
...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in proces...
I need to scrape base salary information from Glassdoor for about 2000 companies. Key project requirements: - Scraping Glassdoor for base salary and range info only for every job function/title. - Compiling this data into an Excel spreadsheet Ideal skills include: - Proficient in web scraping techniques - Experience with data analysis Website: (it is free but need to register and complete the profile to see the information)
Hi guys, we have an excel contact list. In that list we have persons & companies with their contact details. We coded an script wich monitors an gmail inbox. When emails are sent from specific mails to this inbox the python script should read the body and depending on the request in mail syript should send requested Excel back. There are 8 different excel saved locally wich the script can take and send back. So depending on the contect of the mail script should choose the right excel file and send this with an text like "here your requested Contact List Periskop in attachment. kind regards" If its help. in attachmend an little python script we wrote to send back an mail
As an entrepreneur, I'm swamped with a ton of tasks and need a hand to get things done efficiently. I'm on the lookout for a profess...spreadsheet tasks. Here's what the job entails: - Managing my emails and scheduling appointments - Helping with light accounting and maintaining spreadsheets - Entrusted with some data entry duties The ideal candidate would have: - Proven experience in similar roles - Exceptional command over English - Strong skills in using spreadsheet and email tools You should expect to work around 10-20 hours a week. This job requires professional-level English fluency given the nature of the tasks at hand. Excellent organizational skills and an eye for detail would be a big plus for this role. If this sounds like a role you can excel...
I am in need of financial an expert who can develop a thorough financial model . The model should be able to accurately forecast future financial performance, and help steer my investment decisions. 1-Building up a comprehensive financial model (financial statements, valuation, returns) of the ...and outlook).Preferable segment within the Education market to target. 4-Analysis of proposed target (operational/financial) 5-Discussion of projections (assumptions/results) 6-Recommendation of proposal with justifications Key Skills and Experience: - Proficient in financial modeling - Business forecasting and investment analysis experience - Advanced knowledge of financial data including income statements, balance sheets, and cash flow statements. The work should be complete...
I'm seeking a proficient Excel expert to create a master file for our NDT inspection reports. This master file will centralize all our reports and serve as a robust tool for analysis and reporting. Key Task Requirements: - Integrate worksheets from a master worksheet using advanced Excel formulas and functions, ensuring seamless data pulling. - Design needed features including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in...
i have a few functions that need to be done. you will have to load a excel doc to get everything to work but most aren't horrible.
I'm looking for an expert in data entry to help me with a particular task. - This will include rearranging the columns or just retyping into a new speadsheet. Super easy, I just don't have the time. Using the Fedex Fissler spreadsheet information, and inputting only the necessary information in the format provided on the second spreadsheet called Fissler Spreadsheet corrected. We only need to capture; Name, Address, city, state, zip, service type and actual weight. This project requires a meticulous eye for detail and an ability to work efficiently with data. Experience with Excel or Google Sheets is a must. Please get in touch if this sounds like a job you'd be interested in.
I am in need of a freelancer who can help me gather contact details from a couple of websites and organize them neatly in an Excel sheet. Key Details: - Websites: I have a couple of websites I need information from. The information is public and doesn't require any special access. - Information Needed: I'm interested in contact details such as phone numbers and email addresses. - Excel Organization: I want the contact details to be listed in a single list without any specific categorization. Skills and Experience: - Web Scrapping: You should have experience in web scrapping to efficiently extract the contact information required. - Data Entry: Proficient in Excel and attentive to detail to ensure the information is accurately documented. - Profici...
I'm in need of an experienced Excel programmer to create a customized program for data analysis. The primary purpose of the program is to assist in data analysis. Thus, it should help in organizing and interpreting large sets of data. The program will need to handle data from two main sources: - Text files (CSV, TXT) - Manual input The ideal freelancer for this job should have a strong background in Excel programming and data analysis, with specific experience in handling various data types and creating efficient, user-friendly Excel programs. Key Skills: - Proficient in Excel programming - Skilled in data analysis - Experience working with text files and manual input - Ability to create user-friend...
...another account in Zerodha. Functionality – 1) Login: Take credentials from excel like username, password ,API key , secret code, totp key and totp from authenticator for all accounts (master and child both) (basically after generating token) - all these on a single click on starting python file. 2) Order Punch: Copy all orders including NRML (SL-M , SL – limit) and MIS (SL-M , SL – limit) GTT, and trades (only completed- not rejected) from the main account to child accounts 3) Order Modification: If we cancel/modify any order on price and quantity, the cancellation/modify should also be cancelled/modified in all accounts 4) Primary account selection : Should have functionality of changing the primary account in excel , we can have predefined criteria for...
...change any dimention or any mechanism. Just work in the interior and exterior’s look, It will be great if you can rig the model and create a short animation explain it. Please include your previous automotive design portfolio . Description: We require a skilled 3D artistTitle: Enhancing a Shuttle Car Model for Explainer Video (Investor Focus) with automotive design experience to elevate our existing STL model of a shuttle car. Our goal is to achieve a hyper-realistic aesthetic that will captivate potential investors for an explainer video. Key points: We have a finalized STL model of the shuttle car (dimensions and mechanisms are locked). Your focus should be on enhancing the interior and exterior for a realistic appearance. Bonus points for rigging the model and creatin...
I need one slide animation from the below provided PPT. See Slide #7 For the top performers slide I want to confirm that when we get to that slide no names are shown until I press the clicker and then starting with the position 5 on credit applications the first name is shown and then I click again and poistion 4 is shown all the way to the #1 position. Then when I...press the clicker and then starting with the position 5 on credit applications the first name is shown and then I click again and poistion 4 is shown all the way to the #1 position. Then when I click again I see position 5 for applications, then 4, all the way to #1. Then we can start on fundings position 5 and go through to position 1 and when I press position 1 for the funding category I get some sort of celebratory...
I have a challenging case study that requires a thorough analysis of sales data and survey data. I'm looking for an expert who is well-versed in Excel to help me with this task. Key tasks and requirements: - You'll need to perform trend analysis on the sales data. - You'll also be required to visualize the sales and survey data. This will include a detailed geographical analysis. - The data visualization should be able to provide clear insights and comparisons between different variables. Ideal Skills & Experience: - Proficiency in Excel, including advanced data analysis features. - Experience with trend analysis and data visualization. - Previous experience with geographical analysis is a plus.
I have a photo that contains a mix of text, tables, charts, and images that need to be converted into Excel and Word formats. The key requirements are: - The data in the photo must be completely editable in both Excel and Word. This includes all text, tables, charts, and images. - The photo contains a mix of content, including text, tables, charts, and images. It's important that the freelancer is able to accurately capture and translate all of this information into the Excel and Word formats. Ideal skills and experience for this job include: - Proficiency in data entry and extraction. - Advanced skills in using Microsoft Excel and Word. - Experience in handling mixed content (text, tables, charts, images), and the ability to accurately r...
The developer must be able to create an app that can ... 1. open a video of a wrestling match. 2. app will be able to "mark" various spots within the wrestling match that will interest an evaluator. 3. the marks are created by clicking on a button where the evaluator must go to review. 4. The app will create a score using Google Sheets. We are seeking a skilled video editor to mark several training videos using a custom screen. The marked areas will not only serve copyright protection interests but also provide necessary instructions to aid in understanding video content. Key tasks include: An ideal candidate would have noteworthy experience editing training videos and a solid understanding of copyright protection. A flair for seamlessly conveying instructions throug...
I require an Excel expert to help me create and modify spreadsheets. Specifically, I need assistance in incorporating certain functions and features in the spreadsheet, as well as handling various types of data. Key Requirements: - Spreadsheet Creation and Modification: I need someone who is proficient in Excel and can help me set up and adjust spreadsheets to my specifications. - Data Visualization: The ability to create charts, graphs, and other visual representations of the data is crucial for my project. - Automated Reports: I'm seeking assistance in automating certain processes in my spreadsheet to generate reports efficiently. - Conditional Formatting: I will also need help with setting up conditional formatting in the spreadsheet. Data...
I'm on the hunt for a creative designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-...designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-catching, yet minimalist packaging. - Proven track record – please include examples of your past work in your application. If you excel in minimalist design and have a passion for creating str...
This project aims to automate the order confirmation process for transactions using Pipedream, a workflow automation platform. Data Source: API request Project Steps: Data Capture: Upon receiving a API request, Pipedream will extract the following information: Order number Customer name Email address Order date Mobile number Pickup address Drop address Google Sheet Integration: The captured data will be automatically stored in a designated Google Sheet for record-keeping and future reference. Multi-Channel User Confirmation: SMS Notification: Pipedream will trigger an SMS confirmation using and , notifying the customer about their order details. WhatsApp Notification (Official API): will be integrated to send a WhatsApp
I need assistance in setting up a mail merge (publipostage) in Excel to report information from the Excel sheet into a Word template. Key requirements: - Excel Data Analysis: You should have experience in data analysis using Excel. - Mail Merge: Proficiency in creating mail merge documents in Excel advanced - Word Template Populating: Understanding of how to populate Word templates with data from Excel. It's important that only the text information from the Excel file should be included in the Word template. Ideal skills and experience: - Proficiency in Excel and Word - Experience in data analysis - Familiarity with mail merge functionality - Previous experience in setting up similar Excel...
Hi everybody, We need a full time data organizer who will be putting out bank statements into a proper excel format (which we will give). Please note that you will 70-90% of monthly work and you can keep taking other projects as well but we will give you full time pay of USD 500 and you have to remain available to us We have access to Able2Extract and can provide you a proper converted excel statement. However, in some cases, bank statements could be a scanned copy and hence you may need to manually enter data. This is a full time job and budget is reasonably fixed. Require an excel expert pro as there has to be a lot of data shuffling and data organizing into different folders. Need someone who can start immediately Thak you.
Hello, The following checkout page has been created by another dev using a woocommerce plugin The current plugin uses Attributes and Variations to identify the right product, but I need to have multiple individual products on woocommerce. I want to modify the existing plugin or create a new one in such a way that when a product is chosen on the front end, the relevant product is sold on the backend woocommerce products. The design has to be modified a bit too in order to match the homepage. Also, required is the Payment integration. My max budget for this gig is $50, any quote above that will be completely ignored. Thanks.
I am looking for someone to assist me with data entry and related tasks in Excel and Word. I need some typing, copy and paste type of data, that needs to be entered in systematic way. Skills and Experience: - working in Excel/Word - Attention to detail - Experience with data entry or typing - Ability to follow instructions and work independently Preferred Format or Template: While I don't have a specific format or template in mind, I have a rough idea of how I would like the data to be arranged. I am open to suggestions and willing to collaborate on finding the most useful format for the data. If you have experience in data entry and are comfortable working with Excel and Word, please submit your proposal and include a...
I'm looking for an Excel expert to create a robust three-level lookup function that can handle text data. The primary goal of this function is to facilitate data analysis, and it needs to be followed by basic arithmetic operations based on the result of the lookups. Key requirements: - The Excel function should have a three-level lookup that can handle text data. - The primary goal of the function is data analysis. - After the lookup, basic arithmetic operations should be performed based on the result. - The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" sheet wi...
I have a mobile app using expo react-native on the front end and using django as the backend. I would like to have authentication with firebase. My goal is to allow login with phone number. I need someone familiar with those technologies that can implement an easy login flow.
details as in "pair programming / code walkthrough" description
...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in proces...
I'm looking for a skilled individual to assist with a less than ten PDF documents data entry project. Key Responsibilities: - Copy typing of content from PDFs - Extraction of specific data points - Validation for accuracy and completeness This role will suit someone with proven expertise in data entry and validation. The ideal candidate is detail-oriented and proficient in handling PDF documents. Experience with Microsoft Excel is a plus.
I am seeking a skilled g...designer who can recreate the checklists, cheat sheets, and infographics found on a in .eps and .ai vector formats. This will include about 50 selected items. Just text and layout. No challenging graphics recreation. Your work will involve: - Helping me finalize the selection of items based on a few that I have already identified. - Feasibly reproducing the exact designs in .eps and .ai vector formats. I’d like the ability to customise the colors easily after delivery. Ideal candidates should have proficiency in creating vector graphics, a keen eye for detail in replication work, and be ready to collaborate on the selection process. It’s critical that the created vectors are near exact replicas of the existing designs.
I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions
I'm in need of a data entry freelancer with a good command of Microsoft Excel. The task involves inputting data into a spreadsheet. The data is simple and involves just a few columns. This is an ideal project for a freelancer who is available to work from home. Ideal skills for this job include: - Proficiency in Microsoft Excel - Attention to detail - Ability to maintain accuracy while working with data Please note that I don't require any specific software knowledge other than Microsoft Excel. Looking forward to working together.
I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions
I'm seeking an experienced professional who excel...seeking an experienced professional who excels in sophisticated data analysis, chart creation and process automation using Excel. You'll need to leverage data visualization techniques to deliver insightful dashboards, with a key focus on developing pie charts for clear, concise, and impactful data representation. Your responsibilities will include: - Analyzing and interpreting complex data sets - Crafting well-structured and insightful pie charts - Automating repetitive processes to improve productivity Core competencies required for this role include a strong background in Excel and data analytics, proficiency in dashboard creation, a keen understanding of automation process...
I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with ‘In...
...workforce. Key Responsibilities: - Develop a structured sales training program encompassing various selling techniques, customer service, and product knowledge reinforcement. - Create engaging and interactive product training sessions that educate employees about our offerings, benefits, and unique selling points. - Implement a series of on-the-job training modules that help employees grasp and excel in their roles, while aligning their efforts with organizational goals. Ideal Candidate: - Experience in designing and delivering comprehensive sales and product training programs. - Proven track record in conducting engaging and effective online and offline training sessions. - A solid understanding of adult learning principles, particularly in a corporate setting. - Excellent com...
I am seeking a skilled and experienced individual to make a website for me guide me in the development of my website. Details: - The website should be built with WordPress or GitHub, but I'm open to suggestions. I am inexperienced, so I need guidance in choosing the right platform. - The site is expected to have 5-10 pages, including essenti...payment gateway. Ideal skills and experience: - Proficiency in WordPress or GitHub, with a portfolio of past projects. - Experience in designing and implementing e-commerce platforms. - Excellent communication skills, patience, and the ability to explain technical concepts clearly. - Knowledge of various payment gateways and their integration with websites. If you believe you can provide this sort of services, please bid and let...
... Key Responsibilities: As the Backend Developer for this project you will: 1. Design and develop scalable server-side applications. 2. Implement robust APIs for seamless communication with the Flutter client. 3. Integrate third-party services to enhance platform features. 4. Manage data storage solutions and optimize database performance. 5. Ensure server-side code is optimized for performance and reliability. 6. Implement security measures to protect user data. Requirements: To excel in this role, you should: 1. Have proven backend development experience. 2. Be proficient in backend programming languages like Python, Node.js, or Java. 3. Have familiarity with web frameworks such as Django, Flask, or Spring Boot. 4. Understand RESTful API des...
...of the jazz venues myself and will upload the data to a Google Sheets file. See file here: - I have designed the website myself in Figma. PDFs of design attached hereto. - Preferably based on Wordpress, but open to other suggestions. - Scales nicely on mobile devices (i have only designed for a desktop frame) and works in different browsers; - Website contains one web page: the home page and a concert popup overlaying most of the screen when activated. - No third party paid licences should be required to run the website. - Google analytics and mailchimp integration - In the backend, I should be able to upload the concerts from the Google Sheets list (automatic or manually). The backend should
I'm looking for a Google Sheets expert who can create formulas, automate data calculations, and provide data analysis and reporting. The successful freelancer will need to automate data input from a website or database. Ideal Skills & Experience: - Proven expertise in Google Sheets, particularly in formula creation and automation. - Experience in data analysis and reporting. - Demonstrated ability to automate data input from websites or databases. - Strong communication skills and ability to provide detailed project proposals.
I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.
I'm seeking a freelancer who can develop an automated system in Excel to manage backorders. This system must create new data for efficient backorder handling. Specific requirements include: • Creation of an automation tool that handles numeric values, text strings, and dates and times. • The system should adequately track product lead times and inventory levels, despite not automatically generating reports. Please note, having prior experience in backorder management and Excel automation will be advantageous for this project. The ideal freelancer should have strong data handling capabilities and excellent knowledge of Excel. Proven experience in similar projects is preferred.
Need a backend developer to implement below requirements in client's existing code base. 1. Feign clients 2. Request and the response interceptors 3. For opt in, only mobile number to be passed as param to the feign client's method - ("919999784665"); 3. For sending sms, only mobile number and msg to be passed as param to the feign client's method - ("919999784665", "Hey there I am using whatsapp"); 4. All other query params to be inserted via request interceptor 5. userid and password to be picked from yml file, they will be different for different environments. 6. For both the APIs we'll have response interceptors which will check if the 'id' given in 'response' corresponds to one of the error codes. If ...
...a growing commercial photography business with about a dozen photographers under me. My current solution for managing workflow (job status, assigning photographers, accounting for payouts) is done through Google Sheets. I'd like to explore the potential of Airtable (and possibly other platforms) as a replacement. Objective 1 Consolidated Spreadsheet/Database. I currently use a spreadsheet (Google Sheets) for each photographer when assigning jobs. This requires excessive data movement and tracking. If feasible, I'd like to construct a spreadsheet/database where all the data is consolidated. Access by users (photographers) will be confined to the jobs they are assigned. Ideally, a more centralized and manageable solution can be put in place...
I need an experienced freelancer to create a chart with interest rates in Canada for every month between January 2015 and the current month. K...between January 2015 and the current month. Key Requirements: - The chart should accurately reflect the fluctuation in interest rates over the specified time period. - The format must be an excel which is easy to read and interpret. - No additional analytics features such as trend lines or forecasts are necessary, the primary focus is to clearly display interest rates by month. Ideal Skills: - Research historical interest rates in canada - Proficient in Excel and creating line graphs. - Strong understanding of financial data, specifically interest rates. - Eye for detail and ability to ensure the data is clearly pr...
...password via SMS that they will need to enter in order to log in to their account. Addon developent for a Job Portal, Laravel & Api expert needed Modules/Controllers will be developed: User Management Module: -User registration and login functionality using zender or whatsapp, twilio, nexmo for otp( email and social login already available). -User profile management export function with search and sort. Package Management Module: -Allow users to view available packages. -Enable users to select a package based on the number of applications, profile validity duration, and vacancy details view limit. Coupon System Module: -Allowing users to enter coupon codes for discounts. -Validating and applying coupon discounts during the payment process. Admin Panel: -Dynamic configur...
