Macro export data excel filepráce

I'm looking for an Excel expert to create a robust three-level lookup function that can handle text data. The primary goal of this function is to facilitate data analysis, and it needs to be followed by basic arithmetic operations based on the result of the lookups. Key requirements: - The Excel function should have a three-level lookup that can handle text data. - The primary goal of the function is data analysis. - After the lookup, basic arithmetic operations should be performed based on the result. - The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" sheet with inte...

looking for a freelancer who can convert scanned PDF to editable Word file in the specified format 1000+ Scanned PDF's to word file

EXCEL. Preferencia: Google Sheets. Tengo una sola hoja con varias columnas: Conjunto 1: columna 1 "Activo" tienen nombres que pueden repetirse. columna 2 "Categoria". tienen clasificaciones. Conjunto 2: columna 3 "Titulo" tiene nombres de Clasificaciones. columna 4 "Categoria de Activo 1" a columna 11 "Categoria de Activo 8". columna 12 a 31 "" y "" con pasos de suma 1 en 1, portan valores numericos del 0 a 5. columna 32 a 41 "D1" con paso de suma 1 en 1. Relaciones: + columna 1, 2 y 32 a 41 estan relacionadas. + columna 3, 4 a 11, 12 a 31 estan relacionadas. Se necesita crear una tabla dinamica donde aparesca cada dato de "Activo" donde se halla una coincidencia "Categoria" con...

Looking for a Matlab expert capable of coding a system that can convert an unspecified type of file to an image. The original file format and the desired image format are undefined, thus the freelancer needs to manage variable inputs. I am unable to provide a specific size for the files that will be converted, so the system should be capable of handling files of different sizes. Skills and Experience Required: - Proficiency in Matlab - Experience with file conversion tasks - Ability to deal with variable inputs - Ability to work with large files

...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process autom...

I'm looking for a skilled individual to assist with a less than ten PDF documents data entry project. Key Responsibilities: - Copy typing of content from PDFs - Extraction of specific data points - Validation for accuracy and completeness This role will suit someone with proven expertise in data entry and validation. The ideal candidate is detail-oriented and proficient in handling PDF documents. Experience with Microsoft Excel is a plus.

I need an experienced graphic designer who can convert a photo into an AI file. The final AI file needs to be an exact replica of the photo, with high detail and must be fully editable. Key requirements include: - Expertise in graphic design and using Adobe Illustrator - Ability to convert a photo into an AI file that is an exact replica with high detail - Attention to detail and precision is a must to maintain the quality of the photo in the AI file - Experience in providing editable AI files is highly preferred, as the file will be used for future editing. XX PLEASE SHOW THE SCREENSHOT OF AI WITH EDITABLE ALL LAYERS XX Please provide examples of similar projects you have completed in the past, and a brief overview of your experience with this type ...

...JSON-formatted data containing information about every layer, including x and y axis data. 2. *User Requirements:* - The software should provide a user-friendly interface for uploading DWG files. - Upon file upload, the software should process the DWG files and extract data from each layer. - Users should have the option to specify the output format (JSON). - The software should ensure compatibility with various DWG file versions. 3. *Functional Requirements:* - Extraction of Layer Data: - The software must parse each uploaded DWG file and extract information about every layer data, like height width distance between two layers. - Information to be extracted includes but is not limited to: layer name, obj...

I need a professional to update my logo. Here's what the job entails: - Take my existing logo in vector format (AI or SVG) - Change the color of the logo to a darker grey - Add text in same font as logo and QR code as provided - create AI file in given format which will be used to print all on packaging tape I'm looking for a designer who has: - Proficiency in logo design and Adobe Illustrator - Experience working with vector graphics - Ability to understand and implement specific color changes to a design Please reach out if you have the right skills and experience to deliver a high-quality service.

I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions

I'm in need of a data entry freelancer with a good command of Microsoft Excel. The task involves inputting data into a spreadsheet. The data is simple and involves just a few columns. This is an ideal project for a freelancer who is available to work from home. Ideal skills for this job include: - Proficiency in Microsoft Excel - Attention to detail - Ability to maintain accuracy while working with data Please note that I don't require any specific software knowledge other than Microsoft Excel. Looking forward to working together.

I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions

I'm seeking an experienced professional who excel...seeking an experienced professional who excels in sophisticated data analysis, chart creation and process automation using Excel. You'll need to leverage data visualization techniques to deliver insightful dashboards, with a key focus on developing pie charts for clear, concise, and impactful data representation. Your responsibilities will include: - Analyzing and interpreting complex data sets - Crafting well-structured and insightful pie charts - Automating repetitive processes to improve productivity Core competencies required for this role include a strong background in Excel and data analytics, proficiency in dashboard creation, a keen understanding of automation process...

I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with &l...

...workforce. Key Responsibilities: - Develop a structured sales training program encompassing various selling techniques, customer service, and product knowledge reinforcement. - Create engaging and interactive product training sessions that educate employees about our offerings, benefits, and unique selling points. - Implement a series of on-the-job training modules that help employees grasp and excel in their roles, while aligning their efforts with organizational goals. Ideal Candidate: - Experience in designing and delivering comprehensive sales and product training programs. - Proven track record in conducting engaging and effective online and offline training sessions. - A solid understanding of adult learning principles, particularly in a corporate setting. - Excellent com...

I am looking for English Typing, Formatting, Correction - PDF to Word File conversion experts. I need only Indian freelancer who is also fluent English speaker. You have to do the work manually and accurately. I need high-quality and accurate services.

... Key Responsibilities: As the Backend Developer for this project you will: 1. Design and develop scalable server-side applications. 2. Implement robust APIs for seamless communication with the Flutter client. 3. Integrate third-party services to enhance platform features. 4. Manage data storage solutions and optimize database performance. 5. Ensure server-side code is optimized for performance and reliability. 6. Implement security measures to protect user data. Requirements: To excel in this role, you should: 1. Have proven backend development experience. 2. Be proficient in backend programming languages like Python, Node.js, or Java. 3. Have familiarity with web frameworks such as Django, Flask, or Spring Boot. 4. Understand RESTful API des...

I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.

I'm seeking a freelancer who can develop an automated system in Excel to manage backorders. This system must create new data for efficient backorder handling. Specific requirements include: • Creation of an automation tool that handles numeric values, text strings, and dates and times. • The system should adequately track product lead times and inventory levels, despite not automatically generating reports. Please note, having prior experience in backorder management and Excel automation will be advantageous for this project. The ideal freelancer should have strong data handling capabilities and excellent knowledge of Excel. Proven experience in similar projects is preferred.

EXCEL COSTOS Y PRECIOS EN base al tipo de producto QUE SE ENUMERARARAN DEL 1 AL 10 (ELECTRONICA, SOFTWARE, ETC) , peso , volumen y costo pagamos unos ciertos impuestos de importacion SEGUN EL TIPO DE PRODUCTO NOSOTROS QUEREMOS QUE EN BASE A ESTOS DATOS QUE VAMOS A PREFIJAR PARA CADA CATEGORIA , YA NOS DE EL COSTO , CUANDO EGREGUEMOS PRODUCTOS NUEVOS COMPLENTANDO LA TABLA. CON LOS COSTOS DE ESTA TABLA , NECESITAMOS OTRA TABLA PARA CALCULAR MARGEN DE GANANCIA TOMANDO EL PRECIO DEL PRODUCTO Y NOSOTROS PODER SETEAR UN MARGEN MODIFICABLE PARA CADA ARTICULO DE NUESTRA TIENDA, ESTOS TIENE UNOS COSTOS FIJOS (FEE FIJO DE VENTA , GASTOS DE ENVIO , COMISIONES DE PLATAFORMA QUE VARIAN) ADEMAS NECESITAMOS QUE EN ESTA TABLA SE PUEDAN HACER ¨COMBOS¨ ES DECIR PONER VARIOS PRODUTOS Y Q...

I need an experienced freelancer to create a chart with interest rates in Canada for every month between January 2015 and the current month. K...between January 2015 and the current month. Key Requirements: - The chart should accurately reflect the fluctuation in interest rates over the specified time period. - The format must be an excel which is easy to read and interpret. - No additional analytics features such as trend lines or forecasts are necessary, the primary focus is to clearly display interest rates by month. Ideal Skills: - Research historical interest rates in canada - Proficient in Excel and creating line graphs. - Strong understanding of financial data, specifically interest rates. - Eye for detail and ability to ensure the data is clearly pr...

...Users will receive a one-time password via SMS that they will need to enter in order to log in to their account. Addon developent for a Job Portal, Laravel & Api expert needed Modules/Controllers will be developed: User Management Module: -User registration and login functionality using zender or whatsapp, twilio, nexmo for otp( email and social login already available). -User profile management export function with search and sort. Package Management Module: -Allow users to view available packages. -Enable users to select a package based on the number of applications, profile validity duration, and vacancy details view limit. Coupon System Module: -Allowing users to enter coupon codes for discounts. -Validating and applying coupon discounts during the payment process. ...

I need an experienced freelancer who can convert Excel data to 2D DWG files on an urgent basis. Key Requirements: - Utilize the Excel data to create 2D contour plots, specifically representing the height distribution on a bridge surface and the riverbed levels. - Create these contour plots in a DWG format. - Accuracy and precision are crucial for this project. Ideal Skills and Experience: - Proficiency in AutoCAD for DWG creation. - Prior experience with data visualization from Excel. - Immediate availability to start and complete the project as soon as possible. Please include any relevant portfolio items or examples of similar projects you've done in the past. I am looking for a quick turnaround without compromising on quality.

Hola, estoy en la búsqueda de un book keeper con excelentes habilidades utilizando macros en excel esto es una de las habilidades importantes que me están pidiendo en el freelancer, indispensable también que tenga experiencia haciendo los libros para negocios en Canadá. Comunicación excelente en inglés. Me gustaría oír de ti. Saludos

I need someone to add a total of 50 bookmarks to my Word document. Essential Requirements: - Add 50 bookmarks to the document - create a excel; audit xls with 50 rows listing the bookmark name and the section text name (we use that as quality control and testing)

I'm seeking a proficient freelancer who can handle all aspects of setting up, running, and ensuring the success of my Shopify dropshipping account. My business focuses on a specific nich...SEO: I prefer to attract customers to my store through organic SEO strategies. Practical knowledge of SEO tools and techniques is a must. 3. Social Media Proficiency: In addition to SEO, I'd like to integrate targeted advertising on Facebook and Instagram into my marketing strategy. Ideally, the freelancer should have a track record of optimizing Shopify stores for effective dropshipping. To excel in this task, the freelancer should possess excellent SEO skills, social media advertising knowledge, and a clear understanding of dropshipping mechanics. Your bids should reflect your compet...

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

K zobrazení podrobností se zaregistrujte nebo přihlaste.

I'm looking for a proficient person that can go into links and write emails...good team. This is not a one person job. I need all records completed real time from a file on google drive. Must be complete with 24 hours Currently, I'm using Excel spreadsheets, which is proving inefficient. I require an effective solution to input data and offer functionality that makes the information more accessible. Your Tasks: Go into profile and extract email, phone number , link in the bio and also any nics in the bio Required Skills and Experience: - Understanding of search functionalities - Data Entry - Knowledge in data export would be a plus. You should have a strong track record of creating functional, efficient databases and exhibit a ke...

I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp

I am seeking a proficient web scraper to extract specific data from The data I need includes venue details and contact information. I require the end product to be delivered as a well-organised Excel file. Key aspects to focus on: * Meticulous detail on venue data * Comprehensive contact information * High level data formatting skills The ideal candidate has demonstrated experience in web scraping, data management and Excel. A background in music or event-based data is a plus. Efficiency, precision and respect for the source website's terms of service are crucial for this project.

I’m in need of an Excel specialist who is adept at enhancing operational efficiency through the automation of repetitive tasks, namely the creation of reports utilizing sales and operational data. Key Requirements: - Creating a system for report generation on Excel, extracting key insights from extensive datasets. - Reports should conveniently display revenue, profit margins, sales growth, as well as production metrics and efficiency metrics. Ideal skills: - Proficiency in Excel and data analysis - Experience with big data and automating report generation - Strong attention to detail and the ability to make data actionable.

...utilizing their expertise in researching, content writing, and data entry to deliver high-quality results. Responsibilities: Conduct thorough research to identify and compile a targeted list of individuals in America relevant to our business objectives. Utilize various online resources, databases, and tools to gather accurate and up-to-date information. Organize and maintain the collected data in a structured format, ensuring accuracy and completeness. Collaborate closely with our team to understand specific criteria and requirements for the list. Requirements: Proven experience in researching, content writing, and data entry, preferably in a business or professional setting. Excellent attention to detail and accuracy in data collection and entry. Strong or...

...seeking a dedicated property manager. This position will be part-time or full-time. Responsibilities: •Gathering data from one source (Google Drive) to enter into document management (databases or partner websites by case) • Checking and reviewing documents for accuracy and completion • Attaching supporting files to the document management • Searching for additional information for documents that are incomplete • Verifying, correct, and delete unnecessary data, or combine data The requirements for the applicant include strong attention to details, college degree, access to email and knowledge of use a device (computer or phone), basic software tools (Microsoft Office - Word & Excel). We need fast, accurate and specialized mem...

...interactive dashboard that will help track and analyze market data more efficiently. It is important that the dashboard connects to Excel spreadsheets and other Power BI resources to provide an all-round perspective of the metrics. Ideal skills and experience: - Proficient in Power BI - Excellent knowledge of Excel - Deep understanding of retail market data analysis - Excellent in crunching and interpreting numbers - Strong attention to detail Responsibilities: - Gather and interpret market data - Create a user-friendly and highly interactive dashboard - Connect the dashboard to Excel spreadsheets and Power BI resources - Regularly update the dashboard with relevant market data - Identify trends and patterns based on the data p...

I'm in need of an advanced Excel VBA specialist with proficiency in data manipulation, particularly data filtering across multiple Excel sheets. The tasks required entail: - High-level manipulation of Excel data; - Expertise in filtering data across multiple sheets; - Strong understanding of data validation; - Experience in report generation. Experience in dealing with large amounts of data and creating user-friendly detailed reports from complex data sets will be crucial for this project. Excel VBA certification and verifiable previous projects in similar tasks are a plus.

Buenas tardes tengo un Excel de facturación y cobranza , incluye devoluciones y transferencias de productos . Deseo que se traslade tal cual como funciona a un sitio web con usuarios , permisos

I need help browsing the web for text data and organizing it in Excel. - The text data is to be organized in Excel by name and other relevant information. - No specific Excel functions or formulas need to be used, you will simply need to look at the page and type the information into the spreadsheet. Ideal skills: - Proficiency in web browsing - Be very quick - Strong attention to detail - Familiarity with Excel - Time management skills The task is straightforward, but attention to detail, accuracy, and the ability to work efficiently are crucial. Please submit your daily rate.

...am looking for an Excel expert who can help me create a dynamic and visually appealing Trend chart that can effectively communicate data composition over time. Key Requirements: - The chart must be able to clearly represent data changes over a period of time, showcasing the shifting proportions of different components. - The data for the chart will be provided in an Excel file. The freelancer will need to effectively structure this data to make it compatible for chart creation. - The chart should be designed with the latest Excel standards to ensure compatibility and ease of use. Ideal Candidate: - Strong proficiency in Excel, with a focus on chart creation. - Experience in creating dynamic and interactive charts in Ex...

I'm in need of a reliable freelancer to find a sample medical file from the USA that includes a police report from an accident. The file should be at least 200 pages and can contain doctor notes, insurance claim documents, police report, treatment plans, medication and treatment prescribed, and bills for services and costs. This can be a completely fake file, as I need it to test software I am using. Otherwise, it can be filed publicly or filed as part of a lawsuit. This should not be from a real person who has not given consent, unless it is already make public. It should not contain redactions.

We are looking for a highly skilled Lead Generation and Cold Calling Virtual Assistant for our Digital Marketing Agency. As a Cold Calling specialist, you will be responsible for researching and identifying potential leads, reaching out to them via phone or email, and qualifying them for our services. In addition to your research, you will also be provided with data for cold calling from our team. The ideal candidate should have excellent communication and negotiation skills, as well as a proven track record in cold calling and lead generation. This is a great opportunity to join a dynamic team and contribute to our growth. This part-time opportunity is for a 3-month period with potential to become a full-time role, subject to performance and business growth. The position also of...

...a financial analysis project through Microsoft Excel and require assistance with data structuring specifically for pivot tables. I aim to feed this data into a comprehensive dashboard. The Excel spreadsheet encompasses multiple periods of financial data. Key Aspects: - Data included in the pivot tables are dates of financial periods, types of financial information, and identifiers such as multiple General Ledger accounts, categories and subcategories. - The task involves transforming this spreadsheet data into an appropriate format suitable for creating a pivot table and consequent dashboard. Skills and Experience: - Proficiency in Microsoft Excel, particularly in the handling of complex data and pivot tables. - Experien...

I need help with Excel It is advance level so please be careful when you apply. Thanks.

Cuento con datos operacionales en Excel de mi trabajo, y necesito transformar esa data a dashboards y procesar data en un ambiente web. I have operational data in Excel from my work, and I need to transform that data into dashboards and process data in a web environment.

Extract the industry data from the IBIS reports and populate the Excel template

I need an Excel sheet that will empower me to manage my call center effectively by providing me with real-time insights into the number of agents needed per hour. Key Requirements: - The sheet should offer a graphical representation of the data, enabling me to quickly understand the changes in agent demand. - It must calculate and display the total call duration per agent,hourly agent demand, and the average wait time for callers. Data should be updated on a daily basis to ensure the most current and accurate information is available. Ideal Skills: - Proficiency in Excel and ability to create dynamic tables and graphs. - Experience in designing forecasting models would be a plus. - Strong understanding of call center operations and key metrics. The ide...

I have a Power BI file that is insanely slow and unusable. It has some glitch that has drastically slowed it down and cannot be resoled. So I need this file to be recreated in a superfast and fully efficient Excel by using formulas and VBA codes. More details to be share with winner.

I need a skilled Excel specialist to handle the automation of tasks in my daily-updated Excel file. Key Responsibilities: - Develop basic macros to automate tasks: I need macros to simplify and speed up the daily operations in the Excel file. Ideal Skills and Experience: - Proficiency in Excel: You should be very familiar with Excel tools and functions, especially in the area of macro creation. - Experience in automation: Previous experience in automating tasks in Excel, especially on a daily basis, would be highly beneficial. - Detail-oriented: The tasks are basic but they need to be carried out consistently and accurately on a daily basis. - Time management: You should be able to create a system that keeps up with the da...

...and my sample resume and you have to tailor it according to the role. It should be ATS-friendly and should have a score of a minimum of 85 % in resume worded. I have ready chatbot prompt to make your task easier so that each application resume will take less than 10 minutes. I just need the resume and its score's screenshot, I will add the job link in an Excel sheet so that it is organized properly. You will add resume's link in the same excel sheet, you could upload resume in folders on google drive. Is this task doable for you? Below is a sample job description -: "Position: Site Reliability/Observability Engineer (SREs). Location: Johnston, RI or Phoenix, AZ (4 - 5 days onsite). Duration: FTE Objectives of this role: Run the production environment ...

I'm in need of an experienced PCB designer who can modify a trace routing on a PCB gerber file. The specific requirement is to interrupt one of the traces, but ensure it can be easily jumpered. Key Requirements: - Expertise in PCB design and Gerber file modification - Ability to efficiently modify trace routing while maintaining the original design integrity - Understanding of how to create a jumper-friendly trace interruption Ideal Candidate: - Prior experience with similar trace routing modifications - Great attention to detail and an understanding of the importance of trace integrity in PCB design - Ability to communicate effectively to ensure the requirements are fully understood and implemented