Vba activexроботи

Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.

I'm looking for a proficient Excel developer with a strong background in trading syst...Excel-based trading system interfacing with Upstox. Key Requirements: - The system should support Day trading and Scalping strategies. - The system must include features for Automated trading, Data analysis and visualization, as well as Trade logging and reports. - The system should fetch market data via API integration with Upstox. Ideal Skills & Experience: - Advanced proficiency in Excel, including VBA for automation. - Proven experience in developing trading systems. - Familiarity with Upstox and its API. - Strong understanding of Day trading and Scalping strategies. - Excellent data analysis and visualization skills. Please, include examples of similar projects you have complete...

Project Title: Excel Macro-Based Inventory Management System for Diamond Trading Project Description: I am looking for an experienced Excel VBA (macro) developer to create a comprehensive inventory management system tailored for my diamond trading business. The system should be user-friendly, efficient, and capable of handling dynamic data with automated calculations. Key Requirements: 1. Modules: - Cash balance -Purchase and Sales records -Upcoming receivables and payables - 2. Automation Features: - Automated calculations for inventory updates based on parcel changes. - Dynamic addition and deletion of rows with real-time data updates. - Scrollable history for easy tracking of past transactions. - Backup and restore functionalities (preferably using JSON ...

I'm looking for an Excel & Office 365 expert to help me with Running Macros. I got Excel file link shared through Onedrive and i open it through Excel Desktop app but am unable to run macros. I tried enabling trust center settings dose not work. I wont be able to share file you need to explain me how to do this over a call.. Please note, this is a straightforward task with a budget of $10.

I'm an advanced Excel user looking to deepen my expertise with an in-person tutor. I want to focus on: - Macros and VBA - Data Analysis and Pivot Tables - Complex Formulas and Functions Ideal candidates should have a profound knowledge of these topics, combined with excellent teaching skills. Experience in creating customized lesson plans and real-world examples will be a plus. The tutoring sessions should be 4-5 hours per week. The tutoring sessions will take place at my home. The preferred duration of the tutoring engagement is 1-3 months. Tutoring sessions should be scheduled on weekends. The tutor should provide a personal laptop during the sessions. I prefer individual tutoring sessions. Tutoring sessions should be scheduled on weekend afternoons. A focus on statistical...

...related work remain the exclusive property of Impress Group. - The freelancer cannot reuse, resell, or share any part of the model, its methodology, or associated data. Required Skills & Experience We need an Excel automation expert with experience in manufacturing costing, CNC machining, and fabrication pricing. Ideal candidates should have: - Strong Excel skills – advanced formulas, automation, VBA/macros if needed - Experience with rules-based quoting models and error-prevention logic - Knowledge of industry-standard data tables (bending tonnage, CNC speeds/feeds, tooling availability) - Manufacturing expertise – understanding of CNC, sheet metal, and fabrication - ERP experience – ensuring routing decimals integrate correctly into ERP Bonus (N...

I am seeking a skilled VBA/Excel programmer to develop an inventory program within excel that will allow the following: 1) allow me to add products into a components inventory database using a form Fields are: Vendor, SKU, UPC, Status, QTY STOCK, EXP DATE, Category, Brand, Component Name, Component Description, Size, DIMS, Gross Wt, Case Count, Case Cost, Unit Cost, Component URL, Product Image 2) Bundle Design Tool - a graphical design form that allows me to add different components to build a bundled product. Fields are: Bundle Name, Bundle Desc, SKU, Theme Category, Inspired By, QTY STOCK, STOCK STATUS, Target MSRP, Target Cost Website URL, Shipping Weight, Dimensions Components List/Cost Analysis: in the form there will be a list that will show the added components SK...

...tables, charts, and dashboards for data visualization. Automate tasks using Excel VBA (Macros) and Power Query to improve workflow efficiency. Clean, structure, and analyze large datasets using data validation, conditional formatting, and Power Pivot. Troubleshoot errors in formulas and provide solutions to improve spreadsheet functionality. Collaborate with different teams to gather requirements and create customized Excel reports. Maintain and improve existing Excel models, ensuring accuracy and performance. Train and support team members on best practices for using Excel effectively. Required Skills & Qualifications: Proven expertise in advanced Excel formulas and functions. Experience in Excel automation using VBA Macros, Power Query, and Power Pivot. Strong analyt...

tôi cần lập trình file nhập liệu ex cho tổ chức, chủ yếu là sổ sách thu chi của tổ chức, và xuất báo cáo trực qua bằng đồ thị để dẽ dàng quản lý hơn

...alongside the tabular data. - Ensure the documents are correctly formatted and easy to read. Ideal Skills: - Proficiency in Microsoft Excel and Word. - Experience with automation and scripting. - Strong attention to detail. Please provide examples of similar projects you have completed in your bid. The developer should use provided templates for the Word documents. The automation should be done using VBA for Office. The automation will be set up to handle one Word document template. The automation should be designed to handle low volume generation, approximately less than 50 documents regularly. The generated Word documents should be named using certain values from the Excel data. Please include pre-defined guidelines as specific text descriptions in the documents. The text de...

I'm looking for an expert in advanced Excel to help me improve my skills specifically in using shared Excel sheets on Google Drive. Ideal Skills and Experience: - Proficient in advanced Excel, particularly with shared sheets - Excellent teaching skills - Extensive experience with Google Drive's collaborative editing features - Knowledgeable about Excel's advanced formulas, VBA and Macros, as well as data analysis and pivot tables - Good understanding of file permissions and security in a shared environment. Key Focus Areas: - Mastering collaborative editing in Google Drive - Learning to use advanced Excel features in shared sheets - Improving overall Excel proficiency.

I'm in need of a skilled professional who can create a dynamic PowerPoint presentation slide using VBA code and Macros. Key requirements: - The slide should be a part of a presentation - It will primarily contain images and visuals - The VBA code or Macro should automate transitions and animations Ideal skills and experience: - Proficient in VBA and Macros - Experienced in creating engaging PowerPoint slides - Able to effectively automate slide transitions and animations Please provide examples of similar work in your proposal.

I'm seeking an Excel expert to create a dynamic workflow managing task dependencies. Key Requirements: - Understanding of task dependencies - Proficiency in creating dynamic Excel models - Ability to visualize task dependencies in various ways - Experience in creating Gantt chart visualizations in Excel for task dependencies. - Ability to write macros and VBA scripts to automate task dependency updates. - Expertise in using pivot tables to dynamically filter and analyze task data. - Proficiency in using conditional formatting to highlight critical paths and dependencies. - Experience incorporating data validation to prevent incorrect task entries. - Experience in designing user-friendly interfaces within Excel for ease of use. The ideal freelancer for this project will be qu...

...layout, header/footer, font style, spacing, etc.). Implement a solution (such as a macro or easy-to-use tool) that allows me to apply this template automatically with just one click to any document. Provide clear instructions on how to use the template or macro so I can apply it efficiently to new documents. Skills Needed: Expertise in Microsoft Word, including templates and macros. Familiarity with VBA (Visual Basic for Applications) for automating tasks (if applicable). Ability to create reusable templates that are easy to implement. Strong attention to detail and an understanding of formatting best practices. Additional Information: The template should work with Microsoft Word 2016 or later. It should be easy to update or adjust settings in case my formatting needs change in...

...dashboard's design for better readability, adding insightful analytics, automating processes using VBA where possible, and creating custom visualizations and interactive elements. Key Tasks: - Improve the design and layout of the dashboard - Incorporate more detailed and insightful financial analytics, with a focus on ratio analysis and cost-benefit analysis - Use your expertise in Excel to ensure automation where possible - Design and implement custom visualizations, such as graphs, charts, pivot tables, and trend indicators - Create interactive elements to enhance user engagement with the dashboard Ideal Skills and Experience: - Advanced Excel skills, including proficiency in Excel formulas and VBA - Strong accounting knowledge and experience in financial data ana...

Creazione di file in excel con formule, filtri, query, analisi, tabelle e grafici sulla base delle richieste del cliente. Macro VBA all'occorrenza.

I need a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that ...template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - Strong expertise in Excel, especially in creating custom templates. - Experience with mixed operation formulas. - Familiarity with Excel's macro and...

...day of each calendar year Correctly calculated annual interest Available credit line at the end of each year Technical Requirements: The spreadsheet must use formulas and/or VBA automation to ensure accurate and dynamic calculations. Must be fully functional on both Windows and Mac versions of Microsoft Excel without compatibility issues. Data should be structured for easy input and updates. The layout should be clear and user-friendly. The solution must handle different loan durations, interest rates, and varying payment schedules. Ideal Candidate: Expertise in Microsoft Excel, including formulas, pivot tables, and VBA (if needed). Strong understanding of financial calculations, especially loan interest computations. Experience ensuring cross-platform compatibility betwee...

Need to analysis current select columns using ChatGPT API

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

I'm looking for a freelancer to create an Excel workbook that consolidates data from 7 source sheets into a main sheet. The solution should dynamically update in real-time as the data in the source sheets change. PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING. Key requirements: - Use either Excel formulas or Power Query. VBA and Macros are not allowed. - Summarize totals for each unique combination of columns A-D from the source sheets. Note : data both sheets could go up to 1000 + rows. Deliverables: - A fully functional Excel file where the main sheet updates in real-time. - Clear documentation or a short instructional guide explaining how the solution works. Ideal skills and experience: - Strong Excel skills and expertise in using Power Query. - Good understan...

I have an Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dynamic Excel solutions will be highly advantageous.

I'm in need of a proficient Excel macro developer who can automate a series of tasks for me. The primary objectiv...usability. - Report Generation: Automating the process of report creation to save time and effort. - Complex Calculations: Building macros to perform intricate computations seamlessly. The macros will primarily interact with Excel files and Databases. As for triggering the macros, I would like to initiate them manually. Ideal skills and experience for this job: - Strong proficiency in Excel and VBA (Visual Basic for Applications). - Prior experience in developing macros for data cleaning, report generation and complex calculations. - Familiarity with databases and ability to integrate them with Excel. - Capability to create user-friendly macros that can be trig...

I'm looking for a skilled Excel VBA developer. I need a worksheet modification that will control data entry into cell H8 based on the status of cell D8, and enforce data type constraints. Requirements: - If cell D8 is BLANK: Allow user to enter data into cell H8. - If cell D8 IS NOT BLANK: Populate cell H8 with data from cell H12 and lock the cell from user changes. - Implement numeric-only validation for cell H8. Additional Information: - Cells D8, H8, H12 are unlocked and the sheet is password protected. - The functionality should persist for future users, even after data row 8 has been saved and cleared by an existing VBA script. Ideal skills include: - Proficiency in Excel and VBA - Experience with implementing data validation and conditional cell behavior ...

Create an excel file, with macros and forms (VBA development) to facilitate the folow up of work

I need a VBA script for Microsoft Word that will help me remove highlights from bullets and the space after in bulleted paragraph lists. The script should be manually executable by clicking a button. Ideal skills and experience for the job: - Proficiency in VBA (Visual Basic for Applications) - Strong understanding of Microsoft Word functionality - Prior experience creating Word scripts - Ability to write clear, user-friendly code Please note: The specific version of Microsoft Word this script will be used on has not been determined yet, so the script should be compatible with Microsoft Word 2016, 2019, and 365.

...exe program but will need to be triggered using a Windows batch command or VBA. Original source txt file is built from an excel worksheet, so an alternate solution can be building files as described via excel VBA from existing excel spreadsheet as long as it includes a PUT command to the FTP location for all built files. Ideal skills for this project include: - Proficiency in writing Windows batch files. - Excel VBA. - Experience with file handling and FTP in a Windows environment. I have an FTP location and credentials ready. Files should retain the original filename with a numeric suffix (e.g., , ). Will supply example of full source file and/or original excel file for a VBA solution. The header in the source file is a single line. The batch file shoul...

My macros are not functioning on my Mac and I need an expert to troubleshoot this for me. Ideal candidates for this job should have: - Deep understanding of Excel VBA - Experience with Mac versions of Excel - Problem solving skills to troubleshoot why macros aren’t running and resolve code, where required branch code into mac or pc subs/functions.

I need a skilled Excel VBA programmer to assist in automating tasks in my Excel workbook. The primary task involves sending data from a user form to the relevant worksheet. Key Requirements: - Proficient in Excel VBA - Experience in Excel workbook automation - Ability to organize data by category in the relevant worksheet. The ideal freelancer for this project should have a strong background in automating tasks using Excel VBA and can efficiently categorize data in Excel worksheets.

I am seeking a skilled VBA developer to help automate the generation of financial reports in Excel. Ideal Skills and Experience: - Proficiency in VBA with extensive experience in Excel automation - Prior experience in automating financial report generation is a plus - Strong attention to detail and ability to understand complex financial data

I need a professional Excel expert with strong skills in data analysis, macros, and VBA. You will be required to create a sophisticated Excel spreadsheet for analyzing trading data. Key Responsibilities: - Create an advanced Excel spreadsheet for trading data analysis - Incorporate real-time data updates into the spreadsheet - Implement advanced charting and visualization techniques - Design automated trading signals within the spreadsheet Ideal Skills: - Excel: Advanced spreadsheet creation and optimization - Macros and VBA: Proven experience in automating tasks and enhancing workflow - Python: Familiarity with Python for data analysis and Excel integration would be a big plus. Payment: - The designer will be compensated on a daily basis, with payment based on the number...

I am looking for a VBA expert who can develop a solution for generating detailed reports from Excel files for my business case. The primary objective of this project is to automate the report generation process, making it more efficient and less time-consuming.

I need an experienced Excel VBA programmer to modify my VBA Code macros. The job involves enhancing an Excel form and including a 'modify' function. Modify "Agency" file to be like "Testttt" file and include the Modify button. Key requirements: - Modify an existing Excel form - Include a 'modify' function in the form - Improve the overall performance of the form The ideal freelancer would have: - Extensive experience in Excel and VBA - Ability to optimize data modification processes - Skills in designing user-friendly forms The project also involves changing some aspects of the form's appearance: - Removing some fields from the form - Changing the layout of the form The successful freelancer will be able to deliver a w...

I'm in need of a proficient VBA CorelDRAW programmer for the 2024 version. My project involves creating a VBA script that generates QR codes within a specific template of a certain size. The script should also arrange these QR codes for printing on various printer sizes, specifically a custom size of 48x96 inches. Ideal candidate should be skilled in: - CorelDRAW and VBA - Understanding of QR code generation - Experience with custom printer size arrangements - Ability to work with specific size templates (small, medium, large)

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points f. Co...

...all extracted data is neatly organized and formatted for easy access within Excel. Provide clear, user-friendly functionality to paste or upload listings and automatically trigger the data extraction process. Skills Required: Strong experience with web scraping or API integration to pull data from Zillow, Redfin, StreetEasy, and other platforms. Proficiency in Excel automation, preferably with VBA or Python (pandas, openpyxl) to integrate the data extraction functionality. Familiarity with Zola NYC and NYC Open Portal to access zoning and building-related data. Knowledge of real estate terminologies and zoning regulations in NYC. Experience with data validation to ensure accurate and reliable data extraction. Ability to work autonomously and deliver high-quality, maintainable co...

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

I'm seeking an Excel expert who can help me code a MACROS to automate a process in Excel. The task involves analyzing employee data and generating results related to loans and other similar dat...process in Excel. The task involves analyzing employee data and generating results related to loans and other similar data entries. Key Responsibilities: - Develop a MACROS script to automate data analysis on employee data. - The macro should be able to provide results for specific data entries related to loans and other similar metrics. Ideal Skills and Experience: - Proficient in Excel and VBA programming. - Prior experience in developing Excel MACROS for data analysis. - Understanding of employee data metrics. - Able to deliver efficient and effective solutions for data processin...

I'm seeking a proficient Excel developer with strong skills in VBA and Macros. The job involves creating an automated workflow to transform data from a single Excel file into three separate files. Key Tasks: - Importing data from one Excel file - Creating three files using VBA and Macros - Data cleaning - Data merging - Data filtering The data filtering will involve: - Applying numerical ranges - Text matching - Date ranges Ideal candidates should have a robust understanding of data transformation processes and extensive experience with Excel VBA and Macros.

Bonjour, nous avons deux fichiers Excel comprenant deux colonnes comportant des codes postaux français : colonne C "CP départ" et colonne D "CP arrivée". Nous avons besoin que dans la 3e colonne "Distance en KM" vous trouviez via google ou par VBA Excel la distance en KM entre ces deux codes postaux. Exemple ligne 2 du fichier "Tri 2024" : CP départ 54710, CP arrivé : 28500, distance en km : 408 km

Description: I am looking for a skilled developer to help deploy an existing solution that automates Word document text replacement using VBA and outputs a PDF file. I already have a fully functional VBA code and an HTML interface to generate the code. The project involves using this existing logic and expanding it to work seamlessly on a server-based environment. Key Requirements: PDF Output: The system should take user inputs through the existing interface (or an upgraded version) and automatically replace the specified keywords in a Word document. Once the replacement is complete, the system should generate and provide the user with a downloadable PDF file. Database Integration: Create a database to store keywords used for replacement. Provide an option to select prev...

I'm seeking an Excel expert who can help me with a project needing to build a client pipeline excel sheet which provides the ability to multi select checkboxes from a drop down for certain columns. Also need to have the checkboxes grouped under a heading with indentation/ categorization The project requires the development of advanced macros and VBA scripts. Ideal Skills: - Extensive knowledge of Excel - Proficient in writing complex VBA scripts - Experience in creating advanced macros Key Responsibilities: - Develop an excel sheet with certain columns having the ability to list checkboxes and support multi selection. - this drop down multiselect checkbox list also will be categorized under a few main parent checkbox - upon multi selection and pressing ok, the values ...

I'm looking for a skilled Excel VBA expert to create a macro that converts data from my Excel file into PDFs and sends them to multiple email addresses. The Excel sheet has several tabs, each corresponding to a different group of recipients. Key requirements: - The macro should be able to handle 4 or more separate groups of recipients, as per the different tabs in the Excel file. - Email addresses are provided in a comma-separated list format. - Each tab contains sales reports that need to be converted into PDFs. Ideal candidates should have: - Extensive experience with Excel VBA and macro programming. - Previous work with automating PDF conversion and email sending from Excel. - A strong understanding of handling and sorting data for different groups. Please note, th...

Create a Word document linked to populated Access tables. The project involves inserting data via bookmarks & VBA into a Word Template document that outputs a new Word report. This output report should have no bookmarks or VBA while maintaining the required table and text formatting & styles.

I am a project manager handling diverse projects and need a professional Excel dashboard to track and manage my work efficiently. The dashboard should provide a clear, user-friendly interface and visual insights to monitor progress, timelines, budgets, and key metrics for the following: CSR Fund Tracking: Monitor inflows, outflows, and utilization of CSR...components like charts, graphs, and summary tables for easy tracking of progress, KPIs, and pending tasks. User-friendly interface to import/export data and make updates seamlessly. Sections for tracking timelines, budgets, and overall project status. Deliverables: A fully functional, customizable Excel dashboard with instructions. Source file in Excel format. Freelancers with expertise in Excel, VBA, and data visualization are ...

...semplificare e velocizzare il processo di inserimento ordini riducendo gli errori manuali. Requisiti chiave: - Esperienza con SAP SuccessFactors e integrazione con Microsoft Outlook. - Capacità di creare macro o strumenti di automazione personalizzati. - Comprensione di come leggere e processare dati da file PDF. - Forti competenze in programmazione, preferibilmente con conoscenze di linguaggi come VBA, Python o simili. - Buona comunicazione e attenzione al dettaglio per garantire che il tool sviluppato rispetti le specifiche richieste. Responsabilità: - Analizzare i requisiti e proporre la migliore soluzione per l'automazione. - Sviluppare e testare la macro o il tool per assicurarsi che funzioni senza intoppi e in modo affidabile. - Fornire documentazione e...

I require an experienced VBA programmer to write a script for my Office 365 Excel workbook. The task is to automate the printing process of a specific worksheet based on a cell value in the 'Component Index' worksheet. Key Requirements: - The 'Component Index' worksheet contains the cell value that determines the number of pages to print. - The script should allow for changing the name of the workbook without interrupting the print process. - The automation should seamlessly integrate with Excel's regular print button. The ideal candidate for this project should be proficient in VBA programming and have extensive experience with Excel 2019 and Office 365. Knowledge of Excel's print processes and handling of workbook events is crucial. Please ...

I need a skilled VBA programmer to help me add a macro to my existing Excel file. The macro needs to automate some of my repetitive tasks, specifically: - Data entry: I want to streamline the process of inputting data into the spreadsheet to save time and reduce errors. - Data analysis: I need assistance with automating some basic analysis to derive insights from the data. The data for these tasks will primarily come from user input within Excel. Ideal skills and experience for this job include: - Proficient in VBA programming with a strong portfolio of Excel automation projects. - Excellent understanding of data manipulation and analysis within Excel. - Ability to work with user-generated input and create a seamless automation experience. I'm looking for someone ...