Excel macro script insert data spreadsheet jobs

I'm looking for a skilled Excel expert to help prepare a company operations sheet. The project involves: to Prepare a Small Company Operations Sheet My Budget is fixed . 1000 Rupees I want an auto-calculated Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator Excel Template Contractor Invoice ...

...Python, Excel VBA, and API integration. The primary task is to extract specific data from the API response, and populate it into a designated column in an Excel file. Key Requirements: - Experience in Python programming - Proficiency in Excel VBA - Demonstrable experience with API integration - Ability to parse specific data from an API response from Google Server - Good understanding of automating tasks in Excel Further Details: - The primary purpose of the project is to send API requests with image URLs listed in column A of the Excel file. Upon receiving the API response, the relevant data should be extracted and placed in column D and B/C/E to be populated. - The setup should be easy to execute when needed by click of few bu...

I need an Excel workbook that incorporates customer contact information, sales volumes, and insightful visualizations for better decision-making. Key Features Needed: - **Customer Contact Information**: The workbook should include customer names 2 contact info fields (email & phone). Data Representation: - **Sales Data & Customer Slicing**: There should be 3 sheets within the workbook with sales volumes. Users should be able to use a pivot table to filter and slice data by branch and year. - **Customer Variances Year-over-Year**: I need the workbook to show customer variances year-over-year. This should include both percentage change and absolute difference. Visualization: - **Top 10 Customers**: The workbook should contain an Excel table th...

I'm on the hunt for an Google App Script developer who can assist me with the creation of one simple custom user interaction functions. Utilizing your skills in scripting, your main task will be to develop a feature that enables an action when a user clicks on a cell within a specific column. To make this a success, you should: Task: "When ever user clicks on a cell in column G, for popup (yes/no) to show up, and if clicked on yes, for that cell to be populated with today's date. If clicked on no, not to perform this function for 15 seconds." Estimated time for development is 10-15 min. + additional 5-10 min call to confirm deployment on machine.

I'm in need of an Excel VBA expert to assist me in my project. I require assistance in writing new code, as well as debugging existing code. Specifically, the VBA code is intended for various purposes: - Automating repetitive tasks - Performing data analysis and manipulation - Creating custom functions and macros I specifically have to macros that I've started working on and need debugging: - Replacing references to cell/range addresses in formulas by their name - Implementing Montecarlo simulations (with automatic creation of histograms and data output) The ideal freelancer would have proven expertise in Excel VBA, with a strong track record of writing efficient, maintainable code. It's crucial that the code is robust, error-free, and easy t...

I'm in need of an expert who can install a music streaming script on my platform. The script I'm looking for needs to have user registration and login, search and browse functionality, and playlist creation and management. It should seamlessly work on web browsers, Android devices, and iOS devices. Key requirements: - Installation of a music streaming script with user registration, login, search, browse, and playlist features - Ensure compatibility with web browsers, Android devices, and iOS devices - Integration of PayPal as the sole payment option The ideal freelancer for this project should have a solid understanding of: - Music streaming scripts - Mobile and web app development - PayPal integration - UI/UX design for cross-platform compatibility. Expe...

Main Task: Animated Bride and Groom with wobbling heads giving invite, minimum 30 sec video to be posted on instagram with details about the event - The wedding event details must be woven seamlessly into the design rather than being added as an additional section or a removable insert. - Applicants should ideally possess experience in wedding themes and be able to capture the essence of the occasion. - A refined artistic aesthetic fitting for such a significant life event is paramount. Examples:

I am seeking a professional who is adept at data entry and copywriting. This project will require: - Online form filling using data from existing digital documents. Attention to detail and accuracy is of utmost importance. Skills in data entry and experience with handling digital documents will be essential. - Copy writing for blog and articles. I am looking for someone with experience in crafting engaging, informative, and high-quality content related to my industry. Expertise in blog and article writing is a must, as well as a strong command of English language and grammar. The perfect candidate will possess Excel skills for the data entry part of the project, and should have a track record of creating enticing blog posts that keep the reader's...

Looking for an experienced web developer to create a map-based public website with the following features: Functional Requirements: • Display locations pin on the map based on Excel/database details (name, Address (or Lat/log), Phone, picture etc. Attributes) • Provide a nearby location list on the left based on the current location or a list of locations based on search and filter criteria. • Enable zooming to the selected location from the list and vice versa. When a map location pin is selected, the corresponding list should be highlighted in the left places list. • Map zoom based on the mouse scroll (Should not be embedded google map) . • The list will include pictures and summaries of the place's rating from Google, cost, number of reviews, addr...

I'm in need of a data analysis and visualisation expert, particularly in R. The ideal candidate will be experienced in Excel, STATA, and SPSS as well. The main tasks include performing data analysis, creating engaging data visualisations, and building data models. Key Responsibilities: - Performing thorough data analysis using tools like STATA, SPSS, and Excel - Proficient in R for creating engaging data visualisations - Building data models to support the provided data Ideal Skills and Experience: - Proven experience in data analysis - Expertise in R and other relevant tools like Excel, STATA, and SPSS - Ability to create engaging data visualisations, preferably in the form of stacked bar cha...

I need your help in creating an automated script or formula that can run multiple find-&-replace functions, at the same time, on an Excel spreadsheet that could regularly include 1,000 to 5,000+ records. Specifically, I will run this routine on the physical address column of data (not on the Company Name or City or State columns). In the attached .xlsx file, I would run the routine for all of a Column B. Here are the 20 specific tasks involved: 1. If a cell contains the word "Ave" or "Ave.", it should be replaced with "Avenue". 2. If a cell contains the word "Blvd" or "Blvd.", it should be replaced with "Boulevard". 3. If a cell contains the word "Ct" or "Ct.", it should be ...

Hello, I need a simple website that uses OpenLayers script for my project. It's a Store Locator website with store detail pages ("similar" to TripAdvisor). The structure will be: - Home page: a full page map with all custom markers with OpenLayers and OpenStreetMap - Responsive ( of course :-) ) - Markers will be taken from a table in the database (ID, name, address, coordinates, tel, email, social etc etc...) - When you click on a marker there will be a popup with some information and if you click on the popup you will be redirected to the detail page of the store - In the detail pages users can add photos (approved by admin) - Users can review the store and add photos in the review - Just to be sure you read this description and you are not a bot, please send me &...

I have a set of scanned images in PDF format that I need converted into an Excel sheet. The job is purely data entry - you are to copy the content from the scanned images into an Excel sheet. The freelancer should have excellent typing skills and attention to detail to ensure that no data is missed or entered incorrectly. Ideal Skills: - Proficiency in Excel - Fast and accurate typing skills - Detail-oriented - Experience with data entry, especially from scanned images - Excellent communication to ensure any questions about the data are clarified before entry

...in advanced financial modeling, preferably within the real estate industry. - Strong analytical skills and attention to detail. - Excellent knowledge of financial principles and real estate market dynamics. - Proficiency in relevant software for financial modeling, such as Excel or specialized real estate software. - Ability to deliver high-quality work within the agreed timeline. Please note: I have a very simple existing base model I want to build on. There will be a few steps toward an aggregated spreadsheet modeling multiple projects: 1. Get one working layer in what will ultimately be a model that aggregates a view across multiple projects. Have a single input section on the project layer for key variables controlling the model. 2. That view should be b...

For a new venture, I am looking for a developer skilled in Google Sheets to help create an efficient manual data entry system. This system will facilitate the organization of professional networking information that has been obtained with permission. The project involves setting up a Google Sheets template to manually enter and organize the following information, which will be collected directly from individuals or public databases where permission is granted: Name Current company LinkedIn profile URL Employment history (including past companies and titles) Educational background (including institutions attended and degrees earned) If you have experience with Google App Script, that would be a plus, as it might be used to enhance the efficiency of the manual entry process. ...

I need someone to create an arena script, details will be attached.

Very simple project - need an excel wiz who can remove some duplicate entries & total up some columns. Only bid if you are an excel wiz & very experiened in excel

I'm looking for a skilled Excel expert to help prepare a company operations sheet. The project involves: to Prepare a Small Company Operations Sheet My Budget is fixed . 3000 Rupees I want an auto-calculated Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator Excel Template Contractor ...

I'm looking for a skilled Pine Script developer to create a custom indicator for Trading View. The indicator will be designed to identify high and low price breakouts on an intraday time frame. Key Requirements: - I'm specifically looking for an indicator that can identify high and low price breakouts. - The indicator should be designed to work most effectively on intraday time frames, specifically 1-60 minute charts. Ideal Skills and Experience: - Proficient in Pine Script. - Previous experience in creating custom trading indicators. - Strong understanding of technical analysis and breakout strategies. - Familiarity with intraday trading patterns and strategies would be a plus. Please provide examples of previous indicators you've created and explain how ...

I require a seasoned freelancer with a strong background in script development and risk management strategies, preferably in trading, to design a script for a Quantower trading platform. The script will be centered around advanced risk management, majoring on stop loss orders, trailing stop orders, and position sizing. The key features required for this platform are: - Real-time market data feed - Advanced charting tools - An order management system Moreover, the script should allow for different input parameters, with a max daily loss and profit target. Here are the specific requirements: - The system should not allow more than a $1000 loss in a day - The system should stop at a $1000 profit target for a day Only bid if you have the necessary skills...

I'm seeking a professional to create a comprehensive PowerPoint presentation and a script for a 6-minute video on a hotel and tourism topic. Key Elements: - The primary focus will be on a particular hotel - The content of the presentation must be engaging yet informative - The script should be concise and highlight the hotel's amenities in a way that is appealing to potential investors or customers Required Skills: - Exceptional writing and editing capabilities - Proficiency in creating engaging presentations - Experience in tourism and hotel industry would be a plus The ideal candidate should be able to deliver a visually appealing and informative presentation that effectively communicates the hotel's unique selling points. Please provide examples of simil...

I need a one-time extraction of specific data from into an Excel spreadsheet. The task involves extracting all data for each date as far back as 1 January 2020. The end product is a long table in Excel also capturing the date of release. Key Requirements: - Extract earnings data that surpasses expectations from a specific website. - Transfer the extracted data into an Excel spreadsheet. Ideal Candidate: - Proficient in web scraping tools and techniques. - Experience in data extraction and manipulation. - Strong skills in Microsoft Excel.

I'm seeking a skilled data scientist with experience in handling structured data to help create a machine learning model. Details of the project is available as an attachment .Data record will shared later on acceptance of proposal . Key Responsibilities: - Develop a robust ML model for predicting customer churn based on the available structured data. - Implement data preprocessing techniques to ensure the data is ready for modeling. - Evaluate and fine-tune the model to improve its accuracy and reliability. Graphs and plots to be plotted accordingly Your proposal should include: - Relevant past work that demonstrates your expertise in ML modeling, - A detailed project proposal outlining your approach to developing the model, including th...

I need a software developed urgently that can generate playlists on Apple Music. I can provide the Apple music song URLs in a Excel file as follows: ... I need to import the playlist into my Apple music player

Exciting opportunity for an excel whizz! I urgently require assistance with embedding photos into an excel sheet. Key Responsibilities: - Insert Photos: You'll be in charge of seamlessly integrating photos into an excel sheet. you should keep the same resolution Skills and Experience: - Excel Proficiency: Strong excel skills are a must. - Attention to Detail: Aligning photos properly within the sheet is critical. - Quick Turnaround: This project needs to be completed ASAP. Get in touch if you've got the passion and experience to deliver this project swiftly!

I am in need of a highly proficient Excel VBA developer who can implement and automate complex data analysis, and generate reports from large volumes of data. Key Tasks: - Implementing intricate data analysis using Excel VBA scripts. - Automating repetitive data management tasks. - Designing and developing report generation tools. This program will be used by a mix of both internal and external users. Therefore, the created solution should be intuitive, user-friendly and reliable. Essential skills: - Proven experience in Excel VBA programming, dealing with large complex sets of data. - Strong understanding of data analysis techniques. - Capable of designing user-friendly interfaces for report generation. This is a chall...

I need immediate assistance with converting 50 invoices into an Excel sheet. The information to be transcribed includes the following columns: Date, CIF, Company Name, and Amount. Ideal Skills: - Proficiency in Excel - Attention to detail - Fast and accurate data entry skills The project has to be completed within 1 day. No specific formatting requirements are needed at this time. Once completed, I will review the Excel file.

I'm immediately needing a skilled computer operator who could expertly manage data entry tasks, file management, and maintain our database. You must be proficient in utilizing Microsoft Excel, Google Sheets, and QuickBooks. Key Duties: - Accurate Data Entry - Efficient File Management - Consistent Database Maintenance Preferred Skills and Experience: - Proficiency in Microsoft Excel, Google Sheets, QuickBooks - Fast yet accurate typing skills - Strong knowledge in File Management and Database Maintenance - Good time management skills Your ability to deliver quickly is essential as I require this project to be completed ASAP. Please provide proof of your skills in your proposal so I can make an informed decision. I greatly appreciate your interest and loo...

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I'm looking for an expert in Excel data handling and financial analysis with special attention to franchising businesses. The end-goal is to develop a user-friendly, dynamic Excel document for cross-comparison of various franchisor fees, charges, and costs. Key Tasks: 1. Data Entry: Populate the document with the provided profit and loss data. 2. Categorization: Organize costs by frequency of occurrence (monthly, yearly, etc.). 3. Analysis Tools: Implement features to run various cost analysis scenarios with a focus on comparing costs between different franchisors. A back ground document that I can change that clearly show in $ cost the difference and in visual Competitive analysis comparison document Ideal freelancers should have an understanding...

I am in need of a skilled professional who can add new features to my Laravel We...features to my Laravel Web App (). Budget: $120 1. Ensure all features are working in the script and then add FlutterWave API (Deposit in any currency, Naira deposit via issuing virtual bank accounts and API and also BVN verification for Nigerians only, Currencies conversion, Withdrawal through Admin approval, Virtual dollar/naira cards). Email notifications for all transactions. 2. (Airtime, data, giftcards, utility API). This will include adding more screens for all new features. Email notifications for all transactions. 3. Security: Database security and Add multi-level 2FA security in Admin and User, transaction PIN for users. 4. Add the crypto add-on script I'll buy later

I have an existing PHP script that handles text translation, and I need an exact replica of it in Google App Script. Ideal Skills and Experience: - Proficiency in both PHP and Google App Script - Experience with text translation APIs or libraries - Understanding of database operations in Google App Script Key Points: - The current PHP script specifically handles text translation from Gujarati to Hindi and Gujarati to Latin. You'll need to ensure that the same functionality is replicated in Google App Script. - The project is time sensitive, so I need it completed ASAP.

I'm in need of a highly proficient Excel specialist who will perform a series of tasks for me. Specifically, these include: - Data Analysis: Probing and evaluating a medium-size dataset (between 100-1000 rows) to derive meaningful insights. - Spreadsheet Formatting: Improving aesthetic appeal and readability of my spreadsheets. - Formula Creation: Establishing useful formulas to automate computations and functions. The entire project needs to be undertaken in Excel 2016 or later, therefore familiarity with this version is essential. Experience in data analysis and spreadsheet management is also expected. If you're an Excel whiz, I'd be eager to hear from you.

I'm on the lookout for a talented Python developer who can create a custom web scraping script. The primary aim of this script will be to extract product details from a particular e-commerce site. Key Responsibilities: - Develop a Python script that accesses the e-commerce site and collects product details as specified. - Ensure the script is efficient, accurate and can handle a large volume of data. Skills & Qualifications: - Proficiency in Python and experience in web scraping are crucial for this task. - Prior experience with e-commerce website scraping is a plus. - Ability to extract and organize data in a structured format. - Strong problem-solving and communication skills are highly valued. If you have the skillset to take o...

I have code for login trading accound and fetch token data. I need to update code I need to collect live data from the web and candle stick, I have attached the document for data collection from web. Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Please view the attach file. I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system the...

I need a freelancer to assist me with a small financial calculations task in Excel. - The work is focused on financial calculations, so experience in this area would be highly beneficial. - The task isn't extensive, but I need someone who is detail-oriented and can ensure accuracy in the calculations. - I'm open to seeing examples of your past work, particularly if you've done similar tasks. Please apply with your relevant experience and a brief explanation on how you would approach this task. Need it by today

I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.

I am looking for an efficient developer to integrate Rise script in our existing project management system. It is not specified which features need to integrate, however, proficiency in task management, team collaboration, and document sharing would be beneficial. You should be equipped to provide professional advice on the best methods of integration. Ideal skills and experience: - Proven work history with Rise script. - Extensive experience in system integration. - Proficiency in project management software. Applicants should be prepared to discuss their proposed methods for integrating the Rise script. The aim is to achieve an efficient and successful integration, whether that may be a seamless transition, independent systems, or customized integration. Your appli...

I want to make a browser-based epub/pdf/text viewer that supports annotations For the first step, I need a dev to make a nodejs script that can convert epubs, pdfs, and txt files to static html files. I want 1 file for each chapter. The script should produce a that links to all chapter files. If a file has no chapters, break the book into 4000 words chapters Also it should produce a table of contents .json file. The file lists all the chapter files. Link to a similar project in your bid if you have it. Thanks for bidding

I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.

I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.

...candidate will research and identify relevant grant opportunities, craft compelling proposals, and work closely with our team to position our business for grant success. Responsibilities: * Research and identify grant opportunities aligned with our business plan and funding needs * Write clear, persuasive grant proposals and applications * Collaborate with our team to gather necessary information and data to support grant submissions * Manage grant submission process, including meeting all required deadlines * Communicate progress updates to management and incorporate feedback * Assist with post-award reporting and compliance as needed Requirements: * Proven track record of securing grants, preferably for startups or businesses in the jewelry or creative industries * Exceptiona...

I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.

...blank in Power Apps Studio. On the app’s OnStart property, initialize context variables that will control the visibility of the camera and determine which section is active. PowerApps Copy code UpdateContext({showCamera: false, currentSection: ""}) Step 2: Set Up User Interface Components Add text input controls for "First and Last Name". Label each text input appropriately. Step 3: Insert Camera Control Insert a Camera Control and set its Visible property to the showCamera variable. PowerApps Copy code Visible = showCamera Step 4: Implement Upload Buttons for Each Document Section You'll need separate buttons for each section: Notice of Assessment Upload Button PowerApps Copy code OnSelect = UpdateContext({showCamera: true, currentSection: ...

I'm in need of an expert in Excel, Access or similarly powerful programs to handle a large spreadsheet task. Although the specific tasks that need to be handled were not decided upon, proficient data organization skills are essential as we may need to restructure large data sets. The ideal freelancer for this job should: - Have expert skills and proficiency in Excel and Access. Knowledge of other data organization tools will be considered a plus. - Showcase notable experience, specifically in dealing with large data sets and complex spreadsheets. - Since the specific tasks to perform were not mentioned, a flexible approach and ability to adapt with regard to potential data analysis and data entry tasks will be greatly ap...

...must have: - Text fields for basic information collection - Dropdown menus for selection options - Capture creation The form should be designed with user-friendly, visually appealing elements. Your role will also include: - Implementing validation requirements for all input fields. This will ensure that the user completes all the required fields in the correct format. - Integrating an email script that will automatically send a reply to the submitter. This is an essential feature for my project. Ideal Skills and Experience: - Proficiency in HTML and CSS for form design - Experience in creating and implementing form validation - Knowledge of backend scripting languages for email automation - Understanding of user experience best practices - Experience with automatic email re...

...tasks: • Data research: You will need to research and find the best prospects for my business based on their profile, industry, location, and other criteria. You will need to use sales navigator and other tools to conduct effective data research. • Profile research: You will need to analyze and evaluate the profiles of the prospects you find and determine their level of interest, need, and fit for my business. You will need to use sales navigator and other tools to conduct thorough profile research. • Data filtering: You will need to filter and sort the data you collect based on the most relevant and important criteria. You will need to use sales navigator and other tools to perform accurate data filtering. • Data col...

Just looking for someone who can be paid a low amount and read the script in a good English accent. Will get paid every 2 weeks. Very easy job. As easy as it sounds just read the text out loud and have it recorded! That is it!

This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.

Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancemen...