Excel macro add prefix punët

...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 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 would love to hear from you.

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.

Request for Assistance in Creating Interactive Filtered Tables 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 b...

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 ...

Lizenzverwaltung & Song-Datenbank ✅ Übersicht aller Songs mit relevanten Daten (Titel, Künstler, Veröffentlichungsdatum, Label) ✅ Hinterlegung der Lizenzbeteiligung ✅ Erfassung von Umsätzen für jeweilige Abrechnungs...Berechnung ✅ Berechnung deiner Lizenzanteile basierend auf den Umsätzen ✅ Berücksichtigung unterschiedlicher Beteiligungen pro Song 3. Einnahmen-Tracking & Berichte ✅ Darstellung deiner Einnahmen über verschiedene Zeiträume ✅ Filter- & Suchfunktionen für schnelle Auswertungen ✅ Grafische Darstellung der Umsätze & Trends 4. Export & Rechnungsstellung ✅ Export der Abrechnungen als CSV, PDF oder Excel ✅ Erstellung von Lizenzabrechnungs-Anforderung an Künstler/Labels 5. Benutzerfreundl...

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

...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

Necesitamos realizar un programa en Excel con macros en la cual se permita cargar datos de productos, datos de clientes y luego genere una cotización. Debe incluir: 1. Base de Datos de Máquinas o Código del producto o Descripción breve o Precio de lista o Precio de contado o Precio con pagos en 0-30, 0-30-60, y 0-30-60-90 días 2. Formulario de Cotización o Ingreso de datos del cliente (Nombre, Apellido, Teléfonos, Localidad, Provincia, Email, Fecha, Evento) o Selección de una o varias máquinas de un listado desplegable o Generación automática de la cotización en PDF (se debe imprimir en una hoja tamaño A4 que en el encabezado aparezcan todos los datos de la empresa con el logo, luego los datos cargados del cliente, numero de cotización, y después los productos cotiza...

I am looking for a freelancer who can provide me with an email list of AirBnB, VRBO (Vacation Rentals by Owner), and other short term vacation rental hosts in North Carolina, South Carolina, Alabama, and Georgia. in the form of an Excel spreadsheet. All hosts are acceptable and there are no specific criteria for inclusion in the list. The ideal candidate should have experience in data mining and compiling email lists. Attention to detail is crucial to ensure that the list is accurate and up-to-date. The list should contain the following: Name, phone number, and email address, and should all be valid and up to date information. We will need around 1000 leads to start.

I'm seeking a...Profit margin in one location, and we also have to be about to seperate all material and labor $ so we can add sales tax to Material, and or to Labor and show that on the proposal. (many of our jobs are Sales tax exempt on Material and Labor is usually not taxed.. but sometimes is. Key Requirements: - Expertise in cost estimation for materials and labor. - Proficiency in spreadsheet software, particularly Excel. - Ability to present a detailed breakdown of costs clearly and concisely. Your experience in creating or modifying estimating spreadsheets will be crucial for this project. We currently have a spreadsheet but think it could be modified so it it is easier to update material costs, add materials and create "kits" We will provide...

I'm seeking a proficient Excel developer to create a quotations maker for me. The quotations should be generated in an Excel format. Key requirements: - The quotations maker needs to have a customer database integration. - The customer database will require manual entry. Ideal skills and experience for the job: - Extensive knowledge and experience in Excel. - Previous experience in developing similar quotation makers. - Understanding of customer database integration in Excel.

I'm seeking assistance with a data entry task involving daily stock prices. Key Responsibilities: - Copy stock prices from the NSE website and Investing.com. - Paste the information accurately into an Excel file. Ideal Skills: - Proficient in Excel. - Detail-oriented to ensure data accuracy. - Familiarity with stock market terminology is a plus. Experience: - Previous data entry experience, particularly with financial data, will be highly regarded.

We are a local plastering and drylining company in Cannock, Staffs WS11 7LG, currently in need of a qualified freelance Quantity Surveyor (QS). The ideal c...of a qualified freelance Quantity Surveyor (QS). The ideal candidate will be responsible for conducting take-offs for both dry lining and plastering. Key Responsibilities: - Regularly attending our office once or twice a week (local to Cannock is a must) - Conducting accurate take-offs for both dry lining and plastering - Delivering take-offs in digital format (Excel files) Skills and Experience: - Proficient in Excel - Prior experience as a QS in the plastering and drylining industry - Able to conduct both dry lining and plastering take-offs - Local to Cannock and able to attend our office regularly Ma...

I'm seeking a proficient Excel developer to create a quotations maker for me. The quotations should be generated in an Excel format. Key requirements: - The quotations maker needs to have a customer database integration. - The customer database will require manual entry. Ideal skills and experience for the job: - Extensive knowledge and experience in Excel. - Previous experience in developing similar quotation makers. - Understanding of customer database integration in Excel.

...have been awarding projects for 10+ years. The chosen freelancer will receive positive feedback score and prompt payment. ----------------- About the task ----------------------- Build an AI-enabled application which 1. Recognizes the correct column header and places the correct data in the correct column a. Excel b. Text c. Word document d. PDF 2. Recognizes hand-writing upload from 1. Image files (JPG, GIF or PNG) 2. PDF files 3. Compiles the data into a correct Excel sheet (for students, parent and teacher) 4. Uploads the data into our web application called Kontakkt Please read the attached project file carefully, which explains the output tasks We will provide the winning bidder with a live user account to login to Kontakkt, with data already inside there ...

I'm looking for an expert in Excel and VBA to help me create a custom workbook. The primary purpose of this workbook is to manage and collate employee time entries. Key Requirements: - Design a workbook tailored for tracking employee time. - Implement VBA code to hide and unhide specific worksheets based on user access. - The VBA code should allow each user to only access the worksheets I define. Ideal Skills: - Proficiency in Excel and VBA. - Experience in designing custom workbooks. - Knowledge in user-specific worksheet management through VBA.

I need a skilled app developer to create a robust Android-only application for handling Excel formulas and performing calculations on financial data. Key Features: - The app should generate insightful reports and visualizations from financial data. - Ability to create and edit Excel formulas. - Perform complex calculations with ease. Ideal Candidate: - Proficient in Android app development. - Experienced with financial data processing. - Skills in creating data visualization tools. - Familiarity with Excel and its formulas.

I need an expert in either VBA or Python who can help me search, validate, and compare alphanumeric data in multiple cells in Excel. The results should be shared in another cell indicating whether the data is 'Matched' or 'Not Matched'. Key Requirements: - Proficient in either VBA or Python - Expertise in Excel data manipulation - Ability to implement custom logic for data validation and comparison - Capable of creating clear output in Excel Data Validation: - The data will need to be checked for specific patterns. - The patterns are not standard and will require custom logic to identify. Ideal Skills: - Strong experience with Excel's VBA or Python integration - Excellent problem-solving skills for creating custom data validation logic - At...

Export data into CSV file (macro)