Excel macro fill empty cells işler
I'm in need of a proficient individual with strong data extraction skills and a good knowledge of Excel. The task is focused on extracting both text and image data from 1-2 websites. It is essential for the freelancer to have capabilities in: • Website data extraction • Handling of both text and image data • Organizing and managing the extracted data in Excel. An eye for detail and a knack for organization would be key for this project. Experience in similar projects is also a great advantage. This task requires utmost accuracy and adherence to deadlines, thus a freelancer with a track record for prompt delivery would be ideal.
...(BuddyPress) / KiwiIRC and UnrealIRCD. Your tasks will revolve around the following: Creating a plugin / module from which: - Users authenticate with their BuddyPress account on the startscreen of Kiwi IRC, after which their A/S/L/Profile picture/Profile link is loaded and shown on Kiwi. (We have the ASL plugin which works without authentication where users fill the information and connect, but this is not enough). - Unauthenticated users (guests) can fill in their a/s/l and a default avatar is loaded. - Installing/configuring the file-upload plugin which already excists. • Proficiency in Vue.js and PHP is a must. • Knowledge of WordPress and BuddyPress is critical. You will be required to utilize these tools extensively. • Knowledge of IRC, KiwiIRC, Wo...
I need an expert to assist with converting PDF and Excel files into IIF to incorporate into my QuickBooks accounting software. This integration will be key in the transparency and efficiency of my financial transactions. Key responsibilities: - Convert files from PDF and Excel to IIF. - Ensure compatible formatting with QuickBooks. - Sort IIF files by transaction type for easy navigation and organization. Skills and experience: - Proficient in QuickBooks and IIF format. - Accurate data entry. - Deep understanding of accounting principles and financial data organization.
I'm looking for a skilled individual with a keen eye for detail to create an Excel spreadsheet. This sheet will be handling different insurance companies' appetite guidelines, which are broken down by state. For example, I need to know which carriers write workers compensation in New Jersey Key Requirements are: - Excellent knowledge of Microsoft Excel for data organization and management. In your application, please include your asking price for this fixed rate project. Previous experience in the insurance field or with similar projects would be a plus but isn't a necessity. Looking forward to finding the best fit for this data-driven venture.
If you know how to code a javascript or python script to get a few pieces of information from Google, then this is easy for you. Here's all we need in this small project: 1. For a particular google search ON MAPs, the program would output the web URL, and name and send that to excel (or a csv) - other fields would be provided to include as well. 2. It should let me pick 1-50 entries. 3. It should work from within the browser (NO API calls necessary). that's it! Thanks for your bid
I'm seeking an expert to create an automated dashboard, aggregating training metrics from an eLearning Management System database. It is essential that Excel functions are automated, and feeding data into this dashboard should be user-friendly. Key responsibilities: - Design a dashboard that will display updated training metrics from a database - Automate Excel functions - Allow user-friendly data import Ideal candidate: - Proficient in Excel - Knowledge of DBMS (Database Management Systems) - Familiar with eLearning Management Systems - Experience in creating user-friendly interfaces - Strong time management skills, as the project needs to be completed within a month Our understanding of the exact DBMS is currently unclear; thus the freelancer needs to be com...
Lütfen detayları görmek için Kaydolun ya da Giriş Yapın.
Hello there is a free publicly accessible Google spreadsheet with 185 lines and 21 columns. Copy and download is disable. I need someone who is still able to copy the data into an excel spreadsheet or otherwise manually "copy" all data into an excel spreedsheet thanks I offer the link to the website after receiving bids Generic bids are ignored. Therefore pls write "i understand its a download disables google spreadsheet."
...translating literature is required -- Quick turnaround: 1 day. Skills and experience needed: - Fluency in both English and Cantonese - Proven experience translating English literature to Cantonese (Traditional) - Understanding of cultural nuances in literature - Attention to maintaining the tone and style of the original text. Here is the poem to translate: Remember Me (Title) Fill not your hearts with pain and sorrow, but remember me in every tomorrow. Remember the joy, the laughter, the smiles. for I’ve gone to rest for awhile. Although my leaving causes pain and grief, my going has eased my hurt, and given me relief. So dry your eyes and remember me, not as I am now, but as I used to be. Because, I will remember you all, and look on with a...
I'm looking for a skilled data science trainer who can introduce my large team to the foundational aspects of the field. Key Responsibilities: • Deliver beginner level lectures on data science • Train over 10 team members • Cover areas inclusive of Data Analysis, Machine Learning, and Predictive Modelling Ideal Candidate: • Ex...Machine Learning, and Predictive Modelling Ideal Candidate: • Expertise in data science education • Ability to conduct engaging, accessible training sessions • In-depth knowledge of Data Analysis, Machine Learning, Predictive Modelling • Experience in training larger groups The objective of this training is to equip my team with basic data science capabilities. Thus, patient trainers who excel in bre...
I need a skilled and creative freelancer to create 100 different invoices for me in Excel. Each invoice must have its own distinct company design and company logo. Here are the specifics of the project: - I am giving you complete creative freedom to design each invoice. Let your mind run wild! - The invoices should include placeholder information whilst also leaving some areas blank. This will provide a more customizable experience. Ideal skill set includes: - Proficiency in Excel - Graphic design inclination - Creative thinking - Attention to detail Looking forward to seeing your brilliant designs shine on each invoice.
I am seeking an experienced Facebook ads manager who can effectively target an audience of educated farmers and individuals interested in job opportunities and government schemes. The primary goals for these Facebook ads are: - To drive traffic to my website - To fill a WhatsApp group that will serve as a platform for updates and announcements It is crucial that the successful freelancer is proficient in strategic audience targeting, understands the agricultural sector, and has a proven track record in achieving significant website traffic growth and lead generation. Experience in working with government schemes would be a bonus as well. I look forward to collaborating with a dedicated and results-driven professional. Let's boost our brand awareness together!
I'm looking for an expert PHP developer with proficiency in Codigniter to modify and enhance an existing script I bought from CodeCanyon. Task Details: • Modify existing func...functionality and add new features to the script. • Add three new fields to the signup window code and sync it with the mySQL database. These fields should include text fields and dropdown menus. • Create a report based on data from one table in the mySQL database. • Implement a feature to export the report data to Excel. Ideal Skills and Experience: • PHP and Codigniter expertise • Experience with SQL database manipulation • Knowledge in report generation and data exporting to Excel • Proficient in UI design with a focus on text fields and drop...
I'm in need of a developer to build a simple CRUD website. A few specifics about my requirements: 1. The website should interact with an Excel file; enabling data extraction and modification directly from and to the file and Display the records in a grid or tabular format. 2. Search option to look for connection details with Applicant ID. 3. Add a date picker to filter via date range via date of application. 4. Option to view/edit electricity connection application requests. a. Refer dataset for the data attributes. b. Could be on same or different page. 5. Data Validation. a. Should not be allowed to change some data and put validations on a few fields. Nothing complex. 6. Create a visualization graph e.g., bar or line chart for number of connection requests in every month. Th...
I require a freelancer who is proficient in extracting specific data points from a PDF document and translating it into a structured Excel or CSV file. The data is presented within paragraphs. Key Tasks: 1. Extract the following elements from the PDF: Names, dates, numerical values, lead location, phone number, email, US dollar value, status, date added. 2. Organise these elements in a structured format in an Excel or CSV file. Skills Required: - Attention to detail - Proficiency in data extraction - Strong knowledge of Excel or similar data management software - Ability to interpret information from paragraphs. Freelancer should assure accuracy as the correctness of extracted data is essential.
...themselves and to promote others to join them on the trip. It could be centered around a theme (ie., a yoga influencer, a popular musician, photographer, travel blogger), or just about the influencer themself. Absent traveling themselves, a strong following with people likely to book last minute travel on their recommendation. I had a charter client fall through at the last minute, and now I have to fill the ship - 16 cabins are available (including a complimentary cabin for the influencer). This will be my third charter of this nature, and it is truly a wonderful vacation experience. Details of the ship and itinerary are attached. I will also be onboard, to handle logistics and facilitate the guests needs on the voyage. The travel dates are May 26, 2024 to June 2, 2024. ...
I'm facing issues with mobile Ad Exchange (ADX) ads not displaying, causing a low fill rate issue on Google Ad Manager. I'm seeking an expert in troubleshooting this particular problem. Your tasks will include: - Diagnosing the root cause of mobile ads not displaying on ADX - Providing solutions to increase the fill rate on Google Ad Manager - Implementing effective strategies to prevent similar issues in the future The ideal candidate would be someone with demonstrated skills and extensive experience in Google Ad Manager and ad serving troubleshooting. Expertise in ADX and mobile advertising platforms would be a major plus.
...information. -Ensure all guest details, including name, email, phone number, reservation number, booking period, and payment information, are promptly forwarded for record-keeping and follow-up purposes. Requirements: -Strong attention to detail and accuracy in task execution. -College degree or equivalent qualification preferred. -Proficiency in basic software tools, including Microsoft Office (Word & Excel). -Ability to operate electronic devices (computer or phone) proficiently. -Fast-paced and adaptable to changing priorities. -Ability to commit to 10-30 hours per week, approximately 2-4 hours per day. -Willingness to undergo a short trial test or task, lasting 2-4 hours, with the possibility of extension up to one week if necessary. Duration: The duration of the jo...
I am presently working on an extensive project involving several excel spreadsheets. These spreadsheets contain sentences for a book and I require a freelancer to help me color code the cells based on different categories. The color will represent different aspects of each category. The color coding will include: - More than 10 different categories - Existing color suggestions that need refining - Categorization that's based on multiple factors, going beyond the book chapters The ideal freelancer for this job should possess a good understanding of Excel and have a knack for good organization and attention to detail. Strong collaboration and communication skills are key, as I'll need to discuss and finalize the color scheme and the factors affecting categor...
I'm in need of a proficient Excel expert who can proficiently apply formulas to my dataset. Here's what you'll be taking on: - Add 'Sum', 'Average' and 'Count' functions to the given data set. Your expertise in implementing these formulas will be highly valuable. - The dataset needs to be sorted based on validity. I'm not entirely certain whether ascending or descending order would work best, so I'm open to your professional advice. - Prioritization should be given to the most recent entries. They should appear at the top of the dataset after sorting. To succeed in this task, you must possess advanced understanding of Excel functionality and a keen eye for detail. An ability to work independently, make efficient decisi...
Need nay type of data entry work
Hello, I and creating a 3-year business plan. I have the first-year projection but I need to calculate the subsequent years, both 2 and 3. I need to add 15% each year which I am using year one as a basis to calculate and add 15 percent each year.
...validate data from an excel file to a database. This function should be equipped with the following features: 1. Data Type Validation 2. Data Format Validation This task requires proficiency in database structures, data validation methods, and experience working with Excel file manipulation. The ideal candidate, consequently, should be able to display capabilities in these areas. Their experience in similar projects would be a bonus. Here is the main flow: 1. User upload excel file 2. System will check and validate the data 3. System saves record into multiple tables in a database 2 types of excel files involved. Please check attachments. 3 types of data will be stored into database 1. User profile 2. User farm 3. User plant Detailed flow: 1. User u...
I'm in search of an experienced front-end developer to create a CSS, JavaScript, and HTML based web application. The main purpose of this project centers around user interface design, more specifically, the development of movable and collapsible DIVs that replicate the functionality of Windows Forms. It must have: - The ability to accommodate various desktop monitor resolutions at fill screen - A full width horizontal menu on the top with sub items -- Clicking one of these menu items displays the "movable" windows form like DIV - Movable, Windows Form like DIV's -- The important Aesthetic components are some Titlebar that has The ability to Minimize and close - Be able to display on a small screen mobile device top(w/o movable form capability etc) - Must have ...
Looking for help creating a Google Sheet template that will be used for blocking out time for bookings. We will call it a medi...amount of days would auto populate and then in that row, blocks would populate in for those dates. Also, we would need the template to match the calendar year - for example, this year there were 29 days in February. So having an ability to change the year somehow and then the sheet would update. The next tab would be a weekly blocking chart where we enter the client name, the start date and then fill in a value for the end date and with a week counter. This could be also done with one sheet. Here is a rough layout but would want this to look and be fully functional -
I am struggling with a VBA Excel file where the Macro is not running correctly, and I need someone proficient with VBA and debugging to fix it. The file is crashing frequently, which is causing significant delays and impacting efficiency. • **Macro Issue:** The macro is not running and I am unable to debug or fix it myself. I need an expert who can look into the problem, define what's wrong, and provide a solution that works flawlessly. • **Purpose of the Macro:** I will discuss this further with the successful applicant, but rest assured that your tasks will align with typical VBA Macro functions. Since the purpose of this macro hasn't been disclosed, I am expecting you to have experience with commonly used VBA functio...
(Spanish too) To make the following changes to the existing phile: Everything in red needs to be at the same surface and thickness of the blue zone. Has to disappear as if the blue zone would be underneath but the mentioned holes in red circles have to remai...the following changes to the existing phile: Everything in red needs to be at the same surface and thickness of the blue zone. Has to disappear as if the blue zone would be underneath but the mentioned holes in red circles have to remain. Is like you have to cut the mountains (red zone) and only the sea underneath remains (blue zone). To bring this inner 6 wings aligned with the main arch and fill up the resultant space in between. After this adjustments to the overall thickness will be required. Providing the phile in al...
- Create VB Macro for pulling dates: This Month to Date, This Quarter to Date, This Year to Date and have dynamic calculations no matter what the date is OR allow user to have a custom Begin Date and As of Date. - Checking and savings accounts need to pull transactions between two dates (“Begin Date” to “As of Date” or to date calculations above), not just “as of date”. - Credit card account needs to pull transactions between two dates (“Begin Date” to “As of Date” or to date calculations above), not just “as of date”. - Sales Tax Payable needs to pull transactions from “Transactions” worksheet, column S, unless you can write a SUMIF or other formula to pull the data without needing column S using t...
...so the history and mission of our company. Introduction of our individual team members is not necessary for this project. • Services Page: This page will enumerate and explain the consulting services we offer, providing potential clients with a detailed understanding of what we can offer. A Developer with a strong background in Wordpress and a good understanding of UI/UX best practices will excel in this project. Proficiency in both front-end and back-end development is paramount. Also, having a history with similar consulting websites will be a significant plus. In your proposal, please include examples of prior consulting websites you've created....
I am in need of an expert in Excel who can provide assistance in managing multiple sheets in an Excel file. The spreadsheet requires extensive data analysis, formula creation, and formatting. Key requirements include: - Ability to analyze complex data across multiple spreadsheets - Proficiency in creating advanced Excel formulas to automate processes - Expertise in formatting spreadsheets for ease of use and understanding While I have advanced proficiency in Excel, I need someone capable of handling these tasks efficiently. A background in data science or similar is desirable.
...or refresh of the data should be within the Excel file itself, if an external programme is required, i can consider if it is not too complex. 8. Requirement- must be able to add to this list as it is not complete and there are always changes For 2nd link 3. In the Worksheet "Link 2", this is for the pasting of data from the weblink 4. The link for testing is , cell A2. 5. Requirement- There are a total of 5 tables needed for each weblink. All the web version of the tables are shown the right for reference. 6. Requirement- i am able to use web query to extract the 1st 4 tables, except for "Live Odds Comparison". it doesn’t show up in my web query. 7. Requirement- if you are creating a macro, please test it with this version of Office
Looking for an expert in data extraction and management, specifically from Websites, APIs, and Databases. The project involves extracting numerical data daily and...extraction and management, specifically from Websites, APIs, and Databases. The project involves extracting numerical data daily and integrating the information smoothly into an excel sheet. Skills & Experience Required: - Expertise in data extraction. - Proficient in API integration. - Experience with database management. - Excellent skills in Excel data manipulation. Responsibilities: - Setup extraction from multiple data sources (Websites, APIs, Databases) using Zapier. - Ensure extraction of numerical data only. - Secure daily extraction and update of the information. - Seamless integration of the data...
I am in dir...Your core responsibilities will include: - Data Entry: You should be familiar with Microsoft Excel, as a significant part of your job will be related to entering and managing data in a structured, orderly manner. - Email Management: Not only will you be tasked with responding to inquiries on my behalf, but you'll also be setting up automated responses to maximize efficiency and ensure no email goes unanswered. - Scheduling: You will also help in scheduling meetings. This will involve coordinating with multiple parties to find suitable times. Ideal candidates should have prior experience in administrative roles and should be proactive with excellent communication skills. Mastery of Microsoft Excel is a must, and previous experience with email management ...
Task is to : Visit the location and get form filled sign and stamped by State institution city medical centre no.1 Take 3 to 4 geotagged photos with name board visible In case of refusal to fill form take written or verbal record of refusal with Name, Designation and Contact of tge verifier. In case Place not found take 4 to 6 photos of surroundings with 1 minute interview of person nearby confirming this place does not exist.
...need for document validation which is of paramount importance to me. - Physically visit the university and get the verification form filled, signed and stamped. - As it is a site visit, the freelancer has to take 5-6 pictures of outside the building clearly showing the name of the institution. - In case of refusal, get the refusal in writing with a stamp and signature of the person who refused to fill the form. Your assistance will greatly aid in acquiring vital information. Great discretion and professionalism are expected throughout the project....
I am looking to confirm the authenticity of an academic degree from Kutahya Dumlupinar University, Turkey, I require a specialist who can: 1. Physically visit th...Dumlupinar University, Turkey, I require a specialist who can: 1. Physically visit the university and get the verification form filled, signed and stamped. 2. As it is a site visit, the freelancer has to take 5-6 pictures of outside the building clearly showing the name of the institution. 3. In case of refusal, get the refusal in writing with a stamp and signature of the person who refused to fill the form. to handle confidential information and to communicate sensitive findings professionally. Please note the above mentioned things are mandatory and project won't be considered completed if not worked on all t...
Th...To successfully meet the project's goals, I require a specialist in email scraping to obtain addresses for real estate agents across South Africa and the UK. The target website where these emails will be extracted from is Property24. Of utmost importance and unique to this project is the regional scope. It should cover all regions, without exclusions, within the two countries mentioned. To excel in this project, having the following skills/experience would be ideal: - Strong experience in email scraping - Familiarity with the Property24 platform - Sound understanding of real estate markets in South Africa and the UK - Ability to accurately segment data by region Your commitment to accuracy and attention to detail will strongly influence the success of our subsequent l...
I am looking for an experienced VBA developer to create a custom add-in for Excel. This project will require: - Developing custom functions to automate the generation of multiple types of charts in Excel, specifically pie charts, bar charts, and line charts. - These charts should be formatted according to our specific design requirements, including our house style and measurements. The ideal freelancer will have exceptional skills and experience in VBA and Excel add-in development. I expect a strong understanding of data analysis and an excellent ability to perform tasks accurately and efficiently. Furthermore, I value clear and regular communication so we can ensure the end result meets our expectations. Please only apply if you are confident you can deliver th...
I'm in urgent need of a web based applicat...transforms PDF files, largely bank statements, into Excel layouts. Key Features: - The application should have batch conversion support, allowing numerous files to be converted at the same time. - It needs to have OCR (Optical Character Recognition) capability for pinpointing and extracting info from scanned PDFs. - Its operation should be secure with user authentication and access control features to maintain data privacy. Ideal candidate skills: - Robust experience in web application development - Familiarity with OCR technology - Knowledge in building secure applications with user authentication and access controls - Ability to work under pressure to fulfill project needs ASAP P.S: Keep in mind, the goal is to produce files i...
Today, I need a professional with deep understanding of database creation and Excel data organization to produce a new, streamlined database from my current Excel one. Key Project Requirements: - Convert an Excel database with 1-10 sheets/tabs into a new database system. - Your task is to simplify and streamline the layout of the data for ease of use, without losing critical information. - While expertise in Excel is a must, experience with other database systems is also necessary, considering we might need a smoother platform than Excel. Ideal Candidate Skills: - Thorough experience working with Excel and other database systems. - Exceptional at delivering swiftly to meet today's deadline. - Excellent understanding of efficient data layo...
I am looking to fill a longterm editor position for multiple projects for my agency.??? I run a short-format content agency that edits videos, primarily for coaches. The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging. I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth.? Your starting salary will be 10usd for every video-edit. The process is super streamlined, and everything is setup in google drive. All videos are tailored by me ➡️ you get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simpl...
I am looking to fill a longterm editor position for multiple projects for my agency.??? I run a short-format content agency that edits videos, primarily for coaches. The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging. I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth.? Your starting salary will be 10usd for every video-edit. The process is super streamlined, and everything is setup in google drive. All videos are tailored by me ➡️ you get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simpl...
I am in need of a real experienced Shopify expert: I want to use a Form on my cart page, so customers add products to their cart and fill out a form on cart page. Afterwards they send the form and i get all form information AND information about the items on their cart. They are redirected to a success page after.
I need an experienced data scraper who can extract specific information from a horse racing website. Your task will be to gather data on past horse race records, focusing on: - Horse Names - Race Dates - Horse Positions - And the complete data from the table What I need is for this information to be extracted from the website and then outputted into an Excel file. Proficiency in Data Scraping tools and Excel is mandatory for this task. Prior experience with similar sports data scraping will be highly advantageous. Efficiency and accuracy are crucial in this project.
Job Title: Education Sector Telecalling Sales Expert (Work from Home) Position Overview: We are seeking a highly motivated and results-oriented individual. The ideal candidate will possess excellent communication skills, a proactive attitude, and a strong sales mindset. This p...experience in selling educational products or services. 2. Familiarity with online learning platforms and technology solutions in the education sector. 3. Additional language proficiency is a plus, especially in regions with diverse language demographics. This is a remote position offering competitive compensation with attractive incentives based on performance. If you have the skills and motivation to excel in a telecalling sales role within the education sector, we encourage you to apply and join our dyn...
I need an expert in MS Excel to finalize an advanced timeline schedule. It should consider different factors such as: - Variable work hours per day, - Weekends, - Overtime hours. It's crucial that the dynamic schedule intelligently adjusts to these factors, providing an accurate timetable for my team's workflows. Column M should focus on "Estimated Completion Time". Ideal candidate should possess: - Excellent knowledge and experience with Excel functions and dynamic formulas, - Attention to detail, - Adherence to specified conditions, - Familiarity with corporate scheduling norms will be a plus. Your insightful input to perfect this timeline tool would be highly appreciated.
As an entity constantly dealing with vast amounts of data, I need a proficient Excel VBA expert to assist in automating my reporting and dashboarding processes. An ideal candidate for this project should possess the following: Skills and Experience: • Extensive experience developing VBA Macros • Capability to generate reports automatically • Familiarity with handling data across multiple sheets Specific Tasks: • Developing macros to automate data retrieval from sources such as Excel workbooks and CSV files • Implementing these macros to streamline the process of report generation and dashboard updates By simplifying these tasks, this project will enhance our overall productivity and data management processes. It is crucial that the expert maintains...
I'm looking for a proficient data analyst with the ability to tackle complex data sources and deliver clear, actionable insights. Key Skills and Experience Required: • Exceptional statistical analysis abilities; • Strong data visualization and programming skills. Expected tasks: • Handle data from different sources such as Excel spreadsheets, SQL databases, and CSV files. • Analyze the acquired data meticulously and generate concise reports on your findings. Project Outcome: • Provide profound insights and recommendations based on the data analyzed. • Create comprehensive visualizations and reports to aid in decision making. • Develop predictive models derived from the data analysis. The ideal candidate for this project will have a notab...
I'm looking for a highly organized and meticulous freelancer to handle a numeric data entry task on Excel. Your task will encompass: - Entering simple numeric data into predetermined fields. - Color-coding the entries to ensure easy readability and data categorization. - Ensuring the data is entered accurately and double-checked for any potential errors. Prior experience with data entry, particularly numeric data, is highly advantageous. Proficiency in Excel, particularly with color-coding functionalities, is also a must. Attention to detail is key, as well as the ability to adhere to strict formatting guidelines. Hearing from candidates with a proven track record of delivering high-quality data entry work.
