Vba add ins excel jobs

I need a professional to generate customer invoices in bulk based on a Word template and data in a single Excel sheet. The generated invoices should be in PDF format. Key Requirements: - Proficiency in Microsoft Word and Excel, specifically Office 365 - Experience in bulk invoice generation - Ability to follow a Word template precisely - Skills in converting Word documents to PDF The data is organized in a single sheet with all the necessary information. The ideal freelancer for this project should be detail-oriented to ensure each invoice is correctly generated without errors.

...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...

I'm in need of a Power BI expert to develop a user-friendly, visually appealing, and insightful interactive dashboard for my healthcare business. The dashboard will need to facilitate data exploration through basic filtering and sortin...exploration through basic filtering and sorting. Key Dashboard Components: - Revenue Analysis: Monthly & Yearly Trends - Sales Performance: By Product, Region, and Team - Customer Insights: Demographics & Purchase Patterns Skills Required: - Proficiency in Power BI - Expertise in Data Visualization - Strong knowledge of DAX & SQL - Business Intelligence experience The data source will be provided as Excel spreadsheets. The ideal candidate will be able to translate complex data sets into understandable visualizations, aiding in st...

I'm looking for an experienced data engineer to extract specific information from the ASIC website and create a comprehensive Excel database. Data to be extracted includes: - Type of appointment - Date of appointment - State - Company name - Administration company - Administrator - Contact person - Email address The ideal freelancer for this project should have: - Proficiency in web scraping - Experience with data extraction from ASIC - Excellent skills in Excel and database creation - Attention to detail to ensure all relevant data is captured - Ability to deliver the project within the stipulated time frame.

I'm searching for an experienced Django ...Django developer to create a straightforward Python application. The app should scrape mixed data from databases, store it in an SQL database (preferably PostgreSQL or MySQL), and expose it as a REST API with token-based authentication. Key Responsibilities: - Develop a Python application using Django - Scrape mixed data from a website - scrapping scripts available , which are now writing to excel - Store the data in an SQL database - Expose the data as a REST API - Implement token-based authentication for the API Ideal Skills and Experience: - Proficient in Python and Django - Experience with data scraping - Familiarity with SQL databases (PostgreSQL, MySQL) - Knowledge of REST API development - Understanding of token-based authent...

I need an Excel expert to help me create a well-structured employee list compatible with Mac and Microsoft. The list should be able to filter by continent and alphabetically. Details I need for each employee include: - Name - Address - Continent - Country - Email - Telephone - Brand - Start Date - And more The template I purchased requires some modifications, including color adjustments to light shades. I'm open to other employee lists that are comprehensive and useful. Ideal Skills and Experience: - Proficiency in Excel - Experience with data structuring and filtering - Ability to modify Excel templates - Attention to detail - Understanding of light color schemes Please ensure the final Excel list is neat, error-free and ready for immediate use.

I have a list of procurement managers and need assistance in gathering their email addresses and telephone numbers. Eg procurement manager, name email , tel Requirements: - Data Entry: You will need to fill in an Excel spreadsheet with the name, email, and telephone number for each procurement manager, along with two additional columns (to be discussed). - Data Collection: The ability to source accurate email addresses and telephone numbers is essential. Ideal Skills: - Proficient in Excel - Experience in data collection and entry - Attention to detail - Good research skills Project Scope: - Processing a list of approximately 100-500 entries. Please quote for your services.

Please Sign Up or Login to see details.

I'm seeking an Excel expert to design a comprehensive retirement planning spreadsheet. The sheet should assess: - Savings growth - Investment returns - Expenses tracking It should also provide monthly budget recommendations. The sheet must incorporate various investment types, specifically: - Stocks and bonds - Mutual funds Skills in financial forecasting and Excel automation are crucial. Please include in your bid examples of similar projects you've completed. Kindly provide any prior experience proof for hiring you

...application for data entry and management. This application will primarily use Excel as the database. Key Features: - Data Entry: Using a form with some drop down lists and radio buttons. The application should also have the ability to upload several PDFs (all PDFs are stored together in the cloud). - Data Search: Using a form to search on various parameters like name, supplier, etc. There should also be an option to download the PDFs. - General Management: The application should allow adding and deleting PDFs, and altering the data entered (like updating a phone number). Ideal Candidate: - Proficiency in Desktop Applications development. - Experience with data entry and management systems. - Familiarity with Excel as a database. - Ability to incorporate cloud-based PDF ...

Please Sign Up or Login to see details.

I'm seeking an expert in UiPath to set up automation for my work. The specific tasks I need automated include data entry, report generation, and email processing. Requirements: - Create new workflows from scratch in UiPath - Interact with various data sources, including databases, Excel files, and web applications Ideal Skills: - Extensive experience with UiPath - Proficient in workflow creation - Familiar with data handling across various platforms Please bid if you have the necessary skills and experience.

...for an Excel expert who can program a comprehensive Excel sheet for managing the purchase and sales orders of TMT Rebars, with features supporting both Sales Order Processing and Purchase Order Processing. Key Features: - Sales Order Processing: The sheet should be able to handle the entire sales order process, tracking orders from initiation to completion. - Purchase Order Processing: Similarly, the sheet should manage the purchase order process, keeping track of purchases made for TMT Rebars. Data Analysis and Reporting: - Sales Reports: The sheet should generate detailed sales reports, providing insights into sales trends and performance. - Purchase Reports: It should also create purchase reports to keep track of the procurement process and expenses. Multi-user Acce...

I need someone to reproduce safety documents into an Excel Spreadsheet or Word. The reproduced documents should incorporate safety protocols and procedures. Ideal Skills: - Proficiency in Excel - Attention to detail - Understanding of safety protocols and procedures Please note, it is important that the reproduced documents are accurate and comprehensive in their representation of the original safety documents. I have attached only 3 pages of pics of the doc I require to be reproduced, in total the doc is 8-10 pages.

I have a project that involves cleaning mixed data in Excel. Key Tasks: - Remove duplicates - Handle missing values - Standardize formats Ideal Skills: - Proficient in Excel - Experienced in data cleaning - Attention to detail and ability to follow specific instructions

I require an expert in Excel to design a formula that will automate some of my daily tasks. The main tasks to be automated include: - Data Entry: This involves inputting various data points into the spreadsheet - Generating Reports: This will be based on the data compiled in the spreadsheet. Ideal Skills and Experience: - Proficient in Excel with advanced formula knowledge - Experience in automating Excel tasks - Ability to create automated report generation The tasks need to be automated for daily execution.

...extract from PDFs (OCR if needed, e.g., Tesseract). * Investment Research: Parse ~2000 PDFs using PyMuPDF, PDFPlumber, or equivalent. * X Posts: Scrape relevant posts via X API or third-party tools. * Websites: Extract data with BeautifulSoup or Selenium. * Internal Memos: Fetch from Notion API. * Transcripts: Summarize with LLM (e.g., OpenAI, Claude, or Gemini). * Valuation Data: Process Excel files with Pandas and integrate Bloomberg/FactSet API calls. 2. Data Processing & Storage * Transform and store data for fast, accurate retrieval: * AI/NLP: Summarize content and tag entities (e.g., companies, metrics) using LLM and NER. Storage: * Structured data in PostgreSQL or MySQL. * Unstructured data (e.g., transcripts) as vector embeddings in Pinecone or E...

I'm looking for an expert in Excel or Google Sheets who can help me set up a monthly housekeeping inventory or stocktake. The format needs to be straightforward and user-friendly, making it easy to monitor. Key requirements: - Track item names and quantities. - Create a simple, easy-to-use inventory spreadsheet in Google Sheets. - Update the inventory on a monthly basis. Ideal skills for this project include: - Proficiency in Excel or Google Sheets. - Experience in inventory management. - Ability to create user-friendly spreadsheets.

I'm in need of a talented developer to create a stock tracking program for me. This program should be...talented developer to create a stock tracking program for me. This program should be able to analyze historical data, specifically focusing on trend analysis, performance comparison, and data visualization. Key Requirements: - The program must be a desktop executable version. - Integration with financial APIs for real-time stock data. - Utilization of Excel (VBA) and Python for seamless functionality. Ideal Skills: - Proficiency in VBA and Python. - Experience with developing user-friendly applications. - Strong attention to detail and problem-solving skills. If you have a passion for programming and can deliver a robust, intuitive stock tracking program, I...

I'm looking for a talented developer to improve my existing stock tracking program and create a Windows-compatible desktop executable. The program should be developed using Excel (VBA) and Python, ensuring smooth integration and functionality. Key Improvements: - Enhancing the user interface to make it more intuitive and user-friendly - Improving data processing speed for efficient stock tracking - Developing a desktop executable version of the program Ideal Skills: - Proficiency in both VBA and Python - Experience in developing desktop applications - Strong attention to detail and problem-solving skills - Passion for programming and creating user-friendly applications If you can provide these enhancements and have the required skills, I look forward to hearing...

I need someone to reproduce safety documents into an Excel Spreadsheet or Word. The reproduced documents should incorporate safety protocols and procedures. Ideal Skills: - Proficiency in Excel - Attention to detail - Understanding of safety protocols and procedures Please note, it is important that the reproduced documents are accurate and comprehensive in their representation of the original safety documents. I have attached only 3 pages of pics of the doc I require to be reproduced, in total the doc is 8-10 pages.

I'm seeking assistance to help upload data onto my website. The task involves researching and finding every run club in m...all required information: run club name, description, city, suburb/neighborhood, exact meeting point, run type, time and day of the week, website and Instagram. - Save the list of found run clubs into an Excel spreadsheet, with each piece of information in a separate column. - Provide a brief overview of each run club in the submission. - Ensure high accuracy in all fields. Ideal Skills and Experience: - Proficiency in data entry and research. - Familiarity with run clubs or running culture is a plus. - Excellent attention to detail for ensuring information accuracy. - Experience with Excel and submission forms. - Ability to leverage AI tools respo...

...coordination. - Business & Research Support: Conduct research, prepare reports, and analyze business or industry trends. - Data & Excel Work: Organize and manipulate data in Excel, including formulas, pivot tables, and reports. - E-commerce & Online Presence: Assist with e-commerce tasks (eBay, Shopify, etc.), product descriptions, and online store management. - Basic Graphic Design & Content Editing: Work with tools like Photoshop or Canva to create and edit visuals. - CRM & Analytics: Manage CRM tools, track performance data, and generate insights for decision-making. Requirements: - Proven experience in personal assistance, marketing, or business support. - Strong skills in Excel, Google Sheets, data analysis, and reporting. - Knowledge of d...

Detailed Explanation of the App Idea for the Developer 1. Overview: An entertainment mobile application for Android and iOS that allows users to engage in live-streamed game challenges, such as chess, card games, and dominoes. Users can place monetary bets, and winnings are distributed...Technologies: Development Language & Framework: Flutter (for iOS & Android support). Game Engine: Flame Engine (for 2D game development). Live Streaming: Integration with WebRTC or other streaming services (OBS/WebSockets). Transaction Management: Integration with electronic payment systems like Visa, Mastercard, Stripe, or PayPal. Database Management: AWS Amazon database server. An Excel file is attached with detailed requirements. If you have any questions, feel f...

For a shared Excel file on Sharepoint, need two scripts (or a way to do the following): 1. On opening the Excel file, hide any row in which all dates in the row are more than 7 days from the current date. 2. On opening the file, any cell that has a date with text in bold and the date is today or before, will have the cell background turn white and the cell text turn red.

I am looking for draftsman to complete some house plans with CAD and dimensions for the attached excel sheet. Please get in contact of you have any queries Regards

I need an experienced Excel professional to create a 5-tab spreadsheet based on a study I have. (Toddler Parameters, Toddler Budget, Infant Parameters, Infant Budget, Total Budget tabs) - The first two tabs will be for data input and analysis results, respectively. Information for the parameters are found on the study, (Total staff, salary, total students, overtime, ) parameters should include all costs and revenues. - Text descriptions will be the primary parameters to be plugged into the spreadsheet. - The spreadsheet should feature automated calculations and data validation to ensure accuracy and ease of use. Categorys in the toddler and infant budget tabs should be label by months (Jan - Dec) screenshot of examples of what it should look like are also below. Need to have ex...

I need help modifying an Excel spreadsheet to ensure names and addresses are formatted correctly for UPS shipping software. This project mainly involves changes to the layout and overall formatting of the spreadsheet. See attached files from Unishippers as to format needed and spreadsheet that needs to be changed

I need a comprehensive report based on two tasks: 1. A detailed analysis of Qlik's e-book "Turn your Excel Reports into Stunning Dashboards." This should include what you learned and insights on data visualization, dashboard design, and excel integration. 2. An exploration of a business application from the Microstrategy website. You'll need to choose an industry, select a business application, and write a report on the insights gained from the associated video. The final report should be 4-5 pages long, formatted in APA style, and include at least three references. Ideal candidates will have strong skills in data analysis, report writing, and familiarity with APA formatting. Experience with Qlik and Microstrategy is a plus.

...Using VBA in Excel I am reaching out to seek your expertise in creating an interactive Excel model that includes dropdown boxes and filtered tables using VBA. The goal is to replicate a system where selecting an item from a dropdown box (e.g., a country) automatically filters a table to display relevant data. Key Requirements: Dropdown Boxes (Combo Boxes): Create dropdown boxes that allow users to select specific criteria (e.g., cities, statuses). The dropdown should be populated with a predefined list of items. Interactive Filtering: Upon selecting an item from the dropdown, the corresponding table should automatically filter to display only the rows that match the selected criteria. The filtering should be dynamic and update instantly when a differen...

I need someone to create a quick stock summary sheet. I will provide an Excel file with the 2024 sales data, along with an example format. Your task is to locate the corresponding buy data from the 2020-2022 period using the transaction records I provide and complete the final 2024 Excel sheet based on the given format. Do not use AI please. I will send the buy data ,once you are selected

I am in need of an expert in operations research and mathematical modeling who can develop a multi-objective, multi-period location-routing model, based on several critical assumptions like heterogeneous vehicle and differents types of products. Ideal Ski...Proficiency in developing complex models for multi-objective optimization. - Strong understanding of both location and routing optimization. - Proficiency in GAMS programming. For this task, I expect the following deliverables: 1. Review the proposed model and adjust the formulation as needed to ensure valid results. 2. Refine the mathematical model in GAMS and validate it using test instances in Excel. 3. Implement the multi-objective weighting method to solve the problem and assess the relative importance of the objective ...

I'm looking for a skilled Excel expert to create a comprehensive tracking sheet for my daily store visits. The sheet should have a tab for each day, and a master tab that compiles all customer information and interaction feedback. Requirements: - Track customer interactions during each store visit. - Record specific details about each customer interaction, primarily comments and feedback. - Categorize feedback into follow-up items. Ideal Skills: - Proficiency in Excel. - Experience with data tracking and analysis. - Ability to create user-friendly and organized spreadsheets.

I'm looking for an Excel expert who can create an intuitive spreadsheet for tracking job preparation based on asset availability. Key features: - The spreadsheet should track various statuses such as: - Not Started - In Progress - Completed - Asset not available - Mobilized - Ready for mobilization - Color-coded cells indicating the status of job preparation and mobilization. Ideal skills: - Proficiency in Excel - Experience with project tracking tools - Good understanding of color-coding for status tracking With this tool, I'll be able to easily monitor the progress and prepare accordingly.

...Create additional tables in DB as needed to accomplish tasks 3. Each record will have several actions that can be done to each i. update status ii. Attach documents iii. view details iv. update 4. System will also have ability to run reports that will export into excel as needed. 5. We will have several other functions i. manage users ii. manage techs iii. equiptment management functions Must be a clean and professional front end. Phase 1. is Proof of concept and needs to be done very quickly. NOT fully functional but have the framework up and some ba...

...✅ Amazon & Meesho Listings: Add and update inventory on Amazon, Meesho, and other e-commerce platforms to ensure stock accuracy. ✅ Stock Entry & Updates: Regularly update stock counts in spreadsheets or inventory management software. ✅ Order Coordination: Assist in managing incoming and outgoing stock to ensure smooth order fulfillment. ✅ Quality Check: Verify that received goods meet quality standards and report discrepancies. ✅ Restocking & Alerts: Notify the team about low-stock items and help in restocking plans. ✅ Basic Reporting: Generate simple stock reports to support decision-making. Requirements: -> Education: Any graduate or undergraduate (preferably in commerce, business, or supply chain-related fields, but not mandatory). -> Skills: Basic MS Exc...

As agreed!?

I have some work, in an Excel spreadsheet.

I'm seeking an Excel Online expert to help me set up individual spreadsheets for each of my collaborators, linked to a global billing spreadsheet. Key Requirements: - Create separate, individual Microsoft Excel Online spreadsheets for each collaborator. - Each spreadsheet should have 'Edit permissions' for the respective collaborator, allowing them to input their own data. - The data from the global billing spreadsheet should be reflected in the individual sheets automatically and in real-time, without the collaborator having access to the global spreadsheet. Ideal Skills: - Proficiency in Microsoft Excel Online. - Experience with setting up complex spreadsheet systems. - Knowledge in automating data updates across spreadsheets. - Excel sheets ...

Data gathered to an Excel file. Data gather to excel file

I'm in need of an Excel sheet specifically designed for calculating construction costs. The sheet should encompass: - Material Costs - Labor Costs - Total Project Cost In addition, I'd like the sheet to incorporate specific Excel functions and formulas such as: - Sum and Averages - Conditional Formatting Ideal candidates for this project should have a strong background in Excel, particularly with creating complex sheets for cost analysis. Experience in the construction industry would be a plus. Please bid with a brief overview of your relevant experience and examples of similar projects you've completed.

I'm a university student seeking a mentor to help me navigate my data module. The focus is primarily on using Excel functions to sort numerical data. Key Responsibilities: - Interpret and explain the tutorials provided - Help me understand and apply Excel functions to sort numerical data - Provide guidance on data analysis techniques Ideal Skills: - Proficient in Excel - Strong understanding of data analysis - Previous experience tutoring or mentoring university students Looking forward to your bids.

...manual data entry. Usability & Documentation: The model should be user-friendly, with clear documentation explaining the assumptions, methodology, and structure used. Expertise Required: Subject Matter Expertise: A solid understanding of the cattle export industry, supply chain management, logistics, and market dynamics. Financial Modeling Skills: Expertise in building detailed financial models in Excel or other modeling software. The ability to manipulate existing models, apply new metrics, and forecast financial outcomes accurately. Financial Analysis & Ratios: Strong ability to calculate and interpret financial ratios, assess the financial health of businesses, and conduct thorough financial analysis. Experience with Scenario Analysis & Sensitivity Testing: Abilit...

Hello! I have a website of a hotel establishment, which uses the vikbooking plugin for the search and booking engine of the rooms. I need to develop a payment add-on as indicated in the following documentation In this way, I will be able to receive the payments with the virtual POS of my bank.

I'm in need of a skilled software engineer who can help me fix my JSON parser (implemented in Excel/VBA). The parser is encountering crashes and unexpected behavior when dealing with a new format of JSON. Key Requirements: - Diagnose and fix bugs in the JSON parser - Ensure the parser can handle the new JSON format Ideal Skills: - Proficient in debugging software - Experienced with JSON data and parsers - Familiar with the specific issues of crashes or unexpected behavior

I'm looking for an experienced Excel macro developer to create a macro that will import data from a specific TXT file on my computer and format it to match my PDF example. I currently pull the data from an IBM and it is saved on my windows computer as "AP Data." I then need to be able to open an excel workbook and run a macro that will import "AP Data" and format it so it matches the PDF example identically. All numbers in the excel worksheet after import need to be formatted as accounting so something that appears on the PDF Example as 7.50- will change to (7.50). The print area needs to match the PDF example. There are page numbers at the top right of each page and that needs to be how it prints in excel. Below is th...

I'm looking for a professional with expertise in Bartender Software. I need to create barcodes pulling from specific fields in a Master data spreadsheet. The spreadsheet is located in Egnyte and is co-edited using Microsoft Excel Online. The fields I am interested in include GTIN, Catalog Number, Lot Number, Serial Number, Expiration Date, and Quantity. This data needs to be pulled from filtered data based on a blank Allocation column (see attached spreadsheet) Ideal skills and experience for the job: - Proficiency with Bartender Software. - Experience in barcode generation and software integration. - Attention to detail to ensure accurate data pull for barcode creation. Please reach out if you have the necessary skills and experience.

Core Features & Modules 1. User Roles & Access Control • Admin (Owner): Full control over system functions. • Staff (Employees): Can add expenses, view their reimbursements, and check vehicle file status. 2. Vehicle File Management • Ability to create a new file for each vehicle clearance using: o Chassis Number / File Number (Unique Identifier) o Client Name o Vehicle Details o Status: Pending, In Progress, Cleared o Total Expenses Incurred • Staff members can only add expenses if the file is active. • Admin has access to re-open a file in case a staff member forgot to add an expense. 3. Expense Tracking & Reimbursement • Staff members can log daily expenses for each file by selecting: o Chassis/File Number o Expense Type (C...

I'm seeking for a professional who can help me extract contact information from customer accounts on the website www.food-service.de. Key Requirements: - Extracting contact information from customer accounts on the website - Delivering the extracted data in an Excel spreadsheet Ideal Skills and Experience: - Proficient in data extraction and web scraping - Excellent attention to detail to ensure all relevant contact information is extracted - Experience with delivering data in Excel format Please provide a concise proposal detailing your experience and approach to this project. Show me scraping first 50 details like name,mail,contact number with your term project.

I am in need of a skilled female Indian professional with expertise in Tally and Excel to assist with data entry and recording. The primary focus will be on tracking expense and income. Key Responsibilities: - Accurate data entry of expenses and income into Tally and Excel - General assistance and guidance in categorizing data Ideal Candidate: - Proficient in Tally and Excel - Excellent attention to detail - Able to provide guidance in data categorization - Female Indian professional