Vba exel projectproiecte

I'm seeking a highly skilled Excel professional to help me with an Arabic Excel file. The project primarily involves: - Automating tasks with VBA: I want to streamline our processes, so your VBA expertise will be key to helping us work more efficiently. - Data cleaning and transformation with Power Query: The data we have is not entirely clean, so your experience with Power Query will be vital in preparing our data for analysis. This Excel file is primarily for business use, so a strong understanding of inventory data is beneficial. The ideal candidate will be fluent in Arabic and have extensive experience working with Excel, Power Query, and VBA.

I'm in need of a professional who can help debug our existing VBA program that interfaces with our internal Excel database. The original creator of the program has passed away, and we're currently trying to get it to work without any expertise in VBA. Ideal skills and experience for the job include: - Proficiency in VBA and Excel - Experience in debugging and troubleshooting complex programs - Ability to explain technical concepts in a simple, understandable way - Patience and understanding working with a team with limited technical knowledge

create analysis in power bi and VBA for a company the analysis will include report for weak point and strengths needed to improve prefomance

### Description: I have an Excel file with a scatterplot chart located on the "Graph" sheet. This chart is powered by the worksheet "Calculation" and contains VBA code and ActiveX form controls. I need this functionality replicated online with the following requirements: 1. **Interactive Scatterplot Chart:** - The scatterplot chart should display on a publicly accessible webpage. - Users can interact with dropdowns and selection boxes to customize axes and data shown dynamically. 2. **Multi-User Support:** - Multiple users should be able to access the "Graph" sheet simultaneously. - Each user should have their own settings defined by the dropdowns and selection boxes, without interference with other users' sessions. 3. **B...

I'm looking for an expert in VBA Macro Or Python to create a dynamic script that will inject a specific row of data into my dataset. Dynamic VBA Macro or Python Code To Do the below : Inject a row of data structured as follows Coulmn 1 include a reference number, Column 2 include a company names, Coloumn 3 include prices, Coloumn 4 Include results. Attached Photo show an example, Note the row data are almost 10K Rows.

Tenho ums sitema proprio utilizando apenas a linguem vba e o banco de dados acces, atualmente emito nfce e nfe atraves do site do sebrae, mas quero automatizar utilizando apenas o vba e o openssl para a assintura digital para conseguir automatizar o processo. entao o que estou tentando fazer éutilizar um modelo de xml , editando os dados e adicionando os dados de mais itens conforme necessario, assinado digitamente atraves do openssl (isso eu ja tenho pronto, ja consegui estrair os dados e as sub que fazem este processo), falta a estruturação do xml e validação junto a asefaz.

In Microsoft Access database, I need some VBA to attach 3 forms to 3 SQL queries that already exist. I've started the forms, but they are not complete. Each query requires input from the user. I want the input to be captured on one form with the input fields required. On click of the button causes an Event that triggers the SQL with using the data input from the form. Key Requirements: - User Input: dropdown menus, checkboxes, and text fields. - Dropdown Menus: 3 or more dropdown predefined. - Event Triggering: SQL query using the data input from the form. Skills and Experience: - VBA - Microsoft Access - User-friendly forms - SQL (not required, but could be helpful)

Busco un profesional con experiencia en VBA para Excel que pueda desarrollar un macro que procese múltiples archivos XML de comprobantes electrónicos de Ecuador (facturas, retenciones, notas de débito y crédito), genere reportes en Excel y convierta los XML a archivos PDF con formato legible. Requerimientos: Soporte para múltiples tipos de comprobantes electrónicos: Facturas. Retenciones. Notas de débito. Notas de crédito. Reportes a generar: Reporte General: Totales y subtotales de cada tipo de comprobante. Reporte Detallado: Listado detallado de los ítems comprados o servicios adquiridos. Conversión a PDF: Convertir los comprobantes electrónicos (XML) a archivos PDF con formato legible. Personalizaci...

I'm seeking a VBA expert to help me extend my current data collection project. The task involves: - Collecting soccer fixtures from Coral, including odds for home, draw, away, over/under and both teams to score markets. - Integrating this new data into my existing Excel file, which currently collects the same data from two other sports websites. The data from Coral is similar to the other sites, so no special handling is required. The ideal freelancer should have extensive experience with VBA and data collection, as well as a keen attention to detail.

I need an expert in Excel VBA to create a tool for me. Requirements: - Import specific row fields from a CSV file. I need to import Names and Addresses, Product IDs and Descriptions, Dates and Amounts, and other general things. - The import should be triggered by a menu option in the Excel toolbar. - There should be a print button to print the new sheet with the imported contents. Ideal Skills: - Proficiency in Excel VBA. - Experience with CSV file manipulation in Excel. - Ability to create custom toolbar options in Excel.

I'm seeking a professional with extensive experience in MS Access to assist me in creating a robust database. Ideal Skills: - Proficiency in MS Access - Experience in database design and creation - Strong understanding with data analysis, query building This is an urgent task, please bid if you are available to support immediately. Communication in English is must.

I need an Excel macro developed that can extract digital signatures from multiple PDF files and record them in an Excel file. The PDFs I am working with are digital PDFs with selectable text this files are saved in Microsoft one drive. Requirements: - The macro should capture the sign...file. The PDFs I am working with are digital PDFs with selectable text this files are saved in Microsoft one drive. Requirements: - The macro should capture the signer’s name and the time and date of the signature - The data should be organized in Excel with one row per document, and all signatures from that document in separate columns. Ideal Skills and Experience: - Proficient in Excel and VBA programming - Experience with PDF data extraction - Strong attention to detail to ensure accurat...

...PowerPoint, and VBA programming. My goal is to create a PowerPoint macro that automatically generates a slide for each participant of a course, inserting their name and course date from an Excel file. Project Details: - Software: The project will be conducted using Microsoft 365. - Data Source: The macro will pull data from an Excel file, specifically participant names and course dates. - Template: I have a specific PowerPoint template for the slides; the freelancer will be provided with this template. Key Requirements: - Advanced knowledge of Microsoft 365, particularly PowerPoint and Excel. - Proficiency in creating and implementing macros. - Experience with VBA programming. - Ability to work with provided templates. Please note, my focus is on the func...

Highlight cell based on instruction sheet.

I have an Excel macro that needs updating. It currently processes text strings and I need it to add zeros to the beginning of each string to even out their lengths. Ideal skills for this project include: - Proficiency in Excel, particularly with macros - Strong programming skills, preferably in VBA - Experience with data manipulation, specifically with text strings Please bid if you have the relevant experience and can complete this project in a timely manner.

I need a VBA script that pulls historical stock data and option data from Google Finance into Excel. Requirements: - Historical stock data should include Adjusted Close prices. - Option data should include: Strike price and expiry date, Volume and open interest, Implied volatility. Ideal Skills: - Proficiency in VBA - Experience with data extraction from Google Finance - Knowledge of stock and option data parameters Please provide examples of similar projects you've completed. Thank you!

As discussed, VBA and form .

I'm seeking a professional with extensive experience in ERP development and Excel to create a standalone, Excel-based ER...ERP system for my business. The system needs to manage three key areas: - Inventory Management - Financial Accounting - Human Resources Key requirements: - The ERP system will be standalone and does not need to integrate with existing software. - User access control should be basic, with only Admin and User roles. Ideal skills for this project include: - Proficiency in Excel, particularly with advanced features like macros, pivot tables, and VBA. - Experience in developing standalone software. - Knowledge of ERP systems and their functionality. - Understanding of basic User Access Control systems. Please provide examples of similar proj...

I've developed a VBA template that needs thorough usability testing and improvements. The testing should focus on the user interface design, ease of navigation, and error handling. Additionally, I would like a review of the VBA codes to enhance code efficiency and debug any issues. I will message you on more details.

Employee Uniform Ordering System Objective: Create a system for employees to order uniforms and an admin dashboard for managing orders. Deliverables: 1. Order Form (Google Forms/Excel) with dropdowns for uniforms and sizes. 2. Admin Dashboard (Google Sheets/Excel) with order summaries and charts. 3. Aushang Design with QR code Skills Required: • Google Forms/Sheets or Excel with VBA • Data Visualization • UI/UX Design • Graphic Design

Creating a reporting template in Excel with VBA

I'm looking for a VBA expert who can help me with data analysis and reporting using Excel. The main focus will be on data visualization. The ideal freelancer should be able to: - Automate tasks in Excel using VBA - Create custom functions or tools tailored to my data analysis needs - Design and implement effective data visualizations The data will primarily be sourced from Excel spreadsheets. Previous experience with data visualization in Excel is crucial, as is a strong understanding of VBA. It is a secret code game for family fun, not for resale. I will provide 11 lines of letters maximum 400 in each line. Lines 1 to 11. I need a dialogue box with. A multiplier selection box whereby I can put in a number from 1-400 coinciding with the letter in each cell fo...

Tôi muốn thiết lập 1 bảng lãi suất tham chiếu theo lãi suất có sẵn, theo công thức của bên tôi. Nhờ các bạn lập giúp tôi và dạy tôi cách lập.

I need a VBA expert to create a Word/VBA/macro which turns selections in a Word document into dynamic hyperlinks. Background - Valid links start wit-h [aA] followed by numeral's A1683123/ A1686786  A916753 A916753 more text A916753 more text - VBA convert a to A - Anchor:=r1, Address:= _ "url:objective://id:" + RTrim() + "@", SubAddress _ :="", ScreenTip:="", TextToDisplay:=RTrim() - The issue is, in word, sometimes double clicking "A916753" will select "A916753 ". The hyperlink cannot contain the space. The hyperlink and display text, must only contain the valid text "A916753". Below is code that doesn't really work: Dim r1 As Range Dim str1 As String Dim ...

I need a skilled Excel VBA programmer to enhance my current Excel workbook with new macros. The primary aim of these macros is to automate data entry tasks, specifically dealing with text data. Your responsibilities will include: - Modifying existing macros or creating new ones to facilitate the automation of data entry - Ensuring the macros can handle various forms of text data effectively Ideal candidates should have: - Proficient experience in Excel and VBA programming - Previous experience in creating or modifying macros for data entry purposes - Excellent understanding of handling text data within Excel Please provide examples of similar projects you've worked on, and your approach to tackling this task.

...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...

necesito obtener datos a diferentes hojas de excel desde la base de datos en msql de mi pagina web, tengo avances que funcionan hasta cierto punto, necesitan ajustes para lograr lo esperado.

Description: I need VBA and Excel automation expertise to integrate a new productivity KPI into an existing report. The POS vs. Opportunity report already contains automated VBA scripts and formulas, so this task requires enhancing the functionality without disrupting the existing structure. Project Overview: Integrate a Productivity KPI: Track registrations completed per team member and calculate registrations per hour. Data Source: Supervisors maintain a separate daily registrations report (Excel). Goal: Combine this KPI seamlessly into the current POS vs. Opportunity sheet. Requirements: Add columns for Registrations Completed, Hours Worked, and the calculated Productivity (Reg/hr). Maintain the current VBA automation and ensure no int...

I'm seeking an Excel professional to update an old worksheet. The task involves: - Adju...Optimizing existing formulas to improve performance - Generating visualization charts for better data representation - Automating routine tasks using VBA or macros - Updating cell formatting for consistency and readability - Linking to external data sources for real-time updates Ideal candidates should possess: - Proficient Excel skills - Experience with custom formulas - Strong data entry and correction abilities The task should be quick for an expert. The new data entries will be provided by me. Please include bar and line charts for the data visualizations. Include automation or macro integration as part of the updates. The deadline for this project is "no deadline."...

I'm in need of a skilled programmer who can create an Excel VBA plug-in for me. The primary function of this plug-in will be to detect user actions within Excel and display selected messages on the top corner of the screen. Ideal skills and experience for the job include: - Proficiency in Excel VBA programming - Experience in developing Excel plug-ins - Knowledge of creating and linking macros to buttons Please only apply if you can deliver a high-quality, efficient solution.

I'm in need of a macro for Outlook that can facilitate the downloading of attachments from a selected batch of emails. Key Requirements: - Manual selection by the user to determine which emails to download from. - Post-download, the emails should...can facilitate the downloading of attachments from a selected batch of emails. Key Requirements: - Manual selection by the user to determine which emails to download from. - Post-download, the emails should be moved to a specific folder. - All file types from the email attachments should be downloaded. Ideal Skills and Experience: - Proficiency in creating macros for Outlook. - Familiarity with VBA (Visual Basic for Applications). - Previous experience with email automation tasks. - Attention to detail to ensure all attachments ...

I need a VBA script that can extract specific data from my Outlook emails into an Excel spreadsheet. The data to be extracted includes the sender, subject, received date, received time, whether it's a new or follow-up mail, and if it's a follow-up, when the first revert on that mail was and when the last received mail was. Key Requirements: - The script should filter emails based on a specified date range. - The script should be able to extract data from both new and follow-up emails. Ideal Skills: - Proficiency in VBA programming. - Experience with Outlook automation. - Strong understanding of Excel. Please provide examples of similar projects you've completed in your proposal. The script should be run on a daily basis. The extracted data should be appende...

...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...

...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...

...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...

...professional with extensive experience in Excel and VBA programming to create two specific macros in my Excel 365 file. Task 1: - The first macro needs to process data by removing all spaces and special characters, while also converting all letters to lower case. It’s crucial that this macro retains leading zeros. For instance, the value '075 667 854' should be reformatted as '075667854'. - Furthermore, this data needs to be formatted as text. Task 2: - The second macro should identify numbers that appear in more than one cell in column A. - These repeated numbers should be placed in column B, with numbers that occur more than once being separated by a comma and a space. Ideal candidates for this project should have: - Proficiency in Excel ...

I'm looking for a seasoned Excel developer to create a macro that can sort and filter mixed data (both numeric and text) effectively. The macro should be able to fetch data from another spreadsheet. Ideal Skills: - Proficient in Excel VBA - Experience with data sorting and filtering - Ability to create efficient macros for repetitive tasks Definition: I have an Excel spreadsheet with Columns A-C, which can be seen in the Example.png. In the current format, the part level doesn't exist, so I created and colorized Columns J-M manually to show my need. But I want a macro to do this format automaticity

...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...

...with extracting production data from a plain text email into a custom structured Excel file. The ideal freelancer for this project should have: - Proficiency in Excel - Attention to detail - Experience with data extraction and organization. - Experience with scripting languages like Python or VBA. Please ensure you can work to a custom structure before bidding. The data volume is small and manageable. The Excel file needs to be updated with new data from emails weekly. The emails containing production data will be from an Outlook account. The data extraction process should be fully automated to update the Excel file weekly. The preferred method for automation is a VBA macro. The Excel file requires special formatting for certain fields. Special formatting include...

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.

...source for this project will be our cash flow data. - Calculations: I need the cash flow data to be analyzed in terms of comparing actual figures against our budgeted amounts. - Final Report: The completed report should be presented in an Excel sheet. Ideal candidates for this project should have: - Extensive experience working with complex Excel data - A strong understanding of BOQ and contract data - Excellent skills in financial data comparison - Ability to deliver a clear, comprehensive Excel report. - Proficiency in advanced Excel functions such as VLOOKUP, HLOOKUP, and INDEX MATCH. - Ability to clean and prepare data for analysis, ensuring accuracy and consistency. - Experience using pivot tables for dynamic data presentation and analysis. - Knowledge of macros and ...

I'm looking for an Excel expert to create a macro that helps me update my Bill of Quantities (BOQ) using an old list of glass panels. The goal is to efficiently identify and compare reusable materials. Specific Tasks: - The macro should identify reusable glass panels. - It should compare entries f...Tasks: - The macro should identify reusable glass panels. - It should compare entries from the old and new BOQ. - Finally, it should generate a report detailing usable materials. Report Structure: - The output report should be structured in an Excel spreadsheet. Data Format: - The old glass panels list is currently stored in an Excel spreadsheet. Ideal Skills: - Proficient in Excel macros and VBA. - Experienced in data comparison and reporting. - Able to deliver a well-structure...

I'm in need of an Excel developer who can help me automate repetitive tasks using macros. Ideal Skills: - Proficient in Excel, especially in creating and implementing macros - Strong problem-solving skills - Attention to detail - Previous experience with Excel automation - Advanced knowledge of VBA programming - Experience in data analysis with Excel - Ability to create and manage user forms - Skills in creating charts and graphs for data visualization - Proficiency in implementing error handling in macros - Experience integrating Excel with other software - Skills in optimizing macro performance - Ability to create macros for batch processing tasks Please note, the specific repetitive tasks to be automated are yet to be determined, so flexibility and a broad understanding o...

I'm looking for an Excel VBA expert to help me automate the process of populating a new sheet from an existing one. This project will focus on generating reports based on production data. Key Requirements: - Proficiency in Excel VBA - Experience in data handling and report creation - Familiarity with production data is a plus The existing sheet contains specific data fields that I want to include in the report. The new sheet will be used for report generation. Please note that the ideal candidate should be able to work with a pre-defined set of data fields.

I'm looking for an Excel expert to develop a production tracking spreadsheet. This will involve tracking specific Key Performance Indicators (KPIs) and automating data transfer to other spreadsheets using VBA. Key aspects of the project include: - Tracking KPIs: The spreadsheet should monitor production volume, as well as production and revenue per square foot by each harvest cycle. - Creating a Gantt Chart: A calendar or Gantt chart to visualize the production timeline is also required. Ideal skills and experience for this job: - Advanced Microsoft Excel skills, particularly with VBA and macros. - Experience in creating tracking spreadsheets. - Ability to create visual aids such as Gantt charts. Please provide a brief overview of similar projects you've ...

Create a VBA in excel to export an organization's structure from Excel to PowerPoint. Propose your template or format in Excel. Export aditional fields in excel to powerpoint as shown in the example attached. The presentation can follow a generic minimalistic style.

I'm looking for an Excel VBA whisperer to help enhance my productivity. Key Tasks: - Creating custom functions in Excel to meet specific needs - Automating data entry and clean-up tasks - Streamlining the process of importing and exporting data from/to CSV and Excel files - Debugging and resolving issues in existing VBA code Ideal Skills: - Proficient in Excel and VBA programming - Experience with creating custom Excel functions - Strong understanding of data entry and clean-up processes - Familiarity with CSV/Excel file handling

I'm looking for a skilled VBA expert to help me automate data entry and manipulation in Excel. Key tasks include: - Sorting and filtering data - Data validation and cleaning - Merging and consolidating datasets Please note that I will be running the VBA code manually, so it does not need to run automatically based on certain triggers. Ideal candidates should have: - Strong knowledge and experience in VBA and Excel - Proven track record in automating data entry and manipulation tasks - Excellent problem-solving skills - Attention to detail Please include examples of similar projects you've completed in your bid.

Înregistrează-te sau Conectează-te pentru a vedea detaliile.

...(Advanced Reconcilition, not a basic bank recon) Key Requirements: - Proficient in accounting principles and practices. - Advanced Excel skills with experience in creating macros. - Able to complete the project within a 7-day timeframe. - Experience with VBA programming for advanced Excel macro creation. - High attention to detail to ensure accuracy in reconciliation. - Knowledge of data security best practices to safeguard sensitive financial information. - Proven track record of successful bank reconciliations. - Strong analytical skills to identify and resolve discrepancies. Task Details: - The project will primarily be executed in Excel. - I need the macros to specifically automate the bank reconciliation process. - The reconciliation report should be detailed...