Excel macro fill empty cells jobs
For an upcoming project, I am in need of a dedicated freelancer who can do more than just word processing. I have a word table, its aim is organization of data, and I need it converted into an Excel table with the same structure. A keen understanding of data organization would be crucial to this task. Ideal Skills and Experience: •Excellent knowledge of Microsoft Word and Excel •Proven ability to convert Word documents into Excel files •Detailed understanding of tables and their formatting in both Word and Excel •Strong data organization skills.
Looking to develop an Excel spreadsheet that will streamline tracking of Profits & Losses (P&L), sales, and payments. This obligation demands: - Create excel forms for each client/sale that will encompass information related to change orders, tracking of revenues, tracking of expenses by vendors and liabilities, and profit/loss analysis broken down for each client - Calculations: The spreadsheet must include key formulas such as gross profit margin, profit margin per customer, and payment reconciliation. Ideal candidate should possess advanced Excel skills with a robust understanding of finance and sales metrics. Previous experience in such tasks will be advantageous.
My budget not more 30$ Functionalities of desktop application : 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same desktop application Output: the software working without in others that have same extension
I need someone with good data collection skills. I need some data put into a spreadsheet it will have 3 columns SHOP NAME, POSTCODE, TELEPHONE NUMBER i will provide links and you have to send me the full sheet back with all the details you may have to search the web to get the phone number the most important info is the TELEPHONE NUMBER and it must be correct any mistakes and you will NOT be paid. this is ongoing work for the right candidate
...digitally controlled ball valves. Variable resistor water level sensors for real-time water level monitoring. A central Siemens Step7 PLC unit that receives water level targets via Modbus protocol. Requirements: Develop and implement efficient ladder logic to interpret Modbus messages that dictate the desired water levels for each tank. Program the PLC to control the ball valves, opening them fully to fill the tanks, or closing them to drain the tanks, and then adjusting the valves periodically to maintain the water level, accounting for continuous water outflow. Ensure that the ladder logic allows for dynamic response to changing water levels, with robust error handling and system recovery mechanisms. Video for ball valve operation: Datasheets for the
I'm in need of an Excel guru to take on my project that entails budgeting and expense tracking. The gravity of this project leans on the advanced, as the utilization of pivot tables, VLOOKUP, and macros would be crucial. Completing this project demands a strong understanding and practical experience of: - Microsoft Excel - Advanced Excel functions (pivot tables, VLOOKUP, macros) - Finance and accounting (budgeting & expense tracking) If you think you've got what it takes to navigate through the complex labyrinth of numbers in this Excel project, then show me what you've got. Your detailed knowledge of finance and Excel will be put to good use. Looking forward to working with you!
...skilled developer to build a Chrome extension that embodies three main functionalities: 1. Button and Fields Scanning using Google Gimini Vision: The chosen candidate must be familiar with Google Gimini's vision technology for the recognition of various buttons and fields. It's important to be able to scan buttons and fields dynamically and accurately. 2. Macro Actions Recording with Voice and Notes: The extension should have a macro recording feature. This must incorporate both voice and notes - think voice transcription combined with manual typing. Having experience with advanced note-taking features and voice recognition APIs would be beneficial. 3. File Sharing: The ability to share files with other users of the extension is a required feature. Proficie...
I'm seeking an expert in Excel who can create a formula suitable for analyzing my account transaction data. The specific task at hand involves automating the summing of transactions. The ideal candidate will have: - Proficiency in Excel and data analysis - Proven ability to create complex Excel formulas or VGA macros - Attention to detail I need a formula which will bring up the last value from worksheet "Transactions" column O (looking for multiple dates which are the same), and putting it into D7. In addition, the result needs to change based on the date being greater or equal to worksheet "Account Balance" D3 and less than or equal to worksheet "Account Balance" D4. So, using the attached spreadsheet, the result in "Accou...
I am in search of a highly skilled Power BI analyst to dissect my sales data currently in Excel Spreadsheet format, .csv file and share the dashboard. The ideal candidate will have a strong background in sales analysis with the ability to generate insightful reports that can inform strategic business decisions. Key Responsibilities; - Analyze large amounts of raw data to find patterns and use them to optimize our performance. - Build and maintain reports, dashboards, and metrics to monitor the sales performance. Requirements; - Proven experience in data analysis and data modelling in Power BI. - Strong proficiency and working knowledge with Excel Spreadsheets. - High level analytical skills, attention to detail, and ability to make data-driven decisions is critically impor...
I need a proficient Excel expert to automate data entry, calculation, and formula tasks on my spreadsheet. Your role will be to ensure seamless integration of: - Text - Numbers - Dates The spreadsheet handles daily data input, so it requires daily updates. Mastery in Excel is required, and a keen eye for accuracy is important due to the frequency of the updates. The task would be greatly suitable for those who have versatile skills in spreadsheet management and data automation. Your ability to streamline these tasks will be key in this project. The All tabs with a status column will need to feed into the Actions tab, which can be relabeled into a Actions (Master) tab. The purpose is to have a general overview of the actions required throughout the spreadsheet. I am happy t...
I need a professional who is skilled in cold calling and lead generation, with a target of finding new custome...clientele. The primary target for the cold calls will be Freight Carrier Services. The aim is to provide them with an extraordinary transport solution while expanding our customer base. The cold caller will need to gather key information during the calls, including: - Company name and contact information - Shipping volume and frequency - Specific transportation needs and requirements To excel in this role, the ideal candidate should have excellent communication skills, a proven track record in cold calling, and a solid understanding of the freight carrier services industry. Their initiative, ability to build relationships, and knack for securing new business will b...
...websites. The main objective is to create a transport roster site where employees can fill out their details and timings. A few specific requirements for this project include: - Developing the static website. The concept, design, and functionality all need to be crisp, clean, and user-friendly. - Incorporating a form for employees to input their details. This should include validation checks to ensure that all information submitted is accurate and complete. - Upon submission, the form should be converted into an Excel Spreadsheet and sent to a specified email automatically. I'm seeking someone with experience in form handling, validation checks, and automated email sending. Familiarity with Excel document automation will be a plus. Your expertise to mee...
...training for my small dataset. The dataset, currently in Excel format, contains relevant data on threat, vulnerabilities, existing controls, likelihood, and impact. In this project, you would be responsible for: - Cleaning the dataset to ensure accuracy and relevance - Normalizing the data for consistent, efficient analysis - Employing machine learning techniques to train on cleaned and normalized data - The input should be the Threat, Vulnerability, Existing control and the Model should predict the liklihood and Impact Ideal skills and experience for this project would involve: - Extensive experience with machine learning algorithms and processes - Strong attention to detail for effective data cleaning - Proficiency in handling Excel formatted datasets - F...
...websites. The main objective is to create a transport roster site where employees can fill out their details and timings. A few specific requirements for this project include: - Developing the static website. The concept, design, and functionality all need to be crisp, clean, and user-friendly. - Incorporating a form for employees to input their details. This should include validation checks to ensure that all information submitted is accurate and complete. - Upon submission, the form should be converted into an Excel Spreadsheet and sent to a specified email automatically. I'm seeking someone with experience in form handling, validation checks, and automated email sending. Familiarity with Excel document automation will be a plus. Your expertise to mee...
I'm in need of a talented individual with a strong financial and Excel background to prepare several financial reports templates for a debt crowdfunding company like he is the Finance Manager on this Company. These templates should be innovative, user-friendly, and highly effective. Key tasks include: 1. Cash Flow Forecast: Projecting the company's cash flow situation, indicating both incoming and outgoing cash. 2. Profit & Loss Statement: Detailing the company's financial performance over a specific period of time. 3. Risk Assessment Report: Identifying potential financial risks and constructing a plan to mitigate them. 4. Portfolio Performance Report: Assessing the performance of our portfolio, including yield, volatility, and return on investment. 5. In...
I'm in need of an experienced data entry specialist who can handle text, numbers, and images. I will provide the necessary data through Excel files, PDF documents, and handwritten notes. Understanding and accuracy are key as the volume of data to be entered is medium, ranging from 100 to 1000 entries. Ideal candidates should be detail-oriented, have proficiency in Excel, and have strong written English skills for interpreting my handwritten notes. Prior experience in data entry is highly valued.
I have a need for a tool capable of reading and transferring table information from websites into excel. Here are the specifics of what I'm looking for: - The tool must be compatible with both Google Chrome and Microsoft Edge web browsers. - I need to extract information specifically from static tables. - The tool must be capable of extracting text and numerical data from these tables. Freelancers bidding on this project ideally should have the following skills and experiences: - Proficiency in web scraping techniques and data extraction. - A deep understanding of web browser's behaviors, particularly Google Chrome and Microsoft Edge. - Extensive experience with Excel data management and manipulation. - A knack for creating user-friendly tools is a bonus. I e a ...
I need a talented developer experienced in macros creation for Microsoft Word. This project involves developing a macro to automate text formatting following the Bluebook (legal) style guide. Ideally: - You should have a reputation for building macros to automate processes in notebooks, especially Microsoft Word. - Familiarity with Bluebook (legal) style guide is a significant plus. - Experience in automating text formatting tasks, making manuscripts ready for publication swiftly. Please note that your work will greatly aid in making our publication process more efficient, and your passion for detailing and formatting standards will be highly appreciated. This might lead to a long-term collaboration. Looking forward to your bids.
I have a project that entails transferring data from 64 screenshots (.jpg) of an Excel spreadsheet into an actual Excel worksheet. Across the 64 screenshots, there are 2,571 rows of data in total, with 5 columns of data on each screen shot (account, firstname, lastname, title, email). Accurate data conversion and attention to detail is essential.
I'm seeking someone experienced in entering data; specifically text, numbers, and dates, into an Excel sheet comprising less than 100 columns and rows. Not only will you input the data, but I'm also requiring a new template design that will make our data easier to decipher and interact with. Therefore, ideal candidates should possess: - Strong expertise in Excel - Proficiency in creating intuitive and efficient Excel templates - An eye for design to enhance data readability - Exceptional attention to detail to ensure accurate data entry.
I am looking for a skilled data entry specialist to handle a task that involves transferring text information from PDF files into an Excel Spreadsheet. - The ideal candidate should have experience in data entry, particularly dealing with text data and is familiar with PDF and Excel formats. - Accuracy and attention to detail are paramount as the entered information will be used for critical business decisions. - A fast turnaround time will also be appreciated but not at the expense of the quality of work. - If you've handled such tasks before, feel free to share the outcome and your experience. Your bid should also reflect a deep understanding of this project. This task provides an opportunity to showcase your data entry prowess while contributing to business inte...
...freelancer to create a dynamic and interactive project management schedule dashboard using Power BI. Key Features: • Data Sources: The dashboard will incorporate data from my Excel spreadsheets and connect dynamically with Power BI. • Important Metrics: The dashboard should be capable of tracking Key Performance Indicators (KPIs) including Project Progress, Task Completion, and Resource Allocation. • Customization: I require both basic template customization and advanced data visualization customization for an enhanced user experience. Ideal Skills: • Power BI functionality expertise • Knowledge on integrating Excel with Power BI • Advanced data visualization abilities • Proficiency in template customization Experience in creating...
My budget not more 30$ Functionalities of desktop application : 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same desktop application Output: the software working without in others that have same extension
We are seeking a highly skilled and detail-oriented Virtual Assistant to support our team of Quantity Takeoff and Floor Covering Estimators. The successful candidate will have extensive experience in the construction industry and be proficient in estimating materials, labor, and other costs associated with...LVT, LVP, floor leveling and preparation, concrete leveling and polishing, and tile work • Proficient in reading construction designs or blueprints • Strong attention to detail and the ability to manage multiple projects simultaneously • Experience with construction estimating software such as Bluebeam, PlanSwift, or similar programs is a requirement • Proficiency in Microsoft Office, especially Excel and Word • Knowledge of flooring covering and subcont...
My budget not more 50$ Functionalities of Chrome extension : 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same chorme extension Output: macro working without in others that have same extension 4: deployment on marketplace
...freelancer with experience in scanning documents, extracting relevant data, and converting it into Excel format. The type of documents will be disclosed to the selected freelancer - since the question about the document type was skipped. Key Responsibilities: - Scan the provided documents. - Convert scanned documents into Excel format. Important Skills: - Experience with scanning and converting documents into Excel format. - Able to follow specific formatting requirements to match the original document layout. Getting shortlisted: Freelancers keen on this project should have a proven track record of such conversions. I am interested in seeing your past experience with similar projects. Note: The Excel files should mirror the original documents' ...
My budget not more 50$ Functionalities of Chrome extension : 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same chorme extension Output: macro working without in others that have same extension 4: deployment on marketplace
Note: my budget not more 10$ Functionalities of Chrome extension : 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same chorme extension Output: macro working without in others that have same extension 4: deployment on marketplace
I need an expert to convert a complex Excel spreadsheet into a form that is compatible with the wpDataTables plugin, or similar, to be used on a WordPress website. The document is heavy on formulas which must remain operational post-conversion. The purpose is to have this data visually displayed on the website in table format, which will not only make the data more presentable but improve accessibility as well. It will also need to have the ability to run reports directly from the website or plugin using the data entered into the build. The ideal freelancer for this job would possess: - Proven experience in working with Excel and WordPress. - Proficiency in working with wpDataTables or similar plugins. - Ability to ensure the translation of Excel formulas into the n...
I am looking for an Excel and database expert who will assist me in creating sales reports. Your main task will involve: - Utilizing and massaging sales data to generate comprehensive reports. - Presenting these reports in the form of dynamic Pivot tables. The ideal freelancer for this job should have: - An extensive knowledge and experience in Excel, specifically with Pivot tables. - Proven track record of data analysis and report creation. - Ability to interpret and analyze sales data. If you are detail-oriented and results-driven with a knack for turning data into actionable insights, I would like to hear from you. Please include samples of the sales reports you have created in the past using Excel.
...integration between Excel and Outlook. The primary feature of this integration should be automatic updating Excel whenever new contacts are added to Outlook. In addition, a bulk auto-reply feature is desired. ---------------- Please read the attached proposal file carefully. Besides, before establishing a milestone, we are possible to continue to revise and update this proposal along with its specifications within the discussion threads. Prior to accepting the milestones, please ensure to review all the most updated proposal details and specifications. Let’s confirm we have the same proposal with the same modification time before accepting milestones. ---------- Key Tasks: - Develop an integration system between Excel and Outlook. - Auto-add new Outl...
Note: my budget not more 30$ Functionalities of Chrome extension : 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same chorme extension Output: macro working without in others that have same extension 4: deployment on marketplace
I require assistance with Excel data entry tasks, specifically related to transposing information from PDFs into Excel. The job will involve meticulous attention to detail to ensure accuracy of entered data. Key responsibilities include: - Inputting data from PDF files into Excel spreadsheets Ideal candidates should have: - Advanced experience and understanding of Excel - Proven data entry skills - Detail-oriented approach with ability to quickly identify and correct errors - Familiarity with PDF files In this role, you'll be instrumental in ensuring the seamless transfer of critical data from PDF to Excel, playing a key role in our overall data management efforts.
In need of a highly proficient data entry and web scraping professional to assist with an extensi...professional to assist with an extensive project. The job involves obtaining specific contact information from a variety of links provided in an Excel file. Ideal Skills and Experience: - Familiarity with web scraping, data extraction and decoding - Proficient in using Excel and handling complex data sets - Attention to detail, to ensure accuracy of the extracted information - Prior experience in extracting contact information from varied sources is desirable Specific Task: - Go through the Excel file to access the respective website links - Extract key contact info from every link - Accurately compile all the extracted contact details back into an organized Excel...
As the client of this project, I need an experienced freelancer to translate a complex PDF into an Excel file. The PDF contains mixed data, both text and numbers, and it's crucial that the formatting in the original PDF file is retained in the Excel document. Key Responsibilities: - Accurate conversion of mixed data from PDF to Excel, maintaining the original format. - Ensuring the data remains intact during conversion. Key Skills and Experience: - Expertise in handling large Excel spreadsheets. - Proficiency in using data conversion tools. - Attention to detail to ensure data accuracy and consistency. - Experienced in data entry jobs with familiarity in both PDF and Excel formats. This project requires precision and a high level of detail, h...
...expertise with Excel and finance for a project. I have a collection of bank statements, from which specific checks need to be reflected in a detailed ledger. The task at hand is straightforward, and the financial accounts involved are not extensive in nature. Key Responsibilities: - Identify the necessary information from each check presented in the bank statements. Each check entry contains the date, the amount, and the recipient (payee). - Prioritize the specific transactions (as instructed) to be reflected in the ledger. The priority lies within these selected check details. - Create and maintain the ledger using Microsoft Excel, ensuring it is clear and accurate, with attention to detail being of utmost importance. Can start immediatly Ideal Skills: - Proficient in ...
...analysis to improve my business's sales forecasting. As part of your role, you will be anticipated to accomplish the following: - Manipulate and analyze complex, high-volume data from various sources, which in this case is Excel spreadsheets, turning it into actionable insights. - Conceptualize and run predictive data models that directly influence the business's bottom line by boosting the accuracy of our sales forecasting. The ideal candidate should have: - Proven experience as a Business Intelligence Analyst or Data Scientist, particularly working with Excel data. - Strong knowledge and understanding of predictive analysis and data modeling. - A record of using data to make significant business decisions, especially concerning sales forecasting. Please ...
Looking for a creative graphics designer who can design to my Wordpress site through artistic and eye-catching banner and illustration designs. - The main task will focus on devising innovative and engaging banner designs that incorporate text and images. The goal isn't just to fill space, but to create something that enhances user experience and embodies the brand ethos. - Alongside this, your work will also involve designing attractive site illustrations. Here, emphasis is on creativity as these designs will contribute significantly in building brand awareness. Skills and Experience - Proficient in graphic design for websites, specifically Wordpress - Extensive experience in banner and illustration design - Skilled user of design softwares - Strong ability to understand b...
I'm looking for a skilled drafter to take my basic sketches and trans...façade,with rooftop garden, 3D models on SketchUp (refer to the image concept design) - Site plan on Revit with cultural centre, open spaces, car park etc. (refer hand sketch 2) - Section drawings of the cultural centre, of the building in all direction of the building. (refer to s1 and s2 in sketch) - Image generated, to SCALE, Construction sequence of the main construction steps from the WBS in Excel. Freelancers with experience in architectural drafting and SketchUp modelling will be particularly suited to this task. Please consider that attention to detail and precise adherence to the sketches are essential to this project. Knowledge in construction logistics would be ideal for determining the c...
I am looking to fill a longterm editor position for multiple projects for my agency. I run a short-form content agency that edits videos for various coaches, businesses and podcasts. 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. The process is super streamlined. 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 simple thumbnail that fits the ratio 1:1 on Instagram feed. All videos should be edited in 9...
I'm looking for seasoned coders that excel in Perl, to reconfigure my current Perl email script. The primary aim is to make it efficient in sending out emails using Google's SMTP. Key Deliverables: - Modify Perl script to use Google's SMTP via the Net::SMTP::SSL or Email::Send::SMTP::Gmail modules - Integrate secure connection to Gmail - Integrate Email authentication No requirement for handling attachments is necessary. Need to understand how the forms work. Proficiency in Perl, understanding of SMTP protocols, specifically Google's SMTP, and experience with Net::SMTP::SSL and Email::Send::SMTP::Gmail modules are crucial for success in this task.
I'm seeking a professional who can develop a macro recorder specifically for Windows operating system. This tool should be capable of automating the following tasks: - Data entry - Keyboard commands - Mouse movements It’s crucial that the recorder comes with an intuitive user interface allowing recording and managing macros with ease. Individuals who apply should have a deep understanding of Windows operating system, software development, and designing user-friendly interfaces. Prior experience in building macro recorders or similar automation tools will be a definite advantage. I expect ongoing support from you to ensure the tool's optimal performance. Let's simplify the workflow together!
I'm seeking a highly skilled freelancer to assist with data processing tasks. Key Responsibilities: - Process various data efficiently Please note, the source of the data to be processed is unspecified at this point. Timeline: - There is no strict deadline for project completion. However, a sense of urgency is appreciated Ideal Skills: - Solid data processing capabilities - Prompt delivery and high-level accuracy - Exceptional problem-solving skills Experience in the data entry field If you think this project aligns with your skills, I'd love to hear from you.
I am seeking a highly skilled developer to create a macro recording tool capable of conforming to my unique and evolving utilities. The recorder should be capable of documenting both mouse movements/clicks as well as keyboard inputs distinctively. Essentials: - The macro tools should be compatible with and optimized for the Windows operating system. - The system should have functionality allowing me to modify the recorded mouse and keyboard actions post-capture. I strongly prefer freelancers who've had prior experience in creating such tools. Familiarity with the best practices for designing user-friendly interfaces and high proficiency in programming are essential. Communication skills are critical as I'll require updates on development progression and will pot...
An effective freelancer is needed to transcribe and type out text from a total of 25 PDF images. The images contain a mix of both typed and handwritten text. I would like ONLY the typed text to be written into a Word document. Each page only contains about 10 lines (most of the pages are empty spaces with handwritten notes on them that could be ignored). - I would like the typed version to maintain the structure of the original document (formatting of the text, the spaces, etc.). - The document contains some mathematical symbols and abbreviations. Their transcription is necessary. - The project requires great attention to detail and excellent typing skills. - Experience in transcription or data entry would be advantageous.
You will be filling out surveys. This is an easy job that requires no skills. You can give this task to a family member for example. Payment: $0.75 per filled out survey. An average survey takes about 5 to 10 minutes to fill out. How many surveys you should fill out: 100 to 200 Possibility for expansion. Your surveys should be honest and believable. You will have the help of a manual. DO NOT use scripting. All surveys have to be done manually.
I require an experienced freelancer to set up 24 distinct YouTube channels. The task also involves posting one product review video on each channel. All necessary information such as account names, and the videos for upload, will be supplied via an excel sheet. Key responsibilities include: - Creation of 24 DIFFERENT YouTube Channels - Posting one product review video on each channel - SEO optimization for each video The YouTube channels and content are targeted towards an adult audience. Strong SEO skills are also a must for this project. Here is the google doc that contains the video download link, the name of the channel and the keywords it needs to be optimized for:
Hi. I have 2 different spreadsheets. They were originally made on Microsoft excel. See attached pictures. One is a meal plan document and a nutrient database document. An extended formula was made for me. The formula enabled for each row, there was a drop-down menu that I could select which food and this would sync the food, protein, carbohydrate, dietary fibre and dietary fat for the specific food selected I would be able to adjust the numbers to calculate the calories and macronutrients for the food. I have now moved from Microsoft excel to libre office. The formula doesn’t work anymore. The drop-down is not working. The only dropdown comes on "JB Foods", but not linked to nutrient database. The nutrient database doesnt have formulas. It is the meal plans ...
...por Saco", "Variación": "-5.61%" }, In the table in the "Precio" column, if the JSON file of the indicator has the fields "Precio rango menor" and "Precio rango mayor" empty, then the value of "Precio fijo" should be shown. If, on the contrary, "Precio rango menor" and "Precio rango mayor" have a value, then these values separated by a dash should be shown (e.g., 178 - 196). Similarly, for the "Precio mes anterior" column of the table, if the JSON file of the indicator has the fields "Precio anterior rango menor" and "Precio anterior rango mayor" empty, then the value of "Precio anterior" should be shown. I...
