Convert excel macro perl仕事

I cant figure out the correct formula for this hence asking our incredible freelance community online. I have a spreadsheet with two pages. -To-do page -Done Page The To-do page contains a table with data The Done page has that same table with no Data (it has the same headings) I want to be able to move a row of data from table in the To-do page to the table in the Done page. After I've moved that row of data, the row should be completely deleted from the To-do page. Also would like a Total counter on the To-do page that increments by 1 every time a row is moved. Attached is a test sheet containing small sample size of data. If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action. Dat...

I'm looking for a skilled professional to create a detailed 3D exploded view of a lighting product from a provided 2D PDF drawing. The final product should include all components and textures. Key Requirements: - Expertise in 3D modeling and CAD software - Ability to convert 2D drawings into 3D models - Experience in creating detailed technical visuals - Understanding of designing for technical documentation The primary purpose of this project is to generate a 3D view suitable for technical documentation. The model needs to be high-detail, incorporating all components and textures.

As a class 11 commerce student, I'm seeking a dedicated tutor specializing in Accountancy, specifically Financial Accounting. Key Requirements: - Expertise in teaching Financial Accounting - Previous experience with 11th grade curriculum - Patience and ability to explain concepts clearly - Flexi...I'm seeking a dedicated tutor specializing in Accountancy, specifically Financial Accounting. Key Requirements: - Expertise in teaching Financial Accounting - Previous experience with 11th grade curriculum - Patience and ability to explain concepts clearly - Flexible schedule for tutoring sessions Your role will primarily involve conducting tutoring sessions aimed at helping me understand and excel in Financial Accounting. Please provide your tutoring approach and availabili...

I'm seeking a mentor who can teach me how to digitize files into the .dst extension. I need to learn how to create new design files and transform a jpg into a .dst. Key Requirements: - Teach me how to use the software, as I have yet to decide on the best one for my needs - Guide me in creating new design files - Show me how to convert jpg files into .dst -Familiar with software similar to Embird, Wilcom, or Hatch Embroidery - Patience and ability to explain complex processes in a simple, understandable way - History of working with personal projects, as this is my primary goal

I'm looking for a freelancer who can assist in gathering the details of company directors from a list of data centres. The project involves finding information for 100 plus data centres. Key Requirements: - Full Name, Title, Email Address, and Phone Number of the directors are required. - Experience wit...and research is crucial. - Prior experience in sourcing business contacts is a plus. - Directors' LinkedIn Profiles are required for validation. - Please include the directors’ specific company roles in your search. Your bid should reflect your ability to provide this information accurately and efficiently. Looking forward to your proposals. The gathered information should be organized in an Excel spreadsheet format. Please include the directors’ specific c...

I cant figure out the correct formula for this hence asking our incredible freelance community online. I have a spreadsheet with two pages. -To-do page -Done Page The To-do page contains a table with data The Done page has that same table with no Data (it has the same headings) I want to be able to move a row of data from table in the To-do page to the table in the Done page. After I've moved that row of data, the row should be completely deleted from the To-do page. Also would like a Total counter on the To-do page that increments by 1 every time a row is moved. Attached is a test sheet containing small sample size of data. If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action. Dat...

I'm in need of an Excel worksheet It is already in a wook book split into 3 parts with a total of 32 questions. The questions are designed for a beginner level course, so they're not overly complex. Key Requirements: you are a financial analyst at a large corporation responsible for managing and analyzing the company's product reports and financial data. Your goal is to set up a dashboard to display the needed information. Ideal Skills: - Proficiency in Excel - Experience in creating educational materials - Competence in trend analysis - Ability to work with financial data Heres the Project: You are a financial analyst at a large corporation responsible for managing and analyzing the company's product reports and financial data. The company deals w...

I need a proficient Excel developer to create an interactive dashboard that will help visualize work accomplished from different Excel sheets. Each sheet has slightly different data points but shares common elements like quantities completed on specific days and the number of additions per day. The dashboard should also incorporate some aging aspects of the efforts on each sheet. Key Requirements: - Proficient in Excel with experience creating dashboards - Skills in data visualization using line charts, bar charts, and pie charts - Ability to perform and display calculations including sum of quantities, count of entries, and difference between start and end values The dashboard must include: - Data visualization through number fields (count, sum, difference) - Abilit...

Looking to create the views in mariadb required for a calculation system to process sales data and automatically determines commissions based on various metrics. Category-based calculations Flexible rule implementation Experience with Excel/MariaDB Strong analytical skills Experience with business calculation systems Ability to implement complex business logic Looking for clean, maintainable code with proper documentation.

I need someone to transfer data from an Excel spreadsheet to a Word file, following a provided template, and then save it as a PDF. Ideal Skills and Experience: - Proficiency in Microsoft Excel and Word - Attention to detail (this is a must) - Ability to follow instructions accurately - Experience with data entry and document formatting Data Types: - The data consists of a mix of both text and numbers. Task Specifics: - A template will be provided for the Word file, which will require simple formatting (e.g., bold, italics, headings). - Instructions will be provided on how to organize the data in the Word file.

I am looking for a professional developer to create an e...Pending, Delivered, Rejected, In Warehouse ✅ Smart Scanning: Drivers can scan packages using a camera or scanner ✅ Warehouse Management: Accept and process incoming shipments ✅ API Integration: Connect with other courier companies in Albania and North Macedonia ✅ Reports & Analytics: Generate reports for orders, drivers, and sellers ✅ Order Printing: Print orders in A4 format and label prints ✅ Excel Import: Bulk order registration for higher efficiency Preferred Technologies: ✅ Laravel / Node.js for Backend ✅ React / Vue.js for Frontend ✅ MySQL / PostgreSQL for Database ✅ Mobile App (Optional) ? If you have experience in logistics platform development and can build a stable, fully functional system, contact me!

I'm in need of Canadian secured personal loan leads. The leads should be individuals looking to apply for a secured loans. The acquisition of these leads will be primarily through online advertising. Ideal Skills and Experience: - Proficient in Google Ads, Facebook Ads, and LinkedIn Ads. - Proven track record in lead generation. - Experience in the financial...secured personal loan leads. The leads should be individuals looking to apply for a secured loans. The acquisition of these leads will be primarily through online advertising. Ideal Skills and Experience: - Proficient in Google Ads, Facebook Ads, and LinkedIn Ads. - Proven track record in lead generation. - Experience in the financial sector, particularly with secured loans. - Ability to target and convert potential lea...

...with two Excel files: 1. “List to be sent to ” (Main Inventory File) • Contains a list of medical disposables and device parts used in our facilities. • Each row represents a unique item that must be mapped to both EMDN & UNSPSC. • You will add four new columns to this sheet: • EMDN Code (from reference sheet) • EMDN Name (from reference sheet) • UNSPSC Code (from reference sheet) • UNSPSC Name (from reference sheet) 2. “Global Item ” (Reference Data for Mapping) • Contains official EMDN & UNSPSC codes in two separate sheets. • You will use these sheets to correctly classify each item from our inventory. ✅ Requirements & Skills ✔ Experience in medical device classification & inventor...

...with two Excel files: 1. “List to be sent to ” (Main Inventory File) • Contains a list of medical disposables and device parts used in our facilities. • Each row represents a unique item that must be mapped to both EMDN & UNSPSC. • You will add four new columns to this sheet: • EMDN Code (from reference sheet) • EMDN Name (from reference sheet) • UNSPSC Code (from reference sheet) • UNSPSC Name (from reference sheet) 2. “Global Item ” (Reference Data for Mapping) • Contains official EMDN & UNSPSC codes in two separate sheets. • You will use these sheets to correctly classify each item from our inventory. ✅ Requirements & Skills ✔ Experience in medical device classification & inventor...

Web Hosting Server Expert needed to reconfigure our server so it loads the OpenCart 3.0.3.7 website faster and connection issues. We have a Cloudflare Pro now (before we had free) but not sure if we need it. Server we use is Apache 2.4.62, 10.6.21-MariaDB, Linux, Perl Version 5.26.3 (big enough for the site we have)   1. Server times-out. Speed is slow as well and we need to re-calibrate it. We have extension installed - that supposed to speed the site up but they cannot connect to our server since it is keep blocking it. We whitelisted 4 IP (Nitros) they gave us, but still no connection. We need Nitro to be connected to our site so server does not block it. Nitro people worked on it but they said it is from server site. (we have documentation on it what is happening). We

I can write code in VBA for moving rows (orders) from one sheet to the next upon entering specific data in a cell or any other event. Client will explain the rules for moving data in each particular sheet.

I have a CSV/Excel file containing product prices that I need adjusted. All product prices need to be increased by 20%. If the price is $0 then do not update and leave it at $0.

Architectural design - ongoing work: Architectural design of Self storage building and associated infrastructure. Software: • Revit 3D modelling • Lumion Rendering • Autocad • Excel Skills: • Experienced in architectural drafting and design • Knowledge and experience with Australian codes and standards • Full architectural drawing sets including: • Ability to create comprehensive fire safety and evacuation plans • Designing for energy-efficient and sustainable construction o Site plans o Self-storage unit layouts o Floor plans o Elevations o 3D views o Sections o Landscape plans o Traffic management plans o Window and door schedules o Cut and fill plans o Demolition plans o Office and amenity fitout o Construction details • Conve...

...connections. Target Audience: Businesses in Mississauga and the GTA, including but not limited to: ✅ Plumbing companies ✅ Electrical contractors ✅ HVAC companies ✅ Landscaping services ✅ Roofing companies ✅ Delivery & logistics businesses ✅ Mobile auto repair & detailing services ✅ Any business with fleet vehicles Deliverables: The freelancer will provide a detailed, organized list in Google Sheets or Excel, including: ? Business Name ? Industry Type ? Company Address ? Contact Person (Owner/Manager/Decision Maker) ? Phone Number ? Email Address ? Company Website Requirements: ✔ Proven experience in B2B lead generation ✔ Ability to source verified, up-to-date contact details ✔ Familiarity with Mississauga/GTA business landscape is a plus ✔ Strong research skills & a...

...gestionar invitados. Permitir que los invitados confirmen su asistencia en línea. Funcionalidades adicionales: Envío automático de correos electrónicos con las invitaciones y confirmaciones. Posibilidad de agregar comentarios o notas adicionales al confirmar asistencia. Diseño visual y funcional atractivo y amigable para los usuarios. Posibilidad de exportar las listas de invitados a formatos como Excel o PDF. Referencias: Nos gustaría implementar algo similar a los sistemas que se encuentran en: Bliss & Bone The Knot

I need a professional to test my VBA on MAC. You will be testing for macro execution, user interface elements and data processing on MAC as we develop on PC but have mac clients. Skills: - Proficient in VBA - Experienced with testing/running VBA on MAC - Excellent problem-solving skills.

I am launching a startup, Public Well Data, which will provide comprehensive oil and gas data services, starting with Oklahoma oil and gas wells. I need a minimalistic and clean logo incorporating oil well imagery, technology symbols, and data-related icons. For the website, I require: - An HTML-only site (no React, no frameworks, no WordPress; I will convert it to the necessary CMS framework myself) - Relying on as few plugins as possible - A homepage layout, an inner (sub) page layout, a layout for a our first product which will be an Oil and Gas well data feed delivered via email or API, a blog layout, and a contact page layout - A design that embodies simplicity, elegance, and a blend of business and technology. - The website should be fully responsive and optimized for mobil...

I need a professional who can convert my rough sketches into detailed 5D drawings for an entire residence. The ideal freelancer should be well-versed in both structural details and interior design elements.

...newcomers from various countries seeking health insurance in Switzerland. Ideal Skills and Experience: - Proven experience in data entry - Familiarity with public services preferred - Ability to handle sensitive data with confidentiality - Experience with database management - Attention to detail and accuracy - Knowledge of health insurance processes and terminologies The data should be entered in Excel format. The project will involve entering between 100 entries for the beginning. The project should be completed within the shortest possible timeframe. Please include the following data validation requirements: newcomers coming in Switzerland and requiring health insurance. The data should be organized by the newcomer's country of origin. Please include accuracy checks ...

I'm looking for an expert in Excel to assist me with some formulas related to numerical data. The primary goal is to help me with summing and averaging calculations.

El objetivo es crear un *dashboard automático en Excel* para el gimnasio, que permita consolidar los datos diarios de nuevos afiliados, renovaciones, ventas de cafetería y suplementos, y el cuadre de caja. El dashboard debe ser fácil de usar para las recepcionistas, con gráficos dinámicos y filtros para ver información por día, semana o mes. Además, debe actualizarse automáticamente cada vez que se ingresen nuevos datos sin dañar el archivo y debe ser claro y sencillo para evitar errores en su uso.

I'm in need of an Excel expert who can assist with fixing my spreadsheet and importing a proposal sheet. Specific tasks include: - Creating templates - Inserting data - Design and layout I'm experiencing some issues with my current spreadsheet that have not been resolved, so I would also appreciate a review of this. Ideal candidate should be proficient in Microsoft Excel, have experience with spreadsheet troubleshooting, and capable of assisting with proposal sheet preparation.

I'm seeking a native professional translator to translate an English text into Arabic (KSA). The text contains a list of 870 words linked to DIY tools, with a 27 % repetition rate. The lists are marketing phrases intended for the web and tools for professionals (like grinders, drills, hammers, etc.). Deliverables: - The translated text must be delivered in an Excel spreadsheet + SDLXLIFF (or TMX). - The job has to be completed by Friday, 7th, at 17:00 CET. Tone: - The translated marketing phrases should have an informal tone. Terminology: - There are no specific terminologies or keywords that need to be kept in English. Ideal Skills: - Strong proficiency in English and Arabic (KSA) - Experience with translating technical and marketing content - Familiarity with DIY tools...

I require a proficient web scraper to gather contact details from websites. The final data needs to be formatted into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in web scraping tools and techniques - Experience in data collection from websites - Ability to organize and format data into Excel - Attention to detail to ensure data accuracy

We have a WordPress site where we need the data from our contact forms converted into a JSon file. This file will be used for importing into our company database. Forms specifications: - Type: Contact forms - Fields: Our contact forms include Name, Email, Subject, and Message The ideal candidate for this project should have: - Proficiency in WordPress - Strong skills in JavaScript and JSON - Experience with database management and data importation - Ability to create custom data structures The JSON file needs to be structured in a custom way that is unique to our database requirements.

...specifically focusing on shipping rates. This report should provide insights into current shipping rates, trends, and any significant changes or anomalies. Ideal skills and experience for the job include: Designer & Visual Specialist Responsibilities: Visual Design & Layout: Create the overall design and layout for the report, ensuring it is visually appealing and on-brand. Data Visualization: Convert raw data into clear charts, graphs, and infographics that complement the written analysis. PDF Production: Prepare the final design files and manage the technical conversion to a high-quality PDF format, making sure the file is optimized for distribution (e.g., email, website, or print). Key Skills: Proficiency in graphic design software (such as Adobe InDesign, Illustra...

I need an expert in Excel to help automate calculations and report generation for my civil engineering projects. Key Tasks: - Automating calculations: This includes a variety of mathematical operations and civil engineering specific calculations. - Streamlining report generation: I want to simplify the process of creating reports from the data and calculations. Ideal Skills: - Proficiency in Excel: You should have advanced knowledge of Excel, including familiarity with its more complex functions and tools. - Civil Engineering Expertise: A strong understanding of civil engineering principles and calculations is crucial. - Automation Skills: Experience in automating tasks in Excel will be key to the success of this project. Please provide examples of similar p...

I'm looking for an Excel expert to create a daily fantasy sports sheet for basketball. This sheet should include current season player statistics, as well as an optimal lineup complete with captain and vice captain. Key Requirements: - Proficiency in Excel - Understanding of basketball and daily fantasy sports - Ability to source and incorporate up-to-date player statistics Ideal Skills: - Data analysis - Fantasy sports strategy - Excel VBA (for automation) Please note, this project is focused solely on the current basketball season.

I need a professional to convert my TV broadcast UDP stream into a 1080p HLS video stream. The output should be optimized primarily for Smart TVs. Our requirement is straight forward. At present we have multicast that provide UDP urls which we need to play in Samsung Tizen Smart TVs and the TV do not natively support it so we need to convert it into HLS so we can play it. So we need to build a system that can do the conversion without consuming resource. Key Requirements: - Convert UDP stream from a TV broadcast into an HLS stream - Ensure the output is 1080p resolution - Optimize the stream for Smart TV compatibility Ideal Skills: - Proficiency in video streaming technologies - Experience with HLS and UDP formats - Knowledge of Smart TV streaming standards

I need someone to help me with data entry on my WordPress site. The task involves transferring data from another site into my WordPress site. The job involves 600 products, specifically car wrap films. Dat...my WordPress site. The job involves 600 products, specifically car wrap films. Data to be transferred includes: - Product descriptions - Price variations - Product Images I have some images, but will need assistance in sourcing additional ones. The data from the source site is in a CSV/Excel format. Ideal skills and experience for this job: - Proficiency in WordPress - Excellent data entry skills - Experience with product data entry - Ability to source product images - Familiarity with handling CSV/Excel files. Please ensure you have the necessary skills before bi...

I need assistance with entering mixed data (both text and numerical) from scanned documents into an Excel spreadsheet. The data does not require any specific formatting and can be entered in a standard table format. Ideal skills and experience for the job: - Proficient in Excel - Detail-oriented - Experience with data entry - Ability to transcribe information accurately from scanned documents

I'm looking for a detail-oriented freelancer to assist with a simple data entry project. The task involves copying text data from a digital Excel file into online database records. Ideal Skills: - Proficiency in Excel - Attention to detail - Good understanding of text data - Ability to maintain data confidentiality Experience: - Prior data entry experience preferred - Familiarity with handling digital files Other: - Can perform duties during normal Mountain Standard Time working hours - English-speaking Please bid if you can meet these requirements. Thank you.

I have 15 Excel documents containing survey data tables. Each document has multiple tabs with tables. You will need to: - Format all tables uniformly, ensuring they have the same headers and layout - Set the headers to be bold and centered - Adjust the tables to have uniform column widths After formatting, please return the files as: - A neatly formatted Excel document - A merged PDF of all the tables Ideal candidates for this project should have: - Strong Excel skills and experience with data formatting - Attention to detail to ensure all tables are formatted identically - Ability to create a merged PDF from Excel Please note, the headers should be bold and centered, and all tables should have uniform column widths. Ensure the table font style is uniform ...

I'm looking for a web scraping expert who can extract Over/Under lines (all lines , not only the main one) for all MBL (Baseball) and NHL (Hockey) games from the past 5 seasons. The data should be delivered in an Excel (XLSX) format. Key Requirements: - Expertise in web scraping - Proficient in data handling and Excel - Familiarity with MBL and NHL data - Ability to extract specific betting lines The ideal freelancer for this project would be detail-oriented, with a proven track record in web data extraction, particularly in the sports and betting domain. The ultimate goal is to get comprehensive, clean data for analysis.

I'm looking for a skilled 3D modeler who can convert a DXF file into a high-resolution, intricate 3D model in AutoCAD 3D. This model will be used for rendering a presentation, so it needs to be visually appealing and precise. Ideal Skills: - Proficiency in converting DXF files to 3D models - Extensive experience with AutoCAD 3D - Strong understanding of high-resolution, intricate detailing - Background in creating 3D models for presentations Please provide examples of previous similar work in your bid.

I need a iOS developer to convert my Android app into an iOS-compatible one. Upon successful conversion, the app should be published on the Apple Store using your developer account. Key Details: - I have the complete source code of the Android app. - The app primarily has push notifications as its main functionality. - The content of the app is static, so no backend server is necessary.

I'm in need of a male who speaks Telugu and Hindi fluently. Your job will be to call various barber shops in Hyderabad and gather information about their services, specifically service names and pricing. This will include: - Understanding and noting down the different services offered, such as hair cuts, shaves, head mass...include: - Understanding and noting down the different services offered, such as hair cuts, shaves, head massages, etc. - Inquiring about the pricing for these services Once you have collected this data, you will need to upload all of it to the admin panel of my web app. This will involve: - Manually inputting each detail The ideal candidate should be comfortable with: - Data entry - Working with Excel - Using Google Experience in similar tasks will b...

...or loss, and the system finds the price differences in BTC at different time frames to create a supposed buy or sell at a certain past existing price to reach that goal. • The system will recreate a past possible operation to achieve the desired profit or loss goal, considering long or short trades. • The results should reflect the reality of the markets and can be realized with a formula in an Excel sheet. • The trade results should appear in the client's portfolio in BTC, ETH, and other cryptocurrencies. • Profit and losses should appear in EUR, USD, and BTC and be added or deducted from the client's account. • It should look like past existing trading, increasing or decreasing the portfolio value. • The account should show the invested m...

...mindset to boost profit margins. Your primary responsibility will be to identify, source and sell our Course on Personal Development. So we pay you your commission once you Close the sale for £100 if you think this is you, please reach out. Must have excellent control over the English language, would prefer for the freelancer to be in the States or Canada. Key Responsibilities: - Contact and convert cold leads into course purchases - Employ persuasive sales techniques tailored for the personal development niche - Track sales progress and report back on lead conversion rates Ideal Candidate: - Proven experience in closing sales, particularly with cold leads - Familiarity with the personal development industry is a plus - Exceptional communication and persuasive skills - S...

I'm looking for a professional who can convert my Flash-based animations into HTML5. These animations will eventually be used for web delivery, so they need to be compatible with all modern browsers and devices. Your task will include: - Converting the Flash animations into HTML5 without loss of quality - Implementing click-based actions and hover effects as per the original animations - Ensuring the end product is fully optimized for usability and accessibility Ideal candidates should have: - Extensive experience working with both Flash and HTML5 - A strong understanding of web standards and best practices - Previous experience converting animations for marketing purposes Please include examples of similar projects you've completed in your proposal.

...pipeline for Excel uploads, and provide a management interface for querying the data. Requirements 1. Azure SQL Database Setup Deploy an Azure SQL Database (PaaS) instance. Create three tables using data from provided Excel sheets. Define appropriate data types, constraints, and indexing for optimised performance. Provide SQL scripts for table creation and initial data import. 2. Azure Virtual Machine (VM) for Management Provision an Azure Virtual Machine (Windows-based) to serve as a management server. Install and configure Microsoft SQL Server Management Studio (SSMS) for querying the database. Ensure secure remote access via RDP with proper firewall rules. 3. Data Pipeline with Azure Data Factory (ADF) Set up an Azure Data Factory (ADF) pipeline to upload and process...

I'm looking for a professional who can convert a PDF into a fully accessible, WCAG 2.1 compliant EPUB. The PDF primarily contains text and images and needs to be optimized for readability on various devices. Key Requirements: - Convert a PDF into a fully accessible EPUB - Ensure the EPUB complies with WCAG 2.1 - Optimize the EPUB for device readability - Incorporate text-to-speech support within the EPUB. - Include navigation aids like a table of contents and page lists. - Add alternative text descriptions for all images and graphics. - Ensure sufficient color contrast for text readability. Ideal Skills and Experience: - Proven experience with EPUB creation - Familiarity with accessibility standards, particularly WCAG 2.1 - Strong understanding of device readability r...

visual studio code aplicacion con fiori element, efectuando la llamada de servicios odata 4.0 o 2.0(estan creados ambos). el odata trae datos de una tabla de sap de 5 columnas , 2 de las columnas necesitan ayuda de busqueda y hay que generar 3 botones . 1 boton 1 grabar datos 2 boton 2 agregar linea 3 boton cargar excel Lo creado se debe ingresar A sap para estar disponible a usar en fiori Se debe realizar en dos dias.

I need a detailed conversion of an apartment's floor plan from a PDF into Archicad 26. The project involves: - Transferring the floor plan layout from the PDF into Archicad 26 without modifications. - Creating a full architectural detail drawing in Archicad 26. The ideal freelancer for this project should have: - Proficiency in Archicad 26. - Experience in architectural detailing. - Ability to accurately interpret and transfer information from PDFs. Please note, the PDF only includes the floor plan layout, so there is no need to incorporate interior design details or structural elements.

I have a Word document containing names, emails, numbers, specialties, subspecialties, states, and cities. I need this data entered into an Excel spreadsheet with separate sheets for each category. Key requirements: - Proficient in Excel and data entry - Attention to detail to ensure data is accurately transferred - Ability to organize data into separate sheets by category