Data web excell macro Jobs

Need a excell sheet with a site with the total of all "contractor" that are set to the single projects. All contractors have thei own page, that u can upload a invoice who is saved on the web/sky. The single invoice that is uploaded is set by date, amount, billing nr, and are taget and subtaget with the right tag, that are selected from dropdowns. U can also leave a comment. Hi, Im interested. How long is it for you to finish this? I also wonder, how is your thoughts about the storing of the invoices/files that are uploaded. This should be on the web/sky. Also need a "scan" function, so we can compare a invoice towards a "offer from a supplier", so we can see if the price is corrext. So it needs to be possible to upload an offer/pdf th...

...including the creation of simple macros to automate certain repetitive tasks. Key Requirements: - Proficiency in Excel: I need an expert who is well-versed in Excel and can help me set up basic formulas for tasks like addition, subtraction, multiplication, and division. - Macro Creation: I'm looking for assistance in creating simple macros that will help automate some of the repetitive tasks in my worksheet. Ideal Skills: - Proficient in Excel: The freelancer should be comfortable with Excel's advanced features. - Experienced in Macro Creation: The ideal candidate should have experience in creating simple yet effective macros for automation in Excel. - Excellent attention to detail: Accuracy is crucial, so the freelancer must be detail-oriented to avoid errors ...

I'm looking for a freelancer who can create a simple, yet effective, VBA macro to combine a set of between 10 to 50 small CSV files. These files all share the same column headers, and the macro should merge the data in these CSVs while maintaining the column sequence as provided. This task is straightforward and should not take much time for an experienced freelancer. A successful completion of this task will certainly result in a 10-star rating from me. See the uploaded document that details what needs to be done. I will provide the coder that I choose with several sample small csv files to combine.

I'm seeking an Excel Macro specialist to automate several repetitive tasks specific to engineering. The qualified individual needs to have: - Proven experience in creating efficient and complex macros - A solid grasp of engineering needs in relation to Excel functions - An ability to work with dense datasets and create tailored reports Tasks include, but are not limited to: - Automating repetitive engineering report creation - Streamlining data organization This project requires both expertise in Excel and understanding of engineering principles, hence any experience in the field can be a significant bonus. High efficiency and attention to details are of prime importance. Macro will need to be in word file and will change depending of the test - test A to J....

Hava aracı rüzgar tüneli modellerinde kontrol yüzeylerinden kaynaklanan menteşe momentleri ve eğilme momentleri modele özel tasarlanan sensörler yardımıyla ölçülmektedir. Bilinen kısıtlı bir hacime sığması gereken bu sensörler hem gerekli mukavemeti sağlamalı hem de test yükleri altında belirlenen bölgelerde istenen gerinme değerlerini sağlayabilmelidir. Tüm bu parametrelerin otomatik olarak optimizasyonunu yapabilecek bir makro yazılımının geliştirilmesi beklenmektedir. (Tercihen CATIA) Model içerisindeki herhangi bir parametreyi değiştirerek farklı geometriler elde edilebilmektedir. Konspept 1’de gage uygulanacak bölgeyi silindirik şafta dönüştürerek Konsept-2’yi elde edebilirsiniz. ...

Need a excell sheet with a site with the total of all "contractor" that are set to the single projects. All contractors have thei own page, that u can upload a invoice who is saved on the web/sky. The single invoice that is uploaded is set by date, amount, billing nr, and are taget and subtaget with the right tag, that are selected from dropdowns. U can also leave a comment. Hi, Im interested. How long is it for you to finish this? I also wonder, how is your thoughts about the storing of the invoices/files that are uploaded. This should be on the web/sky. Also need a "scan" function, so we can compare a invoice towards a "offer from a supplier", so we can see if the price is corrext. So it needs to be possible to upload an offer/pdf th...

I am in urgent need of an expert Excel Macro developer who can generate a multidimensional tool for a restaurant setting. Key Responsibilities: - Design, build, and test a multifunctional Excel Macro that's compatible with Windows. - The macro should be able to generate sales reports, calculate inventory, and analyze customer data. Ideal Candidate: A successful candidate should have exceptional Excel Macro development skills, with an advanced understanding of restaurant operations. The candidate should be able to handle complex functionalities in Excel. This project is not suitable for beginners or intermediates; instead, an expert developer with proven experience in creating Excel Macros is required. Please provide evidence of similar past wo...

I'm looking for an experienced analyst proficient in R to conduct a thorough investigation on how macroeconomic variables affect house prices in India. We have some reference articles we want to use and replicate some of the results, in addition to adding something new. We have a dataset for the given variables ready and an R code that need adjustments in order to run properly and fix some bugs. Key Project Details: - **Scope:** Your task will involve examining the impact of the following macroeconomic variables on Indian house prices (HPI): GDP growth rate, CPI, Interest rates, FDI, and REER. - **Time Period:** The analysis should cover both short-term and long-term trends, typically an ARDL model. We also would like to separate out the Covid years in order to see these effects. ...

I have an Excel file where the preventive and corrective maintenance services of some equipment are registered. It is divided b...It is divided by team in Excel sheets, in the example there are 2 teams BU-001 and BU-002. By pressing the finish button at the top of the sheet, the macro must copy the existing data from the selected sheet to the BDD sheet table, and also delete the elements found in the BDD sheet table. sheet in progress (BU-001 in the example), in addition to setting the "MAN HOURS IN CURRENT MAINTENANCE" and "DAYS OUT OF SERVICE" fields to 0's. It is necessary that the macro works on the selected sheet, since the sheet will be duplicated to have one sheet per team, and when the sheet is duplicated, the macro does not lo...

I need an Excel macro to move records between two sheets in the same workbook. Here's the challenging part: records should be relocated based upon logical condition within a certain range of values in designated columns. Time isn't a constraint but proficiency in scripting Excel macros and strong grasp of logical functions is mandatory. Clean and efficient code is valuable. Understanding of data management in Excel is also desirable. Patience needed to iterate and perfect the code. Please apply if you meet these criteria.

Cuento con un archivo de Excel donde se dan de alta los servicios de mantenimi...dividido por equipo en hojas de Excel, en el ejemplo existen 2 equipos BU-001 Y BU-002. Al presionar el botón finalizar que se encuentra en la parte alta de la hoja, la macro debe copiar los datos existentes de la hoja que se encuentre seleccionada a la tabla de la hoja BDD, además eliminar los elementos que se encuentran en la tabla de la hoja en curso (BU-001 en el ejemplo), además de poner en 0´s los campos "HORAS HOMBRE EN MANTENIMIENTO ACTUAL" y "DIAS FUERA DE SERVICIO". Es necesario que la macro funcione en la hoja seleccionada, ya que la hoja se duplicara para tener una hoja por equipo, y al momento de duplicar la hoja, la macro no p...

I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E co...

More details: What specific type of data analysis do you need? Statistical analysis What information should successful freelancers include in their application? Detailed project proposals What type of statistical analysis do you require? Predictive analysis

I'm in need of an Excel expert to Create Macros. I have two spreadsheets. On each spreadsheet i have an input form. When the form has been entered and the user clicks "Enter Asset" each of the filled out cells (as per the File - "Template Code Functions") should be transferred to the "Data Collection Spreadsheet". Just enter into the next unused row. When the asset has been added successfully the cells marked as "Yes" as per the "template code functions" for "Reset on data entry" shall be empty on the input form. There are two spreadsheets, they are slightly different from each other.

I am in need of an Excel Macro skilled professional, who can automate my manual work of generating operational data reports. My preferred output format for these reports is Excel spreadsheets. Key Responsibilities: - Design and create a macro in Excel for automatic report generation using operational data - Ensure the macro is accurate and efficient, cutting down the time spent on report creation Ideal Skills: - Excellent understanding of Excel Macros and VBA - Experience in creating automated report generation systems - Familiarity with handling operational data is preferable.

...expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management processes. Ide...

...sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirements in more detail. Please let me know if you're interested and if you need any further information. The attached (FIVERR) helped us with a lot of redundancy ...

...expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management processes. Ide...

I'm seeking an academic writer with a strong understanding of economics, market structures, and legal disputes. This project requires: - Writing an economics paper focused on antitrust lawsuits against Apple. - Analysis and discussion should center on the economic impacts of these lawsuits. - The paper should delve into the potential macro and microeconomic consequences, including market effects, influenced by these legal actions. - Familiarity with economic principles and legal jargon is beneficial. - An objective perspective, academic referencing, and evidence-backed arguments should be adhered to. Please use 3 sources and cite them here are the requirements Apple Lawsuit Paper (Due 4/29) 4-5 Paragraphs 3+ Sources Topic: US Government vs. Apple lawsuit Intro - Summary...

I have to download everyday +- 3000 invoices (PDF files) from a server to my computer. I already have this task semi-automated in an Excel macro, but I want to do it easier. I need a tool (also in Excel/VB/Macro) where: - I'll write the day, month and year - I'll write the first invoice number and last invoice number that I want your tool to search - I'll hit a button "START" and your tool will search and download to my computer every invoices from that range that were issued on that specific day from an specific URL. The URL for these files is a standard URL. It's always an URL like this: The only part that changes is day, month, year and invoice number. Example: if I want to download any available invoices between numbers 5000

As an entrepreneur in the bo...be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projections for businesses This business plan stands as the blueprint for our business operations and the document will likely be used to engage with future potential partners and stakeholders. The right candidate for this job will be able to articulate our vision and strategy cl...

...with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and manipulate pivot tables. ...

EN Project with the intention of reducing the time for creating cutting files and eliminating errors in saving. Aplication Area: Engineering and manufacturing Automation of saving cutting files and manipulation of drawings, 1 - Save cutting files, considering the file type and correct naming. There is a file with several layers categorized in a standard way, these layers should be separated and saved in different files with specific names according to the layer. 2 - Save steel cutting files and possibly make changes/cuts (e.g., Slide). PT Projeto com intenção reduzir tempo de criação de arquivos de corte e eliminar erros no salvamento. Area: Engenharia e manufatura Automatização de salvamento de arquivos de corte e manipulaçã...

...consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automation opportunities. • Well-versed with dynamic loops, data extraction from images. • Work with users and team members at all levels for performance improvement and suggestions. • Understand and prepare Ad hoc reports. • Identify the opportunities of automating reports, snapshots and dashboards using advanced formulas, Advanced Excel, Python and other techniques • Consolidate, sort, organize and summar...

Hi Sir, I can create the macro as per instruction shared . Thanks Arun

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

2 excel files with VBA macro as per customer requirement

One excel file with macro as per requirement

One excel file with macro as per the customer requirement

I am urgently seeking a proficient macro developer to create a small, efficient macro capable of identifying and removing rows based on specific phrases present in multiple columns. Key Project Requirements: - The developed macro must target multiple columns in the sheet. - Deleted row criteria: rows with specific text present. - Must complete as soon as possible. Ideal Freelancer Skills and Experience: - Experience in macro development, particularly macros for Excel or similar programs. - Strong attention to detail and a proven ability to interpret and implement specific criteria. - An ability to work quickly and efficiently to deliver the project as soon as possible. Feel free to ask any questions that will assist you in accurately pricing your bid. I a...

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and defect-f...

The purpose of this project is to create a detailed, technical drawing using SolidWorks 2022. The emphasis of the project is documentation of plastic parts, both on a macro and micro-level. Key Requirements: - Able to generate technical drawings that include overall dimensions, shapes, specific features, and tolerances of plastic parts. - SolidWorks 2022 ONLY!! - Extensive experience and understanding in documentation of manufacturing processes and components - Expertise in rendering intricate details of plastic parts - Must be able to abide by all requirements for precision-driven, technical documentation - Detailed and clear communication The ideal candidate will have a background in mechanical engineering or a related field, as well as experience in creating detailed, techni...

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.

...seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a use...

I'm looking for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver high-quality, efficient and effective macros.

...me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The macro allows to: • Generate the Output in a separate spreadsheet (which captures only the required fiel...

I need an Excel macro developed for my employee training tracking workbook. I want to have a feature that sends email notifications to both the new hire and their manager based on the completion date of each training module. Key Requirements: - Email Trigger: The macro should send emails based on the completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Familiarity with Employee Training...

...record in creating, managing or implementing cloud-based robo calling systems and also conversational AI calls that is good with asian language, especially Bahasa Indonesia. the subject of the research must have : telephony (SIP/VOIP) a working AI model or open to integrations with AI Basic Telco Services features such as, Campaign Calls, scheduler, call recorder) Wide system integration capability Macro/logic/script editing(for robo caller,pre recorder or AI generated TTS) white label ready or not. KPI analysis The Goal of this research is to figure which or what is the best system/platform/Integration to use that gives the right combination so it result in cost effective, work effiency, best call per minute or per second tariff etc etc, feel free to do your own custom setup...

As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my life easier and my workload manageable.

...software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool should be established to compare timesheet entries against leave entries in our organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advan...

...software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool should be established to compare timesheet entries against leave entries in our organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advan...

I'm looking for a skilled freelancer with a strong understanding of Excel, particularly in building macros for data import and operations. Here's what you'll need to do: - Implement an Excel macro that can smoothly import numerical decimal data from a text file. Our perfect freelancer for this task will have: - Proficiency in Excel and VBA programming - Strong knowledge and experience in creating Excel macros - Understanding of data import techniques for decimal numerical data - Experience in handling data input tasks using macros. If you have the necessary skills and have previously handled similar projects, I'd love to get your bid. Thank you.

...freelancer with proficiency in Excel to create a comprehensive system to track my restaurant's weekly expenses. Key Job Responsibilities: - Develop a basic expense tracking Excel sheet. Macro auto update - Structure the sheet to track various types of expenses including but not limited to food costs, employee wages, and utility bills - Design the sheet for weekly data updates The ideal candidate should have: - Proficiency in Excel - Understanding of restaurant operations - Experience in creating expense tracking systems or similar projects. I'm not looking for sophisticated features such as budget comparisons or data analysis at this moment, just a simple, clean, and easy-to-use design. However, the sheet should be crafted in a way that it's easy...

Potential freelancers: -Past experience in financial services industry (Recommended) -Skilled in running excel VBA/macros, automating excel data & display through line chart Project: (1) Display recent weekly data (2) For past 5 years Key Details: (1) Data source:

Hello, I have a xlsx file with 2 sheets (sheet 1: data; sheet 2: pivot table), I need a vba macro that do this: - Delete data from sheet 1; - Import a txt file (the user can select it) in sheet 1; - Update the pivot table without changing formatting. And will share you more details in via chat box. Thanks

I am looking for skilled programmers who have the expertise in converting Excel VBA macro codes into a cloud-based solution that can be run on MS Azure. Key Requirements: - Conversion of Excel VBA macro focusing on data analysis - Development of a scalable and secure MS Azure-based solution Ideal Skills and Experience: - Proficient in Excel VBA and cloud technologies - Experience in migrating Excel VBA macros to cloud-based platforms, especially MS Azure - Strong understanding of data analysis and cloud security - Proven track record in developing scalable cloud solutions

...skilled freelancer with expertise in web scraping and data organization to extract detailed information about Funko Pop collectibles valued at $150 or more from PopPriceGuide.com. The project aims to create an Excel document listing these collectibles, focusing on item names and detailed data for each variant, including chase versions and their sub-variants. Scope of Work 1. Data Extraction: • Target the Funko Pop section on for data collection. • Extract data for Funko Pop collectibles with an estimated value of $150 or more. Required data points include: • Item name • Estimated value • Details for each variant (e.g., colors, themes) • Information on chase versions and any sub-variants &bull...

I want someone who can create a VBA macro to merge specified excel workbooks from different excel files in one click. More details: What specific tasks do you need the VBA Excel program to perform? Automate data entry What types of data will the VBA program need to handle while automating the data entry? Text data, Numeric data How will the VBA program receive the data that needs to be entered? Files

I am seeking a proficient HTML/Js coder with substantial experience in ZOHO Creator. The scope of the project requires the creation of an advanced Gantt chart with the following functionalities: - Drag and drop tasks: Make tasks movable, enhancing usability and adaptability. - Zoom in/out feature: An essential functionality to swiftly and seamlessly navigate between micro and macro views of the project timeline. - Task dependencies: Tasks should be linkable, illustrating the sequential or dependent nature of tasks. The Gantt chart should display task duration in 'Days'. Therefore, candidates with grasp of fine-tuned date and time handling in Js are preferred. Moreover, the chart should provide additional task details which include: - Assignment of tasks to specific t...