Data web excell macroKazi

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

I need to import data from multiple files that have roughly the same products in them, but it needs to show me in alphabetical order the product name in the first column and the best prices from each client in the next columns (from largest to smallest). Probably i need macros and i can`t figure them out

I am looking for a proficient Excel VBA developer to create a macro that can automate sending payslips to employees on a monthly basis. Key Requirements: - The VBA code should be able to extract the pay information from an Excel spreadsheet and generate a PDF file with the payslip. - The generated PDF file should then be attached to an email that is sent to the corresponding employee. Ideal Skills: - Proficiency in Excel VBA, including the ability to work with PDF files - Experience with automating email sending processes - Strong communication skills to ensure the solution meets our needs. Please note that this project is specifically for creating the VBA code for the payslip emailing system - the design and content of the payslips themselves are already established. Looki...

...issue with a Python macro that is not performing as expected. I'm uncertain of the actual problem, but I believe it's a simple one. Despite no recent alterations made to the macro, it is not running properly and it's impacting the overall function of my program. - The Task: The primary task is to diagnose the specific issue troubling the proper functioning of this Python macro, and subsequently implement the necessary corrections. - Macro Function: Though I am uncertain of the exact problem, the macro's primary function is to perform data manipulation operations, which aren't being successfully executed now. Ideal Skills: - Proficiency in Python - Prior experience in diagnosing and fixing issues related to macros - Good pr...

I have a excel of Maharashtra PT it has all macros and all i am able to use it but its outcome from excel the text file am not unable to find

I require immediate assistance for a web scraping into Excel task. This project focuses on the extraction of complete tables from different websites. Requirements: - Have expertise in web scraping and excel. - Be able to deliver completed work ASAP. Ideal Skills: - Proficiency in tools or programming languages for web scraping. - Strong command of Excel and data wrangling. - Demonstrated punctuality and adherence to deadlines. This is a time-sensitive task, requiring both speed and accuracy. Please, only serious and dedicated freelancers should consider this project. Job Description: There are 2 sets of tables, Soccer and Basketball for my analysis during my free time. 1. The links are in the spreadsheet highlighted in yellow. The script must also be eas...

Develop macro to generate Word docs

I'm in need of a professional proficient in Excel macros to assist with creating custom formulas specifically for data manipulation. The primary task would be to formulate macros that can effectively merge and separate data. Demonstrable experience in managing large datasets and solid knowledge in automated data manipulation will be essential for successful completion of the project. A background in eliminating duplications or inconsistencies would also be advantageous. I look forward to a hassle-free process and accurate results.

...what I need: - Development of a reliable Excel macro that can accurately identify and extract the necessary data from .dl files. - The macro should be robust enough to handle any inconsistencies or errors within the .dl files. In the event of an issue, rather than stopping entirely or skipping the file, the macro should create a log file noting the inconsistency or error for later review. Ideal skills: - Experience in Excel macro development - Familiarity with .dl file structure - Attention to detail - Problem-solving skills, particularly regarding file inconsistencies or errors - A background in data extraction would be highly advantageous If you think you can handle this kind of task, I would be interested to hear from you. The macr...

I'm looking for an expert to convert my existing Microsoft Excel Macro into a Google Sheet function with some added enhancements. The key enhancement is auto sorting on the newly created worksheets. The sort should utilize multiple columns, each with a unique order, either ascending or descending. Indispensable Skills: - Proficiency in Excel and Google Sheets - Familiarity with Macros and Google Scripts - Strong attention to detail, especially with data sorting and organization When you bid for this project, please say your opening comment as "Convert Excel Macro to Google Sheet Guru" - this way we will know who had done auto bidding and who has actually bothered to read out requirements. This job should be pretty easy and straight forward for some...

Develop macro to exclude strategies

As an MBA student, I need someone to help with my research paper focused on evaluating the cost-effectiveness and ROI of using micro-influencers versus macro-influencers in marketing campaigns. Key Objectives: - Analyze the comparative ROI of micro-influencers over macro-influencers - Use case studies of influencer campaigns to back findings Ideal Candidate Skills: - Proficient in business writing, specifically in academic context - Strong background in marketing and financial analysis - Familiarity with influencer marketing - Ability to analyze case studies effectively I look forward to working with someone diversely skilled in business research to bring this project to fruition.

Develop macro to merge data from workbooks

The project is about Excel VBA and macro.

I am in need of an expert Word VBA programmer to: ...documents - Make these macros capable of converting Word files (.docx) to PDF, and vice versa (this PDF file -> .docx) using the website (PDF to WORD Converter) or free API (similar like quality). The ideal freelancer for this project will: - Have in-depth knowledge and experience in Word VBA programming and macro development - Be familiar with file conversion resources such as - Be capable of thoroughly testing the macro to ensure it functions correctly, specifically for document conversion. The goal of this project is not only to automate document conversion, but also to enhance workflow efficiency. If you are keen on taking part in this project, kindly send in your bids. Please look attachment.

Butik bir tatlı üreticisi olarak ürünlerimizin birim maliyetinin hesaplanması ve şubeleremize yapıcağımız ürünlerin adet karşılığı olarak sarf edilen Hammaddenin hesaplanması içeren anlaşılır basit excell formunun hazırlanması sürekli kullanılması

I am seeking a proficient Excel expert to enhance macros within an existing spreadsheet....re-scripting macros for performance enhancement. On top of this, the spreadheet needs to have its calculation functions updated in certain areas. Hence, the ideal candidate should be comfortable in tweaking and improving formulas for better functionality. I also anticipate that some redundant aspects of the macros may be stripped off as we progress to streamline performance. Required Skills: - Proven Macro scripting and implementation in Excel - Solid understanding and experience in complex formula manipulation - Ability to optimize spreadsheet for improved performance and efficiency. Note: Specific deliverables relating to the calculation changes will be shared during our one-on-one project d...

I have a task I need automated using an Excel macro. The specific function I need is data filtering from various sheets. - The Macro Task: The job involves creating a macro that filters data to different sheets. - Data Filtering: Notably, the filtering should be done based on specific criteria. I require a system that intelligently separates and filters information to various sheets. - Work Scope: I need the data filtered from multiple sheets, not limited to sheets 2, 3, or 4. The project might involve other sheets as well. Ideal freelancers for this job will have strong experience in Excel macros, data filtering, and automation scripts. Expertise in efficient data handling and manipulation are essential.

Need to upgrade my existing excel macro, very simple project

macro based excel project with auto copy data and paste in chrome through selinium

I need a Microsoft Excel w...within microsoft excel to perform find and replace tasks on external files (.html files) - An excel spreadsheet placed in a folder will be able to... Macro 1 Will list all the files in the current directly in column A Macro 2 Will open and search the files in column A for strings listed in column B and confirm if they were found in Column C (Found or Not Found) Macro 3 Will open and find the string listed in column A and replace it with the new string listed in Column D Given the nature of the project, strong Excel and VBA proficiency is expected. Your skills should include but not be limited to creating macros, utilizing VBA for intricate data manipulation tasks, and swiftly understanding user requirements. I'm looking forw...

I am in need of an expert Word VBA programmer to: - Develop custom macros ...programmer to: - Develop custom macros for Word documents - Make these macros capable of converting Word files (.docx) to PDF, and vice versa (this PDF file -> .docx) using the (PDF to WORD Converter) website. The ideal freelancer for this project will: - Have in-depth knowledge and experience in Word VBA programming and macro development - Be familiar with file conversion resources such as - Be capable of thoroughly testing the macro to ensure it functions correctly, specifically for document conversion. The goal of this project is not only to automate document conversion, but also to enhance workflow efficiency. If you are keen on taking part in this project, kindly send in your bids.

We are seeking a skilled web designer to revamp the front end of our company website, IDIGITALPRENEUR, to align with our global expansion initiatives. The redesigned website should exude professionalism and incorporate modern design elements, including micro and macro animations, to enhance user engagement. Current Website - Key Requirements: - Redesign IDIGITALPRENEUR website to reflect a modern, global brand image. - Incorporate micro and macro animations to elevate user experience. - Maintain a professional aesthetic with a preference for a dark color theme, though light colors can be utilized as needed.

Create excell file, instructions follow

The main task will be to automate the process of downloading PDF files. The desired macro should: - Navigate to a specific URL - Download all PDFs - This includes navigating to the next page(s) until all PDFs downloaded. Do not use the "All" link, use the "Next page" link. The macro should do the downloads page by page. The page URL is All this can be done with the open-source version of (free!). Screenshot attached. We need this macro within a week. So please only bid if you can work on this now. In your bid, please mention "within-a-week". Sorry about that, we need that filter to avoid all the spam bids.

I urgently require an expert to lift protection from a VBA macro in my Excel 2007 document. A complex password (10+ characters, including symbols) protects the macro. Here's what's needed: - Thorough understanding of Excel 2007 and later - Proficiency in dealing with complex passwords - Demonstrable experience in unlocking protected VBA macros The document itself is not password-protected and remains accessible. However, the VBA macro within is locked. I am specifically looking for a problem-solver with a track record in removing complex macro passwords without affecting the functionality of the macro. Please only apply if you meet these criteria.

Task Description: Please Read this and use it to submit your complete Drink Menu Card including all drinks and prices as depicted in the excell file. See the old Drink menu and create something uniqe and cool with the below guidance. Your task is to design a visually appealing drink card that reflects the unique ambiance of Hangar 32 Bar and Runft Restaurant, two interconnected establishments with distinct styles. Incorporate the logos of both Hangar 32 and Runft into the design to showcase their connection. Hangar 32 Bar boasts a vintage aviation theme, featuring elements such as wood propellers and a nostalgic atmosphere. In contrast, Runft Restaurant exudes a modern vibe with sleek design aesthetics. Included are images of the Tap Bar and the restaurant to provide inspiration...

check reference image, excel insert row & copy the value from above row

I am attaching a file that includes the current output with notes. You can see yellow highlights as to what needs to be corrected in the existing code. Then I need a second macro to output data into the DoD_merge template. I added notes to that docunment.