Excel macro fill empty cellsmunkák

I'm looking for an experienced professional in Excel to create a custom financial tracking template for me. Bonus if compatible with both google sheets and excel. Key Elements: - The template needs to include sections for tracking income and expenses. - Additionally, I need sections for debt repayment tracking and Year To Date (YTD) tracking. - The template should be designed in a way that it is easy to update monthly Ideal Skills: - Proficiency in Excel and experience in creating financial tracking templates. - Knowledge of financial principles and ability to design a user-friendly, visually appealing template. - Attention to detail and ability to customize the template to meet my specific requirements. Please include samples of similar work you've done ...

I'm looking for an expert in Linux administration who is specialized in server setup. My project requires: - Setting up a LAMP on a Ubuntu server with MariaDB. - Configuring the server to respond to a specific domain name, empty folder mapping. - FTP and account mapping to the webserver's folder. Necessary skills: Ubuntu, LAMP setup (Linux, Apache, MySQL, PHP), FTP setup. Experience in managing and setting up servers is a must. This are a very easy setup so maximum 2 hours. Please add the word "Light" in your quote so I now you are not a bot...

I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.

Excel Chart Re-Design for University Work Allocation System We are looking for somebody to complete the development of an excel-based teaching allocation database for a relatively large university department (approx 100 teaching staff). We currently make use of an excel template that roughly cross-references university courses with teaching staff and allocated time commitments for specific tasks. This is quite a complex information array, however, with so many staff members and courses (approx. 120), especially where multiple staff members are co-teaching courses with different task responsibilities. While our current template achieves its desired information management purpose, in its present state its structure is relatively complex and not user-friendly or ...

Looking for an expert who can bring my educational content to life with vibrant, engaging 3D animations. The animations should be a blend of character-based and abstract to maintain viewer interest. Key Requirements: - Skilled storyteller through 3D animation. - Experience in character-based and abstract animation. - Excel in conveying complex information simply and clearly, ideally within an educational setting. - Ability to work collaboratively, ensuring your creations align with my vision. Enhance your bid with relevant work samples, especially animations used for educational purposes. I am excited to see your creativity at work!

I'm in need of a creative designer to help in the design of two flyers. The first flyer should be in a portrait orientation, while the second should be landscape, both in the dimensions of 14.5cm x 21.5cm. Key Requirements: - Incorporate my company's name and logo in the design - Add detailed information about the products/services we offer - Include contact information - Fill in the specific design details and branding guidelines I will provide - Integration of logos and sponsors' information The ideal candidate should be proficient in graphic design, have a great sense of creativity and be able to work with minimal supervision. Ability to bring out the essence of the company's branding and products in the flyers is a plus. Your design should be professional,...

Website on Wordpress License key generator with DB API for Excel Template connecting to DB for license key validation. Dashboard for administrator enter buyer/customer account credetials. The administrator must be able to enable and disablle accounts. Update Excel Template LicenseValidation code for connectiing to API/DB. I will privide this Excel Template code file.

I need an Excel expert to update my spreadsheet. The main tasks include: - **Formulas and Calculations:** I require formulas to be implemented for various calculations. The freelancer should possess a strong understanding of Excel functions and be able to apply them accurately. - **Formatting:** The formatting of the spreadsheet needs to be updated. This includes: - **Font Styles and Sizes:** I need the text in the spreadsheet to be consistent and visually appealing. The freelancer should have a good sense of design and layout. - **Number Formats:** Incorrectly formatted numbers need to be corrected. The freelancer must be meticulous and detail-oriented in this aspect. - **Color Changes for Expired Dates:** An important part of the project is changing the color of ...

I'm looking for an experienced Excel and PineScript expert to create custom Excel formulas replicating my developed PineScript indicator. The indicator performs functions for Bollingerbands and Keltner Channels. The task will be to incorporate Open, High, Low, Close prices into the Excel formulas. Please note, data collection or data visualization is not required for this project. To give your best, you should possess an advanced understanding in: - PineScript - Creating complex Excel formulas Looking forward to your informed bid.

I need help with an Excel sheet that will be used for data analysis, specifically sales distribution. The sheet will include a mix of sales data, customer information, and product inventory. Key tasks: - Organizing and inputting the provided data correctly - Creating a system for sorting and analyzing the data - Developing a system for tracking sales distribution effectively - Potentially applying necessary calculations and formulas to enhance the data analysis Ideal Skills: - Proficient in Excel, including data analysis and financial functions - Experience with sales data and distribution analysis - Strong attention to detail and organizational skills - Ability to create formulas and calculations - Familiarity with customer information and product inventory management Ple...

...fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all accessible information per entry is needed. Your expertise in internet research, data mining, and...

I am seeking a t...numbers for promoting my business. Key Features: - Bulk Phone Number Verification: The tool should be able to check multiple phone numbers at once. It should separate the active numbers from the inactive ones. - Whatssap Compatibility: The tool needs to connect with Whatssap API to confirm the activity of the numbers. Delivery: - Data Export: I require the verified numbers to be exported to an Excel spreadsheet for easy access and use or .txt file Skills & Experience: - Proven experience in API integration, specifically with Whatssap. - Strong programming and software development skills. - Experience in building phone number verification tools will be a plus. Please provide examples of similar projects you have worked on previously. Looking forward to y...

Looking for experienced digital artists with a knack for naturalistic photo editing for an important job. I need a person (5th from the left) removed from a group photo. This isn't just about erasing the person, but expertly rearranging the remaining group members to fill the gap. Ideal candidates have: - Proficiency in high-quality photo retouching and creating realistic compositions - Ability to handle tasks related to privacy photo edits - Experience in shifting and rearranging photo elements seamlessly Please ensure that your work is as natural and seamless as possible, minimizing visible signs of alteration. Showcasing relevant portfolio pieces during the bid would be highly beneficial.

I'm looking for a freelancer with excellent attention to detail and proficiency in Microsoft Excel and Word. As part of this project, you will be required to manually enter data from Excel files into a Word document. Key Requirements: - Strong Microsoft Excel and Word skills - Proven experience in accurate, manual data entry - Ability to work with robust data sets Deliverables: A Word document with the data accurately entered from the provided Excel files. Your ability to deliver clean, accurately transcribed data is essential for the success of this job. Attention to detail is paramount. I look forward to working with detailed and skilled freelancers.

...the design shown in an attached image. This form will be embedded on different areas of my website specifically, the Contact page () and Service page (like this one: ) Key elements of the form include: - 5 fields - Fields: Name, Email, Phone number, Company name, and 'Your message' field for users to fill in. - A field to address the user either as Mr. or Miss. For this job, you should have: - Significant experience in form designs, particularly in Tally - Proven expertise in integrating Tally forms on websites - Attention to detail as the form should look exactly like the designated image Please bid if you can deliver an exact replica of the form design embedded seamlessly onto

I need an assistive hand in a data extraction task that requires sharp focus and meticulous attention to detail. The task involves: - Extracting email addresses from an Excel spreadsheet - Maintaining accuracy and precision during the data entry process, ensuring no data is missed or inaccurately entered Proficiency in Microsoft Excel is a must for this task. Previous experience in data extraction or data entry is highly desirable. You should be adept at handling large volumes of data, have a keen eye for detail, and are able to keep track of your progress systematically. Let me know your capacity per day/week as this can be an ongoing project. Please dont negotiate on the price beyond the Bid provided

For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.

I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data security...

This project aims to build an informative and precise contact list for our business use. We will provide you with a list of 1000 records, and your job will be to Google each one and fill the respective information - Website, Address, City, State, Zip, Phone - into a shared Google Spreadsheet. The focus of this data collection will be on the specific records we supply. Ideal skills and experience for the job: - Strong web research skills - Prior experience in data entry - Attention to detail and accuracy - Proficiency in Google Sheets - Ability to meet deadlines.

I am in immediate need of a professional with proven experience in writing legal Partnership Agreements. Specifically: - Proficiency in drafting Partnership Agreements is crucial. - The agreement must excel in providing measures for protecting sensitive information. - Understanding of confidentiality and data protection is mandatory. I am expecting work that is thorough, legally sound and protects my interests optimally. It is not about just getting it done but getting it done right. Previous experience with such documentation is a solid advantage. Kindly share your portfolio when applying. Accuracy, attention to detail, and understanding complex legal terminology are the skills that I am looking for. NB: Experience with sensitive information protection will be a bonus.

I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more

I am currently in need of a freelancer who can physically visit Ar...be physically present in Sweden and be able to travel to Artemis Medic. - Your job is to verify the authenticity of the employment records. The following requirements are mandatory: 1- Task is to visit the address physically. 2- Take 5 to 6 Geo-Tagged Photos of Name Board and Building with Surroundings. 3- Get the Verification Form filled, signed and stamped by the HR. 4- In case of refusal to fill form, take the audio or video record, with written refusal with stamp or sign as a proof. Get the details of Verifier, Name, Designation, Department and Contact. If the above mentioned requirements are fulfilled than task will be completed. Individuals who can carry out this task promptly and efficiently are encourag...

... The information required includes details on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ability to maintain d...

Hello, I am in need of a developer capable of creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33781462503. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I would greatly appreciate it if you co...

I need a skilled MERN stack developer who can integrate the pages my previous developers have made, i have a login page and a report generation application. I want the user to first fill the survey as a login page and once they have filled it store the details as a cookie or session so they don't need to fill again User details filled should also go into a local db or folder Then users will be sent to our report generation application and at the end when report is generated, business name and email ( from the survey form stored in session cookie) will be used at top of report Survey / Login Page : Report generation Page :

...lead management. 1. the customer makes an inquiry via our website (I could do this via WordPress by my own) 2. we check the request in an “admin area” and distribute the anonymized lead the anonymized lead manually to 3 partner workshops. 3. the partner workshops can view the leads in their “workshop area” and either reject them or submit an offer (price (price, check some checkboxes and fill in a text field) 4. the end customer receives an email with the offer and the contact details of the workshop. He also receives a link to the “Customer area” where he can view his request and all previous offers. can view. Requirements: “Customer area” - The customer receives an e-mail from us with a link to a customer area. ...

I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.

I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with complex data types.

I am in need of a proficient freelancer with expertise in data cleaning and data analytics to handle an upcoming project involving Excel. Specifically, the tasks will involve: - Removing duplicate entries, - Correcting inaccuracies in data as needed, - Formatting data to enhance its visual interpretation. The next part of the project involves data analysis, where the focus is on: - Creating data visualizations, particularly concerning the sales trends in our dataset. A background in Excel-based data correction and visualization is essential. Ideally, you've had previous exposure to sales data and are capable of understanding and predicting trends. Your bid should reflect your ability to accurately complete these tasks in a timely fashion.

I urgently need to extract the emails from Excel and place each one in a separate cell. In the image, you have an example of what I want.

...acre farmers. The site should serve as a detailed resource, highlighting key aspects of our work and organization. Key Features: -A professional look and feel `-Wordpress based - A comprehensive "About Us" page to outline our mission, goals, and team. - A clear display of our contact information on every page. - Easliy updated by ourselves with graphics based on data collected and stored in MS Excel -Potential for client login The perfect candidate for this job would be an individual with a keen eye for modern web design, experience building informational websites, and ideally some knowledge in Australian agriculture. Good communication skills are necessary, as you'll be expected to collaborate with our team closely. A successful end result would result in a u...

I'm looking for an Excel expert to help me clean up a dataset. I have a large dataset that contains both text and numeric data that needs to be cleaned up. The specific issues I'm facing are: - Text Data: There's a need to find and remove any duplicated values, missing values, and correct any formatting issues. - Numeric Data: The numeric data in the dataset has inconsistent decimal places and a few outliers that need to be identified and adjusted. Ideal skills for this project include: - Proficiency in Excel, particularly in data cleaning and data analysis. - Experience in handling both text and numeric data. - Strong attention to detail to identify and rectify issues within the dataset. Please, only apply if you have experience with similar tasks and ca...

I'm in need of a skilled typist for a data entry project. The task involves entering data into an Excel spreadsheet. Requirements: - Excellent typing speed and accuracy. - Previous experience with data entry. - Proficiency in Excel. - Ability to follow instructions precisely. Ideal Candidate: - Proven track record in data entry tasks. - Strong attention to detail. - Reliable and able to meet deadlines. - Good communication skills. If you have the right skills and experience for the job, I look forward to receiving your bid.

I need a talented 3D ...and high-quality final model. - Ready for 3D printing: The final model should be suitable and optimized for 3D printing. - I need STL and IPT files A little bit of adjustment is needed in the image attached which will be shared in chat. The printing machine available to me can print only 1 ft the total size of the sculpture is 3ft so the model should be modular as well. the model should be empty from the inside I will use this modal is mold. Ideal Skills: - 3D modeling: Proficiency in Blender, Maya, or ZBrush software. - Understanding of 3D printing: Ability to prepare models for 3D printing without losing details or quality. Please provide a portfolio of your previous work related to 3D sculpting and modeling, especially if you have experience with 3D...

I'm looking for a skilled professional who can assist me in entering text data into our project reports. Ideal Skills and Experience: - Experience working with project reports - Proficient in digital data entry - Attention to detail The reports will be provided in digital format, such as Excel or Word. The main task will be to ensure all text data is accurately entered. Additionally, the ideal candidate should be able to ensure the report maintains a professional and consistent format throughout. You may be asked to apply company branding or use specific fonts and sizes. The ability to work with minimal supervision and meet deadlines is a plus.

I'm seeking a skilled developer to create an online job platform. This platform will showcase part-time and freelance opportunities, specifically in the realm of finance. Key Features: • A succinct, user-friendly application form for job seekers to fill out • A wide range of job categories, particularly focused on finance related jobs. Ideal Skills: • Website development • Understanding of job portal requirements • Experience in creating user-friendly online forms • Familiarity with finance-related job listings. Your proposal should showcase your previous work on similar projects and share ideas on how you would approach this unique project.

I am currently running my vendor payments process using a combination of Excel, MS Forms, and Power Automate. I'm now seeking an expert to transform and advance this process using options such as Sharepoint List and Power Apps. The mission encompasses three critical areas: • Automating data entry and validation: Reducing manual input ensuring that the data fed into the system is accurate and up-to-date. • Approval workflow: A simplified yet efficient approval process ensuring no delays or oversights. • Payment generation: Timely and well-coordinated payment processing for a smooth and organized operation. Capabilities Required: • Handling high volumes: I am dealing with more than 50 vendors. So, proficiency in handling such a scale is a must. For the ...

I need a freelancer to enter numeric data into Excel from digital sources. Key Requirements: - Proficient in data entry - Expertise in working with Excel - Attention to detail The task is straightforward and simply requires the accurate transfer of numeric information into a pre-existing Excel template. I will provide the data in digital format (Excel, CSV) and expect it to be entered systematically according to the format provided.

I have a PDF document that is a mix of scanned and text-based content that I need converted into an editable Word or Excel format. I need this completed as soon as possible. The output needs to be fully editable, meaning that the text should be recognized and convertible to a format where I can change, add or remove text as needed. This means the scanned parts should be OCR-ed accurately.

I'm seeking an experienced freelancer for a data entry project. The task involves converting PDF files containing mixed data, both textual and numerical, into Excel. Ideal Expertise: - Proven experience in data entry - Proficiency in Excel and PDF conversion - Accuracy and attention to detail Please ensure all data in the PDF files is correctly transferred to the specified Excel format. I'm looking to post this project up to 100 Rupees. If you have the skills and can handle this type of work, I encourage you to bid.

I have a small set of textual data that needs to be typed into an Excel sheet. The purpose of this project is to prepare the data for analysis. Key responsibilities: - Type less than 100 rows of textual data into an Excel sheet. - Ensure data accuracy and consistency. Ideal skills for this project include: - Experience with data entry. - Proficiency in Excel. - Attention to detail to avoid errors. The successful freelancer will need to deliver the Excel sheet with the data accurately typed within the given timeframe.

I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject Account ...

I'm looki...handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus. The role demands strong organizational skills and attention to detail. A sound understanding of database principles and Excel function...

The project entails accurate entry of numerical data into an MS Excel spreadsheet, with a focus on report generation. The ideal freelancer should be well-versed with basic Excel functionalities, such as simulations and formulas, to ensure efficient data processing. Key responsibilities would include: - Accurate and efficient numerical data entry - Setting up Excel to run basic simulations and formulas - Generating effective and accurate reports from entered data The freelancer should have strong attention to detail to maintain data accuracy and proficiency in MS Excel, specifically in creating basic simulations and formulas. Previous experience in data entry and report generation is highly preferred.

I'm looking for a skilled UI/UX designer who can enhance our website's enquiry form. The main goal of this form is to generate leads so it's crucial that it's user-friendly and seamless in its function. Key points you should keep in mind include: - **Simplicity and Speed**: The form needs to be designed in a way that makes it quick and easy for users to fill it out. This is crucial to ensure high conversion rates and lead generation. - **Aesthetic Appeal**: The form should be visually appealing and in line with our branding, to ensure a positive user experience. - **Platform Integration**: While the form will be on our website, it should also be designed with responsiveness in mind, to ensure it's user-friendly on various devices. Key Skills and Experienc...

I'm in need of a professional who can help me with analyzing medication adherence rates. I need someone who knows the concept of MPR and/or PDC with experiences, so help me what data is needed to obtain these results. also know how to use Kaplan-meier method to analyze persistence data with this. The data source for this analysis will be electronic health records and pharmacy fill data. Key Responsibilities: - The main task is to determine medication adherence rates (MPR and PDC) using the provided electronic health records. - know the concept of MPR or PDC and guide me on what is needed to calculate these. - The analysis should be thorough and comprehensive, helping me to identify potential areas for improvement in medication persistence. - Expertise in using statistical so...

I require a professional with a keen understanding of both Excel and iOS Numbers to convert a single-sheet Excel spreadsheet into an iOS Numbers document. The converted document will need to retain multiple functionalities including: - Basic calculations - Data visualization - Conditional formatting No data interdependency or connectivity with other aspects is required in this case. The ideal candidate should have significant experience with data conversion between these two platforms and a solid grasp of maintaining functionalities in iOS Numbers. Familiarity with creating visually engaging spreadsheets will be highly regarded. I would like to have conversation with someone to make sure I am asking for something reasonable and to clarify exactly whats needed. TY

...to 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 agree to these terms. Post the sentence in your bid: "I understand and agree to the terms and conditions set forth in the project description. I agree that not following instructions will be grounds for termination a...

I have a baseline construction schedule built already; it has around 1000 activities, the schedule is cost & resource loaded. I will provide the update in excel (actual start, actual finish, actual cost), the monthly activities that needed to be updated (actual date & Cost) around 100 activities every month. Please note sometimes I need to provide you comments on the schedule update, so you need to fix the comments. I need you to update the start/finish date and insert the actual cost monthly (once every month). Plus, prepare small narrative report including some P6 PdF. I have the P6 layouts I will share with you. I have the report and layout built in already and I will share it with you. Finally, send me XER file, and Narrative report every month. It is very important y...

...send your proposal including: - A brief explanation of your approach to diagnosing and solving the current website issues. - Resume or link to your online profile. - Examples of similar issues you have resolved. - Make sure to type the word LOVE at the beginning of your submission We will prioritize proposals that offer a clear, actionable plan for immediate resolution. We are looking to fill this position urgently and will offer a long-term role to the candidate who can efficiently solve our current problem....