Vba exel project일자리
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
CREATE DATA BASE AND PROJECT WITH POWER BI ANALYSIS PROJECT WILL BE 1 DASHBOARD + 1 VBA CODE TO COLLECT DATA + ANALYSIS REPORT
Multiple analytical works and updating of codes and VBA
I'm looking for a skilled Excel VBA programmer to create a script that will automate the process of copying and pasting data from multiple emails in a specific Outlook folder into an Excel worksheet. Key Requirements: - The VBA code should be able to handle multiple emails, efficiently copying and pasting the relevant data from each. - The code needs to target emails located in a specific folder in Outlook, so familiarity with Outlook's structure and VBA's capabilities in interfacing with it is crucial. - The data from the emails should be pasted into the Excel worksheet in an organized manner. Ideal Skills: - Proven experience with Excel VBA programming - Familiarity with Outlook and its folder structure - Ability to write clean, efficient, and well-...
I'm seeking a skilled Excel VBA programmer to create a macro for me. The primary function of this macro is to send automated email reminders based on due dates in my spreadsheet. Key Requirements: - Automate email Notifications: The macro should send out reminders as deadlines approach, helping me stay on top of my tasks. - Data Validation: The macro should also check for missing data in my Excel file and notify me accordingly. Ideal Skills: - Proficiency in Excel and VBA - Experience with creating macros for email automation Thank you!
I'm in need of a skilled Excel VBA developer to create a macro that transfers numerical data from one Excel workbook to a second one on a daily basis. The macro should be designed to bring over all data from the source workbook. In addition, I would appreciate written instructions on how to recreate the macro in the event of a break. This project requires a clear understanding of Excel, VBA programming, and the ability to write clear and concise instructional material. Must speak good english as best we do a zoom / teams meet to review workbooks.
Project Title: Bank NEFT Challan Description: We are seeking a freelancer to build a banking NEFT challan for paying bulk transfers and payrolls in Excel Macros. Ideal Skills and Experience: - High level excel macros and VBA experience is required... Project scope: Prepare a banking Neft challan for bulk transfers and payrolls. 1. A database for vendor banking details ( infinite data feed required) 2. A database for employee banking details (infinite data feed required) 3. A payroll database , ( considering attendance , ESI & PF calculations, Salary advance, other deductions, Allowances, HRA, Salary) 4. Banking NEFT challan for vendor - button for creating print page in A5/A4 data on a company letter head based on data size 5. Banking NEFT challan for ...
...and contractors, and support client management. Work independently on tasks such as document creation and organization using G-Suite, Microsoft Office (Word, Excel, PowerPoint). Organization and Reliability: Stay organized, meet deadlines, and provide dependable support with minimal supervision. Additional Expertise (Preferred but not required): Experience with SuiteDash, advanced Excel (e.g., VBA, financial modeling), QuickBooks, Etsy, web design, and graphic design is a plus. Requirements: Language Skills: Excellent verbal and written communication in English. Proficiency in additional languages (e.g., Spanish) is a plus. Tech Skills: Proficient in G-Suite, Microsoft Office, Canva, and social media platforms. Reliable internet connection for seamless communication and ...
I'm looking for an Android-based mobile application to load jobs in our maintenance logbook and a Windows desktop management to manage o...assigned Job Numbers and Dates. - Staff inputting data such as issue descriptions, locations (from a dropdown list), their names (from a dropdown list), estimated and actual completion dates (using a date picker), maintainer's names (from a dropdown list), and notes (in a text box). - A checkbox for staff confirming job completion. Ideal skills for this project include: - Mobile application development, specifically for Android - excel development in VBA - Experience with creating user-friendly interfaces - Familiarity with integrating applications with OneDrive - Knowledge in using dropdown lists, date pickers and check buttons...
Hi there - I'll deliver the file as we've discussed by VBA in Excel. Thanks for your trust!
I'm in need of a bot that can take info from an Excel spreadsheet and cross-reference it with another spreadsheet to calculate job pricing. The bot needs to handle: - Mixed data: The spreadsheets will contain both numeric and text data. The bot should notify me by: - Directly updating a new spreadsheet with the calculated job pricing. The bot should perform the tasks: - On-demand: I should ...notify me by: - Directly updating a new spreadsheet with the calculated job pricing. The bot should perform the tasks: - On-demand: I should be able to trigger the calculations whenever needed. Ideal skills for the job include: - Proficiency in Excel and understanding of spreadsheet functions. - Experience in creating automation bots for Excel. - Programming skills, preferably in Python...
I'm looking for a VBA script that will help me manage my schedule more efficiently. The script should take a list of appointments from an attached file and do the following: 1. Insert the appointments into my Outlook calendar according to the specifications in cell B3. 2. Send the appointments to the email addresses listed in column M. The script should be set to run manually, not automatically. I also need assistance deciding on the format for the email notifications. The options are Plain text, HTML, or Rich text. Ideal skills for the job include: - Proficiency in VBA - Experience with Outlook - Knowledge of email formatting Please let me know if you need any further information to give a bid.
Multiple analytical works and updating of codes and VBA
I'm seeking an expert in financial analysis to assess our operational efficiency using historical data. The primary goal of this evaluation is to inform our performance review processes. Key Requirements: - Proficient in Excel, including Excel VBA for complex data manipulation - Experienced in Business Analysis and Data Processing - Able to present findings compellingly using PowerPoint - Skilled in developing pragmatic Business Plans based on the analysis The focus of this project is to evaluate our operational efficiency through specific financial metrics. A deep understanding of performance evaluation techniques is crucial. Please only apply if you can deliver high-quality analysis and clear, actionable insights.
I'm looking for a VBA expert to create an automation script for me. The script needs to perform the following tasks: - Open a SharePoint Excel file (Excel1) from online and copy a specific Excel sheet to my local drive. - In a local file (Excel2), delete 3 specified columns and copy all rows except the header row to the clipboard. - Open another SharePoint Excel file (Excel3) from online and paste the clipboard information. This project requires a deep understanding of VBA and experience with SharePoint PnP PowerShell. Familiarity with Office 365 is also essential since that's the version of Excel I'm using. Please, bid only if you can meet these requirements.
I need a proficient Excel expert who can modify an Excel sheet with macros created by a previous employee. The job entails adding new features, correcting existing issues, and updating the data. Key tasks: - ...proficient Excel expert who can modify an Excel sheet with macros created by a previous employee. The job entails adding new features, correcting existing issues, and updating the data. Key tasks: - Add new calculations and formulas - Set up automated reports - Fix incorrect calculations - Troubleshoot and rectify data updating issues Ideal skills and experience: - Strong proficiency in Excel and VBA - Experience in creating and modifying Excel macros - Ability to set up automated reports - Aptitude for accurate calculations - Problem-solving skills for troubleshooting d...
Hi all, Tôi cần viết 1 phần mềm quản lý sản phẩm, tồn kho. Hiện tại bên công ty tôi đang có 1 danh sách ~10.000 sản phẩm file Exel (mã sp, tên sp, mô tả, kích thước, hình ảnh sp, nguyên liệu) Và giờ tôi cần đưa danh sách sản phẩm đó lên phần mềm để quản lý. Yêu cầu : Nhập sản phẩm tự động bằng cách upload file Exel, lấy hình ảnh trực tiếp từ file exel (tự động thêm Watermask logo công ty, và kích thước vào hình ảnh sản phẩm) - Đơn giản, dễ sử dụng, có thể dùng mã nguồn mở hoặc tự viết đều được Thank!
I'm looking for an experienced Excel VBA developer to create a custom Customer Relationship Management (CRM) add-in for Excel. The add in should provide licence validation similar to XL padlock - https://www.xlspadlock.com. Also when validating the license each time the product is used, it should save the current copy to a cloud based location that can accessed by the user from our website. Each validation should also provide any feature updates from the latest template in a cloud location. Key Features of the CRM Add-in: - Comprehensive Customer Data Management: The add-in should allow for efficient management of customer information, including but not limited to contact details, purchase history, and customer interactions. - Robust Sales Tracking: The add-in should include ...
...Expertise in project management (ideally with a PMP certification or equivalent). • Strong proficiency in Microsoft Excel, including advanced formulas, pivot tables, macros, and VBA. • Experience in developing Excel-based tools for complex projects. • Understanding of construction projects and their unique requirements. Expected Deliverables: • A practical and intuitive Excel-based tool that allows: • Budget planning and tracking based on WBS, tasks, and activities. • Monitoring expenses against the budget. • Generating clear and customizable reports directly in Excel. • Comprehensive documentation explaining the tool’s functionality and usage. Selection Criteria: • Proven experience creating advanced Excel tool...
Option Explicit Type Authvalinterval Lower_Val As String * 40 Upper_Val As String * 40 End Type Type AUTHVALINTERVAL_TAB wert(1 To 10) As Authvalinterval End Type Type AUTHFIELD_VALS fieldname As String * 10 fieldvals As AUTHVALINTERVAL_TAB End Type Type AUTHORIZATION_TAB AUTHORIZATION(1 To 10) As AUTHFIELD_VALS End Type Type AUTHORIZATION_FOR_OBJECT xuobject As String * 10 AUTHORIZATIONS As AUTHORIZATION_TAB End Type Global IT_ROLE_AUTHS(1 To 100) As AUTHORIZATION_FOR_OBJECT Global sapSystem As Object Global sapFuBa As Object Global sapLogon As Object Global sapConn As Object Global sapReturn As Object Sub RolleAnlegen() Dim wert As Object Dim rolle As Object Dim sapObjekt As Object If InitConnection Then Se...
I'm in need of a proficient Excel VBA developer to create a high-performance data logger for me. The primary function of this tool is to log data from a wireless barcode scanner, record weight, and convert that weight into quantity. Key Requirements: - The logger must access conversion data from a sheet that could have over 200k lines. - A more efficient version is needed compared to an existing sample I have. The current version is sluggish due to file size. - It should support multiple users on a local network, compiling all results into a single sheet without missing any lines. - The project has a fixed budget, which is not based on hourly rates. Ideal Skills and Experience: - Extensive experience with Excel and VBA, particularly in creating userforms. - Prev...
I'm seeking an experienced Excel professional to create a comprehensive balance sheet for tracking my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required...my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required at this moment, the ability to easily incorporate them in the future would be a significant advantage. Please ensure the design is user-friendly and intuitive. Excel VBA skills could be beneficial for automating some part...
Excel VBA Macro for Data Capture & Email **Job Title:** Excel VBA Developer Needed for Automated Screenshot and Email Generation Task **Description:** We are seeking an experienced Excel VBA developer to create a macro that automates the following tasks: 1. **Country-Based Data Selection**: - Read a country name selected in one sheet (e.g., "CountrySelection" sheet). - Locate the corresponding row in another sheet (e.g., "Data" sheet) where the country is listed. 2. **Dynamic Data Range Capture**: - Identify the relevant row and its associated columns dynamically. - Capture this data as a screenshot or export it as an image. 3. **Email Integration**: - Embed the screenshot/image into the body of an em...
I'm seeking an experienced Excel professional to create a comprehensive balance sheet for tracking my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required...my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required at this moment, the ability to easily incorporate them in the future would be a significant advantage. Please ensure the design is user-friendly and intuitive. Excel VBA skills could be beneficial for automating some part...
I'm looking for a VBA expert to create a macro that connects data fields from Tab 1 (blue-shaded) to corresponding row columns in Tab 2. The two tabs share the same column/field headers where relevant. Key Requirements: - Create a single button macro that generates a new row in Tab 2, based on inputs from Tab 1. - The macro should prompt for confirmation before updating Tab 2. - All fields in Tab 1 should be completed before the update. - The macro should not overwrite existing rows in Tab 2. Ideal Skills: - Proficient in VBA programming. - Excellent understanding of Excel macros. - Able to create intuitive and user-friendly macros. This project necessitates a professional who can write clean, efficient code and ensure seamless operation of the macro. Please in...
I'm looking for a skilled Python developer to create a script in PyCharm for me. The script needs to load a CSV file with specific headings: Brand, Product Name, Price, EAN/UPC/ASIN. Key Requirements: - The s...Output: - The final report should include: Brand, Product Name, Price, and Number of Bought Items. Ideal Skills and Experience: - Proficient in Python and familiar with PyCharm. - Prior experience with web scraping, particularly from Amazon, is a big plus. - Understanding of CSV file handling in Python. - Ability to deliver a clean, well-documented script. Issues i have faced while doing this in VBA: - amazon dont like more than 50 pings to their website - i made it stop once it get the error screen - sometimes no item identified , so i just skipped it as its not pr...
I want to list a product using sp-api in VBA. You must have your own credentials for development
I'm looking for an experienced Excel VBA developer to create a macro that will help me automate repetitive tasks, specifically report generation and data consolidation from my inventory data. Key aspects of the project: - The macro should be able to automate the generation of reports from the data - It should also assist in consolidating data efficiently - The macro will primarily be working with inventory data, so understanding of this type of data will be beneficial Ideal skills for this project include: - Proficiency in Excel and experience in creating macros - Strong understanding of inventory data - Ability to automate tasks efficiently - Experience in report generation and data consolidation
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...
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!
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
