Macro excel cells jobs
...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
I'm searching for a Tally developer proficient in data management, particularly exporting various financial data from Tally to different platforms, such as Excel and CAOffice SW TB. The main tasks include: - Exporting TDS deduction from Tally to Excel - Exporting Tally TB to ITR PL BS - Exporting Tally TB to CAOffice SW TB Ideal applicants should showcase past work relevant to these tasks. The deadline for project completion is within 1 month. If your experience aligns with these tasks and the deadline is manageable for you, I would love to consider your bid.
I am in need of a talented interior designer to add a modern twist to the midcentury styled bedroom, en suite and wardrobe in my home. The specific requirements for the job are: - Design knowledge: Having a deep understanding of midcentury design and an ability to incorporate modern elements within this design language is necessary. 2D plan...- Experience with residential interior design, specifically bedrooms and en suites - A keen eye for modern trends that mix well with midcentury aesthetics - Strong portfolio demonstrating your design capabilities and versatility. This project requires expert project management skills to oversee smooth operations and timely completion, making it a particularly exciting opportunity for those who excel in their creative and administrative cap...
In this task, I need a freelancer to transform my Google Sheets data into a Microsoft Excel file. While I am unsure about the preservation of formatting during the file conversion process, I appreciate someone who could provide advice on this matter. I am not currently using any filters, so this will not be a concern. Finally, the total should be displayed in bold in the last row. Skills and Experience: - Proficient in Microsoft Excel. - Strong understanding of data conversion between Google Sheets and MS Excel. - An ability to suggest the best approach for formatting preservation could be advantageous.
I urgently need a developer versed in SAS to fix syntax error messages I'm experiencing on my macro program. The macro program specifically operates on SAS. Key Responsibilities: - Identify and correct syntax errors causing malfunctions. - Enhance the program for smoother performance. Ideal Candidate: - Must have experience in SAS software. - Preferably experienced in debugging syntax errors. - Strong problem-solving skills. Your main task is to eliminate these syntax error messages and ensure the program runs flawlessly.
I am seeking a skilled R programmer to develop code for comprehensive data analysis. The project revolves around analyzing scientific research data, with an emphasis on providing descriptive analysis of these data sets, particularly writing code to create interaction matrices that will be used for social network analysis. The code will need to read in data from 80+ Excel sheets, create interaction matrices, and link in ID numbers from a separate document. Ideal Skills: - Mastery of R programming - Experience with scientific research data - Strong skills in data analysis
This task revolves around gathering data available online to paste onto an excel spreadsheet. Here's what I need: - Have the skills to conduct online research. - Extract company names, financial data, and the location of companies found during the research. - Have the ability to organize this information nicely in a spreadsheet. - I will give you the company names and where to find the information, so this is also about the ability to follow instructions I'm looking to get this done asap so speed vs cost is important to me. This is a very simple task. Ideal freelancers will have proficiency in web research, be organized and detail-oriented, and possess excellent data entry skills. Knowledge of finance and basic understanding of businesses is a plus but not necessary, to...
I am looking for passionate and experienced Excel experts who can optimize my Excel Gantt Planner (Calculette Rollout v13 - ) through several adjustments: Formatting Improvements: - **Color Coding:** Implement my provided color palette to create a more visually intuitive and aesthetically pleasing spreadsheet. - **Macros corrections** - **Calendar translation** >>>>>> I need what is in the PPTX file that is attached with the project <<<<<<<< Any ideas, improvements are welcome. + There is another Excel table (Suivi ) and I need a nice looking GANTT planner to be added to it (Project 2 Gantt ). Please DO NOT CONTACT ME to ask for more money than the budget I can afford.
I'm seeking an experienced data visualisation expert for the creation of an interactive D3.js project. Key Requirements: - Prior expertise in creating visuals from numerical data. - Strong proficiency in D3.js for advanced - may need to do data manipulation ising excel or python to get the data tonthe right format for visualisation (not simple bar or pie charts alone) - visualisation to be used in website - Proven skill in creating interactive data visualisations. I am aiming for these visualizations to be very interactive, allowing viewers to engage with the data in a dynamic way. The successful freelancer would ideally present a portfolio evidencing similar past projects. Working closely together, let's make data exciting visually!
My budget not more 20$ 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'm seeking a skilled developer to create a web-based NGO membership software with a mix of pre-made templates and custom design. Functionality is key, and the software needs to easily handle: • Member and staff registration and login • Import and Export Membership with CSV/Excel format • Features for alerts via email and mobile SMS • Payment management • Comprehensive communication tools • Leads and member follow-up capabilities • Appointments and call management • Document management for customers • Creation and dispatch of quotations & invoices • Expense tracking • Staff management features • In depth accounting reports • Catalog or service management features • Features for alerts via email and mob...
I'm currently working on a book project that features 50 newspaper articles I've written. To ensure my work's credibility, accuracy, and ensure no copyright issues, I need assistance in ...assistance in tracing back the original source of each article. Key tasks will include: - Determining the original source of every article - Verifying the accuracy of the information in the articles - Identifying the newspaper title, publication date, and the URL of each original publication All the gathered information must be recorded in an Excel workbook. Experience in data research, data entry works, and strong proficiency with Excel would be crucial for this project. Knowledge of journalism, media law, and an understanding of copyright law would be bonus skills w...
...customer service. Ideal Skills: - Superior Multitasking Abilities: You will need to balance various tasks at once and ensure each one is completed accurately and on time. - Excellent Communication Skills: You will frequently engage with me and possibly clients, requiring top-notch written and verbal communication abilities. - Proficiency in Microsoft Office: You should be comfortable using Word, Excel, PowerPoint for regular tasks. In your application, please include a detailed project proposal outlining how you anticipate handling these tasks and any strategies that you think might help streamline the process. Your proposal should highlight your extraneous skills and demonstrate why you are the best choice for this role. I'm eager to find a dedicated assistant who can m...
I'm seeking a skilled developer to create a utility that generates bulk invoices using imported Excel data, with a unique feature: every invoice will embed a scannable QR code leading to directions for delivery. The project would need to: - Utilize Excel data for automated invoice generation - Embed a QR code on each invoice - Enable the QR code to display a Google Maps view of the delivery location once scanned - Ensure that scanning the QR code also reveals the name and contact information of the deliverer Ideally, you should have: - Proficiency in Excel data manipulation - Experience in QR code generation and integration - Familiarity with Google Maps or other map services APIs - Knowledge on incorporating detailed data extraction through QR codes. The end goal...
I'm seeking a talented individual with strong data entry skills to digitize contact information from 125 business cards into an Excel spreadsheet immediately. Details: - Data to be entered includes: ENTER THESE FIELDS BUSINESS FIRST NAME LAST NAME POSITION PHONE CELL PHONE FAX EMAIL WEBSITE ADDRESS CITY STATE ZIP CODE Ideal Skills: - A keen eye for detail as accuracy is paramount - Prior experience with data entry projects - Proficiency in Excel - Excellent time management skills to ensure prompt project completion Note: Only bid if you can start immediately. I'm on a tight deadline and need this task completed posthaste.
In need of an experienced financial modeler with advanced expertise level. Task involves creating a comprehensi...involves creating a comprehensive and complex model, specifically tailored to the context of a water treatment project. Skills and Experience: - Solid background in financial modeling and analysis - Experience in constructing complex financial models - Prior work with water treatment projects preferred - Deep understanding of financial valuation and strategic planning - Expert level command of Excel Please note: Experience with water treatment projects is a significant asset. This assignment requires someone capable of constructing a model that can withstand rigorous scrutiny, so please provide examples of complex models you've successfully completed in the past...
I am looking for a professional who can efficiently extract and copy all information from a PROTECTED Airtable sheet to Excel. No adjustments or specific arrangements on the data are required - I just need all the values intact and legible. Key responsibilities: - Extract all data from the PROTECTED Airtable sheet: - Copy data to Excel without any modifications This is a one-time task, so timeliness and accuracy are essential. Ideal freelancers are those who have extensive experience with both Airtable and Excel, as well as a deep understanding of data extraction principles. Strong attention to detail is an asset.
I'm in immediate need for assistance in managing and analyzing a set of data using Excel. My project involves: - Thorough data entry and organization in Excel. - Conducting comprehensive data analysis. Having proficiency in Excel is a must. Knowledge of various data analysis methods would be beneficial. I'd prefer someone who can suggest the best techniques for my project, as I personally don't have any specific methods like Pivot Tables or VLOOKUP functions in mind at the moment. The timeline on this project is quite tight. Therefore, the ideal candidate should be able to commence work immediately and finish as soon as possible. Prior experience in quick turnaround projects would be appreciated.
I am seeking a meticulous data entry expert for a small-scale project. Key requirements include: - Efficiency in spreadsheet data entry - Skills in data extraction and validation - Ability to handle less than 100 records meticulously The final outcome should be presented as an excel file. An ideal candidate would be someone proficient in handling and organizing datasets in a logical and efficient manner. Attention to detail is crucial for the success of this project.
I'm seeking a skilled Excel specialist to develop an efficient reporting system derived from our Core Banking System. Key Responsibilities: - Enable data extraction, both manual and automatic, for maximum flexibility. - Integrate fundamentals like Financial and Regulatory reports. - Incorporate functionality for Ad hoc reports based on unique user requirements. - Ensure the system is adept to update the aforementioned data on a daily basis. The freelancer best suited for this task will have exceptional skills in Excel, and experience developing similar banking or financial reporting systems. Appreciation for detail and understanding of financial and regulatory protocols are also desired.
I am in search of a skilled sales officer to join our team at Yes Bank, specifically within the ...clients to our credit card services. - Sales Target Achievement: Meeting and surpassing outlined sales targets regularly. The perfect fit for this role is an individual with the following qualifications and experience: - Sales Experience: Proven track record in a sales environment. - Excellent Communication Skills: Ability to engage effectively with potential customers. - Microsoft Excel: Proficient in using Excel for data management and reporting purposes. This role offers the opportunity to work in a dynamic and fast-paced environment, providing measurable results towards the company's success. If you meet the above requirements and thrive in a sales position, we would ...
I'm in search of an advanced Dynare tutor who possesses a comprehensive understanding in two specific areas: macro-processing and solving models. These are targeted areas of study and application I need assistance in. With a primary focus on model simulation, the ideal candidate will guide me through mastering these areas within Dynare. My expectations include but are not limited to: - Profound knowledge and application skills in Dynare Macro-processing. - A solid understanding and practical experience in Dynare Model solving. - Prior teaching or tutoring experience is advantageous. Your role will directly contribute towards achieving my goal of using Dynare for model simulation. It is, therefore, imperative that you have a command over these areas and can effectivel...
I need an expert typist to input assorted data - text, numbers, and dates - into a multi-columned Excel sheet. Key Tasks: - Manually enter a vast amount of structured data, extending over 50 columns and rows - Ensure accuracy as the consistent structure should be maintained across all filled cells Ideal Candidate: - Proven experience with high-volume Excel projects - Exceptional attention to detail for accuracy - Ability to follow a strict data structure - Familiarity with varied data types - specifically text, numbers, and dates.
As a growing brand in the cosmetics market, I need a striking packaging design that appeals to a universal audience. My products are not confined to any particular age group, thus the design should be attractive to teens, adults, and seniors alike. The scope of this project is the packaging design only. A design brief will be provided upon project commencement. To excel in this job, you should ideally have: - Proficiency in Adobe Creative Suite, especially Illustrator and Photoshop. - Prior experience in packaging design, specifically for cosmetics. - An understanding of global trends and demographics. - A knack for creating designs that are both trend-forward and timeless. Your portfolio should demonstrate your versatility and ability to design for a contemporary, universal au...
...scientist proficient in Excel to assist in the manipulation of CSV data for my project. Download NPI database Find NPIs with these taxonomies and create a spreadsheet, then create a list of fax numbers and pharmacy name. Key responsibilities: - Perform data analysis and data modeling - Apply machine learning techniques Required Skills and Experience: - Proficient in data manipulation using Excel - Ability to perform complex data analysis - Familiarity with machine learning techniques - Knowledge in data modeling As the right freelancer, you will have extensive experience in Excel for manipulating CSV
...can create any offline service with dynamic form so admin can create unlimited service IT service- 1. Website design (Show portfolio) 2. Graphics 3. Google reviews 4. Social media handling 5. Android/ios app 6. Facebook / instagram like increase Wallet: 1- Recharge (with payment gateway / offline method) 2- Transition Reports 1. Download all reports (excel/pdf) Commission Phase 3- Developer Mode 1. Developer add any new page or change menu 2. Add new graphics 3. Add training videos 4. Update script to latest version if changes anything 5. Server status 6. Change theme color 7. Change Google AdSense 8. Change any users password 9. Google analytics/ webmaster add 10. Download backup automatic daily or manual Announcement role 1. Add ...
...site and various social media platforms. The goal is to develop an AI solution that can: - Generate engaging Articles, text, video (with subtitles and voiceovers), and image content. - Perform automatic content posting (with editing option before distribution) My objective it to: 1. Create a blog Article/post on my site though: A list of articles names, Category, keywords, Meta description (Excel sheet). The article will consist of a 900 -1300 words, and will include: introduction, content, bullet points, quotes, and any SEO tricks to make it more appalling to google search engine, Including research and publications sources links. (we will add Images to the article ourselves) ✔Check point 1 : Option to edit the article (on wordpress), after article approval: the article w...
Hi Sophia B., Please go over Excel and make sure that English and Ukrainian are attached. SLA is Tuesday, March 19th. Thank you, G
I am looking for a professional who can efficiently extract and copy all information from an Airtable sheet to Excel. Key responsibilities: - Copy/Extract all data from the Airtable sheet: - Copy data to Excel without any modifications
I'm in need of professional assistance to create a 12 months sales projection forecast excel spreadsheet for my events management business. I'm particularly interested in a comprehensive understanding of the industry trends impacting these forecasts. Ideal candidates for this job would have: - Previous experience in building forecast sheets in events management industry - A deep understanding of industry trends Your task will include: - Analyzing my forecasted sales data - Highlighting key industry trends - Providing detailed findings which relate these trends with sales forecasts. Please note your experience with events management and data analysis in your bid!
I am in need of a proficient Excel Expert for data filtering and formatting. You must exhibit exceptional skills in the mentioned areas: - Filtering: Your role will include filtering my data sheets as per specific conditions. Mastery in this area is a must. - Formatting: I need my numbers formatted in a general fashion for proper import. Therefore, a comprehensive understanding of number formatting is necessary. This project requires advanced working knowledge of Excel and a meticulous eye for detail. For successful completion, you need to display exceptional proficiency in Excel's data filtering and a deep understanding of general number formatting.
I'm looking for a meticulous data entry specialist adept at managing Excel files. Your responsibilities will include: - Copying and pasting information; - Organizing and cleaning the data; - Verifying the accuracy of the data. Specific skills and experience required for this project include: - Proficiency in Microsoft Excel; - Experience in data cleaning and organization; - Competence in data verification. Your objective will be to manage and improve the overall quality of our Excel data and to carry out your tasks efficiently. Consideration will be given to freelancer applicants with proven track records in similar projects.
This project is about creating a professional yet creative business profile (information memorandum) for a business brokerage, powered by an easily updatable Excel back-end. I'm looking for someone with strong document design and spreadsheet expertise. At the moment we have the attached document that is both out of date (design wise) and requires 100% data input from staff. I am wanting a document that answers can be imported directly from excel. The generated profile will be about 20-25 pages long and include approximately 60 distinct data fields, these fields will be collected from each client and answers stored in an excel sheet. The idea being - we need a beautiful document that can have easily duplicated merge fields. - Company name and summary - Address...
I'm seeking an adept freelancer to develop a web-based voice recognition tool, with macro recording functionalities, enabling users to execute sequenced clicks through voice instructions. Ideal requirements for the project include: - Strong experience in AI voice recognition: The successful freelancer must have previous experience in AI voice recognition systems. - Knowledgeable in Macro recording: a good understanding of macro recording and its application is crucial for this project. - Adept in web-based platform development: since this tool will function on a web platform, experience in web-based projects is a must. Even though the specific voice recognition software wasn't designated, proficiency in familiar solutions like Google Speech-to-Text, IBM W...
I'm seeking a talented graduate graphic designer capable of creating an appealing, bright, and colorful...And for version two upload it to a standard free media player so subscribers can get it into email. This needs to be print ready and i need fast turn around with few if any back and forth questioning. - Strong grasp on modern design principles and decisiveness - Ability to translate both informal and professional tones visually - Ability to engage with a young, professional demographic To excel in this task, ideally you will have: - Prior experience in designing for print media especially newspapers - Ability to deliver innovative and playful layouts minimalistically - Fluency in Adobe Creative Suite or similar tools I look forward to seeing your fresh, dynamic, and ...
... ## System Requirements ### Admin Features 1. **User Management** - **Description**: Admins can create and delete user accounts, managing access levels within the application. - **Functionality**: Includes forms for entering user information and mechanisms for account deletion. 2. **Lead Management** - **Description**: Admins can upload leads from Excel files or enter them manually into the system. - **Functionality**: Supports Excel file uploads and manual data entry forms. 3. **Email Notifications** - **Description**: Automatic notifications are sent to admins whenever a new lead or user is created. - **Functionality**: Integrates with an email service to dispatch notifications. ### User Features 1. **Dashboard Customization** - **Description**: The user das...
I need an expert to modify my existing Excel spreadsheet and transform it into a fillable PDF form. The interactive form will contain a description field, checkboxes, date field, price fields, perhaps one calculation but that isn't necessary. I have attached a sample of the excel file. There may be a few changes. Does this sound like something you can do? Here's what I'm looking for: - Ideal Skills: Extensive experience with Excel and PDF form creation is a must. - Experience working with custom fonts and graphics that will need to be duplicated onto the form -Experience: Please include any previous work involving the conversion of an Excel file into a fillable PDF form. Please note that the data that needs to be captured in the form is b...
As the project requester, I'm looking for a skilled spreadsheet wizard that can incorporate conditional logic into a new supply materials inventory management tool. Key components include: - Populating certain cells with drop-down boxes, triggered by specific numerical value selections. - Provding an efficient visualization and management system for our supply materials inventory. The freelancer perfect for this project would possess: - Deep understanding and expertise in advanced spreadsheet functionalities, particularly connected to conditional logic. - Past experience in creating, adjusting, and manipulating inventory management tools. - Ability to work promptly, deliver on time and respond quickly to any necessary revisions. I'm looking forward to working close...
Looking for a professional financial analyst adept in scrutinizing balance sheets. - Your primary task will be financial statement analysis, specifically focusing on the balance sheet. - Proficiency with Excel spreadsheets is crucial as all data will be provided in this format. Ideal Skills: - Comprehensive knowledge of financial statement analysis - Expertise in Excel - Proven experience in financial analysis, particularly balance sheets. The perfect freelancer will have a keen eye for detail and the ability to draw insights from financial data. Budget is 50$
I need assistance in creating a VLookup formula in Excel to fetch matching data from another worksheet. Having already identified the columns, the formula should be designed to fetch data from the specified columns. Freelancers with extensive experience in Excel formulas and in particular, the creation of VLookup functions, are highly preferred. Knowledge, skill, and proficiency in Excel spreadsheet manipulation are essential.
Go over two excel sheets and highlight records from first sheet containing specific text from the second sheet
I require a tool or script that can effectively convert my checking account bank statement from PDF to Excel. There are 4 bank accounts, from 2017 to 2023 - totaling 159 files in PDF. - 2 accounts from Santander - 2 accounts form Caixa Economica Please find attached 2 PDF files as an example. For Caixa Economica statements, there are only 2 PDFs (one for each account). For Santander, the PDFs are divided by month. Details: - Critical data fields to be extracted include: transaction date, transaction description, transaction amount, number of destination accounts for PIX, TEDs and DOCs (bank transfers), and account balance. Ensure accuracy in these fields during conversion. - The Excel spreadsheet should have 4 tabs, one for each bank account. - The converter should be de...
I am in need of a proficient Excel expert for some unknown tasks. Since I haven't detailed the specifics, I would like potential freelancers to be adept with: - Formulas and calculations - Data analysis and reporting - Data manipulation and formatting Whether it's creating a new spreadsheet or modifying an existing one, I will need help. Therefore, display adaptability and experience in various Excel scenarios. Your application should include past work, experience and a detailed project proposal despite the brevity of my requirements. Please provide as much detail as possible in your proposal, due to the unspecified nature of the tasks.
I'm seeking a skilled Excel user for formula automation and chart creation in my project. Your role includes: - Creating Excel formulas that automate various functionalities. - Incorporating charts into the spreadsheet to visually represent the data. Although the specific type of charts hasn't been specified, a proficiency in creating diverse types of charts (including bar, line, and pie) will be advantageous. A strong understanding and experience with Excel formula automation and data visualization are essential for this task.
I'm in need of an expert with proficiency in Excel and Quickbooks. An Excel spreadsheet needs to be created. The data dump will be provided, your task will be to extract specific information from it. The needed data includes: - Sales data (Date and Customer name, Amount and units sold) - Expense details (Date, Vendor name, and rental paid per unit) Need various information to be in one place and one click. The extraction process must be automated and compatible with Quickbooks for seamless integration. The ideal candidate should have experience in data extraction, Microsoft Excel, and Quickbooks, as well as exemplary accuracy skills to ensure the data is free from mistakes.
I am seeking a freelancer who excels in using Excel to manage large data sets. You will need to perform specific tasks, including: - Data Filtering: Skilled in using various Excel functions to sort and filter large amounts of data. - Basic Arithmetic Operations: Proficient in performing addition operations on the data set. - Statistical Analysis: Capable of conducting descriptive statistical analysis on the data provided. The ideal candidate possesses an excellent command of Excel, and a strong background in statistical methodologies.
...software developer experienced in building interactive applications. The task is to develop a custom 6x6 grid, digitally inspired by Jeopardy game dynamics, with key requirements: - Numbers arrangement: The grid should feature 36 cells assigned sequential numbers from 1-36. - Slide content: Each cell, when clicked, should reveal a slide. This slide will feature text-only content. - Shuffle function: An integral part of the task is creating a user-friendly way of shuffling and altering the text content of the slides. However, the sequential numbering of the grid cells (1-36) should remain fixed. - Must be able to add my logo to the material as well. Ideal candidate should have a proven track record in similar projects, with excellent attention to details and user inte...
I need to redevolop a simple shopping cart based on Excel VBA. Requirement is to rework current design and function. I prefer developer that can with russian and english language, as this would help get some information from former versions. Pls contact me. BR Michael