Macro excel cells jobs

...my clients' needs. I am dedicated to providing translations that respect the tone and context of the original text." --- If you are a beginner, here is a version adapted for you: "I am a beginner translator, but I am highly motivated, with a strong passion for languages and a solid understanding of grammatical structures. I am comfortable translating [describe the types of text you prefer or excel at, e.g., simple articles, product descriptions, emails]. My goal is to learn quickly, improve, and provide quality translations that meet clients' expectations." --- Tips: Be honest: If you don't have much experience, it's fine to mention it, but focus on your enthusiasm and willingness to learn. Specify languages: Always mention the language...

I'm in need of a proficient Excel expert who can devise a mathematical formula tailored for tracking a business budget. The primary function of this formula will revolve around facilitating various financial calculations. Ideal Skills and Experience: - Extensive knowledge and experience with Excel - Strong background in financial analysis - Previous experience in creating budget-tracking tools - Ability to explain complex formulas in simple terms

I need a custom Excel workbook specifically designed for estimating costs in the construction of custom built sunrooms. Key Requirements: - The workbook should be able to estimate costs for a variety of elements including material costs, labor costs, and permits and fees. - There should be a customer input window for various cost factors including packages for windows, framing, and foundations, as well as siding and roofing. - Additional cost categories to be accounted for include drywall, insulation, electrical, HVAC, interior trim, exterior decking, and flooring. Ideal Skills and Experience: - Proficiency in Excel with a strong background in creating custom workbooks. - Experience in construction cost estimation. - Understanding of sunroom construction and necessary mate...

I need assistance in updating my Excel file with data sourced from an online source. Specific Requirements: - Extracting complete records with all available details from the online source: - Updating the Excel file accordingly. - You can use Excel or Google Sheets (either work) - API or Manual Update possible. (API is recommeded) - Add data in yellow section needs to be updated. - Work needs to be completed in 1 day. See attached excel file. Excel Password: 12345

I'm looking for an expert in Excel and cryptocurrency trading who can help me automate a trading system. The project involves: - Creating an Excel-based system that connects to major exchanges like Binance, Coinbase, and Kraken. - Implementing a triangular arbitrage trading strategy within this system. - Primarily focusing on automating trading execution. Ideal candidates should have a strong background in data analysis, trading automation, and a deep understanding of triangular arbitrage. Experience with these specific exchanges is a plus. The goal is to develop a reliable, efficient, and profitable automated trading system. Attached reference video:

I'm looking for a proficient software developer to create a Windows-based Point of Sale (POS) software for me. This software should cater to a multi-user environment, with a client-side interface for cashiers and a manager server for inventory control and oversight. Key Features: - The software must support importation of items from an Excel spreadsheet to streamline inventory setup. - At least three concurrent users should be supported, with potential for scale. - Additional features like sales reporting, customer management, and employee time tracking are required. - A hybrid user interface (touchscreen-friendly with keyboard and mouse options) for the cashier side. - Custom, role-based access control for different users, beyond just basic cashier vs manager permissions. Id...

I'm looking for someone to convert my Excel project data into an MS Project Gantt chart. The Excel sheet contains both tasks and resources, and I want the Gantt chart to reflect a mix of high-level milestones and detailed tasks. Key requirements: - Understanding of both Excel and MS Project - Ability to accurately represent tasks and resources - Skill in creating a Gantt chart with a blend of detailed tasks and overall milestones - Knowledge of incorporating task dependencies, resource allocation, and critical path identification into the Gantt chart Ideal candidates for this project will have experience in project management and a strong proficiency in MS Project. Please include examples of similar projects you've completed in your application.

I need assistance to convert data from 11 Word documents into a Microsoft Excel or CSV file. The data in the Word documents primarily consists of text. The converted data does not require any specific text formatting to be preserved; plain text is fine. I would like the text to be organized in the Excel or CSV file with one paragraph per row. Ideal Skills and Experience: - Proficient in Microsoft Excel - Experienced in data conversion tasks - Attention to detail for accurate data entry - Able to handle multiple documents efficiently.

... bez = (1, 4).Value If bez <> "" Then z = 2 vergl = (z, 1).Value While vergl <> "" If bez = vergl Then With sapConn .System = vergl .Client = (z, 2).Value .user = (z, 3).Value Rem .Password = Cells(z, 4).Value .Language = (z, 5).Value .ApplicationServer = (z, 6).Value .SystemNumber = (z, 7).Value .SNC = True .SNCName = (z, 4).Value .SNCQuality = 3 fehler = .Logon(0, True) vergl = ""

...Saves data to CSV or Excel files. Data Comparison: Compares newly extracted data with previously saved data. Highlights differences: Added entries: Green. Updated entries: Yellow. Deleted entries: Red. Displays comparison results in a table within the program. User Interface (UI): All interface elements (buttons, labels, etc.) in Korean. Buttons: "Login and Start": Logs into the target website. "Extract Data": Scrapes data from the website. "Load Existing Data": Loads previously saved data. "Run Comparison": Compares new and existing data. "Save Results (CSV/Excel)": Saves comparison results to a file. Table Display: Displays extracted and compared data clearly in a table format. Result Saving: Supports saving in CSV for...

I'm in need of an Excel expert who can create a formula for me that ranks data in one column, starting a new rank when data changes in another column. Key Requirements: - The rank needs to be sorted in descending order within each group. - Understanding of IF statements, SUMIF/SUMIFS, and COUNTIF/COUNTIFS is a must. - Experience with complex Excel formulas and conditional calculations. Your expertise will help me streamline my data analysis process.

I'm seeking an experienced accountant to c...an experienced accountant to create a comprehensive balance sheet and profit & loss statement for a small business. Must have an understanding of USA tax code and a creative mind to explain entries and provide valid scenarios in the current post covid business environment. The deliverables should be provided in an Excel spreadsheet. Ideal Skills and Experience: - Proven experience in accounting and preparing balance sheets and profit & loss statements - Proficiency in Excel - Experience working with small businesses - Attention to detail and ability to deliver accurate financial documents Please note that I currently do not use any accounting software. Therefore, the balance sheet and profit & loss statement ...

I'm seeking a professional who can create a sophisticated Excel sheet for me. This sheet should: - Calculate arbitrage opportunities across multiple cryptocurrency exchanges, specifically Binance, Coinbase, and Kraken. - Fetch real-time cryptocurrency prices through API integration, rather than relying on manual entry or CSV imports. The ideal freelancer for this project should have extensive experience with Excel, a solid understanding of cryptocurrency and its market, and proficiency in API integration.

...be paying a fixed price of ₹100–₹200 for the entire project. If you’re okay with this price, kindly message me back so we don’t waste each other’s time. ### **Tasks to Complete** 1. **Update Portfolio Excel File**: - Add details of 12 new clients who hired me after the initial 60 reviews (the current file includes only 60 reviews). - Create a new column to include links to the portfolio folder for each project, ensuring the links match the respective projects. - Add a column with filters to categorize projects by type, such as: - **Data Entry** - **Excel Charts** - **Outsourced Projects** (e.g., Python projects outsourced to another freelancer). - **And More**. 2. **Organize Portfolio by Project Ty...

I'm looking to have an interactive Excel dashboard created, focusing on specific parameters mapped at the district level for India. The primary parameter of interest is the Count of Automobile Competition. Key Requirements: - An interactive dashboard that visualizes the Count of Automobile Competition at a district level. - Moderate interactivity, including hover effects and clickable elements. - Presentation of data in an engaging and insightful manner. Ideal Skills and Experience: - Proficiency in Excel, particularly in creating interactive dashboards. - Experience in data visualization and presenting complex data in a user-friendly way. - Understanding of the Indian geographical and automobile landscape would be a plus.

I need a button added in the seller's account for downloading goods using the Unisite CMS script. This should also include a button in the admin panel for the site admin to download products on the seller's tab. The file format for the downloaded goods list should be in Excel. Ideal skills and experience for the job include: - Proficiency in PHP and knowledge of the Unisite CMS script. - Prior experience in creating similar download functionality. - Familiarity with Excel file formatting and handling.

I'm looking for assistance with Excel, specifically with data entry and organization. The primary focus will be on organizing customer information by customer ID. Key Responsibilities: - Organizing customer data in Excel - Ensuring accuracy and efficiency in data entry Ideal Skills: - Proficiency in Excel, particularly in data entry and organization - Experience with handling customer information - Attention to detail Experience with SEO is a plus, as I am also interested in optimizing this data from an SEO perspective. Please provide examples of similar projects you have completed in your proposal.

I'm in need of a detail-oriented professional to assist with cleaning and entering customer data in Excel. The primary task will be identifying and rectifying errors and inconsistencies within the data. Key Responsibilities: - Cleaning customer data in Excel - Data entry into Excel Ideal Skills: - Advanced Excel skills (proficient with formulas, pivot tables, macros) - Experience with data cleaning and data entry - Attention to detail to identify errors and inconsistencies Your work will help streamline our data management processes and improve overall data quality. Please reach out if you're interested and available.

I need a dedicated professional for manual data entry from printed documents. Key Responsibilities: - Accurately transcribing text data from physical documents into designated digital formats. Ideal Skills: - Attention to detail: Ensuring data is entered correctly without mistakes. - Profici...a dedicated professional for manual data entry from printed documents. Key Responsibilities: - Accurately transcribing text data from physical documents into designated digital formats. Ideal Skills: - Attention to detail: Ensuring data is entered correctly without mistakes. - Proficiency in typing: To ensure efficiency in data entry. - Familiarity with basic software: Such as Microsoft Word, Excel, or Google Docs. - Ability to work independently: Following instructions without constant su...

I'm looking for a professional who can build a comprehensive Excel spreadsheet for daily cash flow management. The model should ideally cater to the following requirements: - **Cash Flow Management**: The primary purpose of the model will be to assist in tracking and managing daily cash flow. - **Graphical Analysis**: The model should include features for graphical analysis, enabling easy visual representation of cash flow trends. The ideal candidate for this project should have extensive experience in financial modelling and Excel, with a strong understanding of cash flow management. Skills in creating visually appealing and informative graphical representations within Excel will be particularly beneficial.

I'm looking for a skilled professional to assist with data analysis and report generation in Excel, as well as setting up workflows, integrating with other tools, and customizing fields and modules in my Zoho CRM. Key Responsibilities: - Analyze data and generate reports in Excel - Customize Zoho CRM to fit our needs - Set up efficient workflows in Zoho CRM - Integrate Zoho CRM with other necessary tools Ideal Skills: - Advanced Excel skills - Proficient in Zoho CRM - Excellent data analysis capabilities - Experience in CRM customization and workflow setup - Familiarity with CRM tool integration

I need assistance in designing and organizing three Excel sheets to streamline our workflow and improve visual appeal. Below are the specific requirements: Sheet 1: Annual Events and Campaigns Calendar Purpose: This sheet will serve as a comprehensive calendar for all events and campaigns throughout the year. It should be easy to read and user-friendly for input by all team members. Sections: Marketing Campaigns Events and Conferences Social and Digital Media CEO Profile Raising C-Suite Engagement Traditional Media Internal Communications and Employee Engagement (EE) International Relations Community Engagement, with subsections: School Visits Festivals Farms Engagement Commercial Campaigns Other. Requirements: Each section should have enough cell space for ...

I accidentally deleted some crucial Word and Excel files from my SSD 6 months ago. I consulted several professionals, they all came to 2 problems: 1, The software cannot find out the files I need. Looks like the software only has a limit on storage of deleted files. After deletion, I have played and deleted a lot of games, so the deleted files scanned a huge, included mostly the games, not the files I want. 2, The recover files are not readable. - I'm looking for a data recovery expert who can use advanced tools to recover my lost files. - Previous experience with SSD data recovery is preferred. - Knowledge of recovery methods for Word and Excel files specifically is a plus. - Chat with me.

Hi,I have two excel sheets in one doc. One is with customer information (name, last name, date of birth, etc) and a code called Leistungsort. The code tells me in which store they went shopping. In the second excel sheet there is the adress of the shops including the bsnr. I need a couple of things. 1.) The adresses of the shops have to automatically be integrated into the sheets with the customers. Columne of the code (Leistungsort is the same in both excel sheets, so with that matching would be possible) 2.) After that i need a word letter with a standardized thext includeing all the customers from one shop. i need one word doc for each shop with the name of all customers. Please see the examples attached. This tasks need to be repeated every 2-3 month so i need a t...

...automatically receive reminders for the event via WhatsApp and email. • Automation tools like Power Automate or other free solutions should be used (NO paid 3rd party integrations allowed). 3. Backend Dashboard for Admin • The admin should: • Able to upload an Excel file containing a list of attendees to be added to the sign up database • Create and schedule to Trigger *Unlimited* bulk messages (email and WhatsApp) from the dashboard to remind/invite them to a Zoom session. • Functionality should include: • Bulk messaging from the Excel data. • Management and re-blasting scheduling options for reminders. Recourses : Website is using wordpress . Microsoft suite , hosting . Send me the Video ( similar project you have done before ) , Sc...

I'm in need of a proficient Excel VBA developer to create a high-performance data logger for me. The primary function of this tool is to log data from a wireless barcode scanner, record weight, and convert that weight into quantity. Key Requirements: - The logger must access conversion data from a sheet that could have over 200k lines. - A more efficient version is needed compared to an existing sample I have. The current version is sluggish due to file size. - It should support multiple users on a local network, compiling all results into a single sheet without missing any lines. - The project has a fixed budget, which is not based on hourly rates. Ideal Skills and Experience: - Extensive experience with Excel and VBA, particularly in creating userforms. - Previous wo...

I'm looking for a professional with strong skills in MS Excel and data analysis to create a comprehensive dashboard for tracking key performance indicators (KPIs). Key Requirements: - Create an Excel dashboard primarily focused on tracking KPIs - Analyze financial data specifically related to revenue and expenses - Visualize key metrics such as sales performance, profit margins, and operational efficiency The ideal freelancer should have: - Extensive experience with MS Excel and creating dashboards - Strong data analysis skills - Ability to present data in a clear and engaging way using MS PowerPoint Please include examples of similar projects you've completed in your proposal.

I need a professional to convert a PDF statement containing financial transactions into an Excel file. The transactions should be organized in Excel exactly as they appear in the PDF.

I need a freelancer to convert my PDF bank statement into an Excel format. The Excel file should provide a summary of my transactions.

I'm in need of a proficient freelancer to develop a so...need of a proficient freelancer to develop a sophisticated Excel-based accounting system for my business. This system should not only track sales, purchases, payments, and receipts but also offer full automation and complex tracking capabilities. Key Requirements: - Advanced Level Complexity: The system should be capable of complex tracking and be fully automated. - Basic Integration: I need the system to connect with simple accounting software. - Custom Templates: The system must include templates for invoices and financial statements. Ideal Skills: - Expert in Excel with advanced formula and macro skills. - Previous experience in designing comprehensive accounting systems. - Ability to create custom temp...

I'm seeking an experienced Excel professional to create a comprehensive balance sheet for tracking my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required at this moment, the ability to easily incorporate them in the future would be a significant advantage. Please ensure the design is user-friendly and intuitive. Excel VBA skills could be beneficial for automating some parts of the sheet.

I'm looking for a proficient Android app developer to create a telecalling application with the following features: - Admin Panel: Ability to upload contact details from an Excel sheet. - Click-to-Call Functionality: Contact details displayed on the app for easy dialing. - Feedback Mechanism: Capturing conversation feedback through predefined options. - Tracking Features: Monitoring total calls dialed, average talk time, and call status tracking (completed, missed, missed). - Reporting: A dashboard that provides comprehensive reports. The primary aim of this app is for lead generation. The ideal candidate should have substantial experience in app development, preferably with telecalling apps, and be able to ensure the app is user-friendly and efficient.

I need someone to convert my handwritten notes, written in both Bengali and English, into an Excel spreadsheet. The task involves not just transcription, but also proper typing and formatting to ensure the data is organized and easy to read.

We are looking for a detail-oriented freelancer to format a spreadsheet containing phone numbers and consent time stamps for easy upload to Klaviyo. The ideal candidate should have experience with data organization and spreadsheet management. Your task will involve ensuring that all...stamps for easy upload to Klaviyo. The ideal candidate should have experience with data organization and spreadsheet management. Your task will involve ensuring that all entries are accurately formatted and ready for upload, following specific guidelines we will provide. If you have a keen eye for detail and are proficient in Excel or Google Sheets, we would love to hear from you. Relevant skills: - Spreadsheet management - Data entry - Attention to detail - Proficiency in Excel/Google Sheets ...

I'm seeking a finance and Excel specialist to assist with my budget tracking spreadsheets. The task involves data entry, formula checking, and calculations. Key responsibilities include: - Assisting in the development of detailed custom reports within the spreadsheets - Working with a variety of financial data, including budgets and 1 to 10-year revenue projections Ideal candidates should possess: - Extensive experience with Excel and finance - The ability to create detailed custom reports - Proficiency in handling a wide range of financial data

Please Sign Up or Login to see details.

I need a skilled financial analyst to prepare a Pro Forma Income Statement, Balance Sheet, Cash Flow and Waterfall Statements from my Excel data. This is specifically for a project I'm involved in, with the ultimate goal of applying for a loan. Ideal candidates should have: - Proficiency in Excel and financial modeling. - Experience in preparing financial statements, particularly various financial statements. - Understanding of loan application requirements and investor perspectives. Please ensure you can deliver a comprehensive and professional document suitable for loan application purposes.

Seeking a full-time member to ...48 hrs/week. If we find during that period that you are a good fit for the role, this could become a long-term position. Our budget for the job is $2/hr USD. Requirements -- Available Mon - Sat, 9am - 7pm NYC time -- Great visual eye -- Attention to detail -- Fluent in English -- Great communication (verbal and written) -- Patience -- Experience with Google Docs, Google Calendar, & Microsoft Excel preferred -- Content writing experience is a plus. -- Newsletter management is a plus. Roles & Responsibilities -- Quality check photos and provide feedback to photo editor. -- Schedule photography appointments with clients and photographers. -- Respond to customer inquiries via email promptly. -- Send lead generation messages. -- Online resear...

As per discussion this the quotation for Enter name and pricing of video game in excel template. For 2 website

I'm looking for someone to help me present my survey results in an engaging and readable way. The data is primarily survey results, which will need to be displayed in charts and graphs within Excel, and then exported into a PDF for easy sharing. The data is for 18 clusters. So you will present 18 different presentations and the general one. I need charts and grapghs for each of the clusters and the general one but once you get one right, you only need to duplicate it for the remaining 17. Please show past works for me ro see. Opportunities ahead. Key Requirements: - Proficient in Excel with a solid understanding of data visualization techniques - Able to create a combination of high-level overview and detailed breakdown summary tables - Experience in presenting data...

I need assistance with transferring data from images to Excel. The images will be photos taken by a camera, and I need the handwritten text on these images corrected to specific pre-defined keywords. These keywords will be provided in an Excel file. Key tasks include: - Accurate data transfer from images to Excel in table format - Handwritten text correction to pre-defined keywords - VLOOKUP for item codes from a large list Ideal skills for this job include: - Proficiency in Excel, particularly with VLOOKUP - Attention to detail for accurate data transfer and text correction - Experience with data entry from images Please ensure you have the necessary skills and experience before bidding. Thank you.

We are seeking a motivated and experienced Appointment Setter & Lead Generation Specialist to book meetings with LAWYERS for our online coaching program. This is a long-term opportunity with a performance-based commission structure in addition to ...accent. * Comfortable making outbound calls and presenting via email or phone. * Available to work between 8:00 AM - 5:00 PM PST. * Motivated by performance-based incentives. Compensation: * $3/hour base pay. * Performance-Based Commission: Tiered rates depending on the number of meetings booked. How to Apply: If you have experience in appointment setting and are confident in your ability to excel, please submit your proposal along with your resume. Include a short video (1-2 minutes) summarizing why you’re the perfect ...

I'm looking for an expert in Excel to create a line chart that outlines the pricing for various floor plans and square footages across 6 different communities. Key Requirements: - Incorporate community names, square footage ranges, and price ranges into the chart. - Data points should be grouped by square footage range. Ideal Skills and Experience: - Proficiency in Excel, particularly in creating and manipulating charts. - Prior experience with real estate pricing analysis or similar projects would be a plus.

I'm looking for a skilled professional who can create a process linking my Excel file (Sheena) to send notifications to my supervisor via email. The notifications should be weekly updates and triggered by report completion and error occurrences. The notifications should include a PDF report as an attachment. Ideal skills and experience for the job include: - Proficiency in Excel with automation capabilities - Experience with email notification systems - Ability to convert Excel data into PDF reports - Strong problem-solving skills to handle error occurrences

...Fluent. The UDF calculates thermal and moisture exchanges based on environmental parameters such as ambient temperature and relative humidity, considering the plants as porous parallelepiped blocks. The objective is to understand and simulate the impact of climatic conditions on the internal dynamics of the plants. The code initializes the internal temperature and water fraction within the domain's cells. It employs empirical and physical relations to estimate stomatal and aerodynamic resistances, heat flux, vapor pressure difference (DPV), and convection properties based on flow regimes (natural, mixed, or forced convection). The UDF also computes radiative absorption and total resistance to model the internal temperature and humidity of the plants. Thermal and water vapor ...

I'm looking for a comprehensive calendar spreadsheet to manage the time off for 15 employees. The spreadsheet should track various types of time off including vacation, sick leave, holidays and personal days. Key Requirements: - T...looking for a comprehensive calendar spreadsheet to manage the time off for 15 employees. The spreadsheet should track various types of time off including vacation, sick leave, holidays and personal days. Key Requirements: - Time off should be color-coded for easy visibility. - An overlay feature that shows when another employee has requested the same time off. Ideal Skills: - Proficient in Excel or similar spreadsheet software. - Excellent understanding of color coding and overlays in a spreadsheet. - Experience in creating employee time-off ...

I need a skilled web scraper to extract data for me. Key Information: - Data Type: The specific type of data to scrape has not been determined yet. The freelancer should be able to scrape various types of data, such as product information, user reviews, or cont...data, such as product information, user reviews, or contact details, depending on the client's requirements. - Frequency: This is a one-time project. The freelancer will need to complete the scraping task in one go. - Data Delivery: The scraped data should be delivered in Excel format. Ideal skills and experience for the job: - Proficient in web scraping tools and software. - Experienced in data extraction and data handling. - Excellent attention to detail to ensure data accuracy. - Able to deliver data in required ...

I'm in need of a comprehensive spreadsheet for project management purposes. This spreadsheet should also assist in tracking income and expenses. Key Requirements: - A deep understanding and experience in creating advanced spreadsheets. - Knowledge and skills in project management. - Ability to incorporate financial tracking elements within the project management spreadsheet. Ideal Skills: - Excel or Google Sheets expertise. - Financial tracking. - Project management. - Data organization and analysis. The goal is to have an easy-to-use spreadsheet that can be a vital tool for managing my projects while keeping track of the financial aspects. The ideal candidate would be someone who can create a design that is not only functional but also user-friendly.

I'm looking to have a really simple 4x4 ( 256 cells ) Sudoku game programmed as a web application. The game should generate new puzzles each time, making it an endless source of challenges. Key Requirements: - The game should be simple to play, targeting an educational purpose. - It should run smoothly on all web browsers. - The game should be able to generate new puzzles each time it's played. - use HTML, CSS, JavaScript only adding features like timing and difficulty level Ideal Skills: - Proficiency in web programming languages (HTML, CSS, JavaScript). - Experience in game development, particularly web-based games. - Understanding of educational software design.

I need a freelancer to help me with a simple Excel task. - I have an accounting list of 16 one-line items/amounts that needs to be inputted into a one-page Excel spreadsheet. - I have a sample Excel spreadsheet I want to copy from. - A key part of this job will be the implementation of specific formulas I already have and the data validation rules I will provide. - The task will also involve some degree of data validation (using drop-down menus and restrictions). - The whole project should not take more than 30-60 minutes to complete. Ideal skills for this project include: - Proficiency in Excel, particularly in using formulas and setting up data validation. - Attention to detail to ensure all data is inputted correctly and the spreadsheet functions as intende...