Vba withPekerjaan

I'm seeking an expert in VBA coding, financial dashboard design, and crafting Power BI presentations. This project's focus is to: 1. Develop VBA coding 2. Design interactive and dynamic financial dashboards 3. Create an engaging Power BI presentation The ultimate goal of the dashboard and presentation is to: • Thoroughly analyze financial data • Visualize the company's financial performance in a compelling manner • Present clear and concise financial insights The types of financial data that will be included in the dashboard and presentation encompass: • Revenue • Expenses • Profit/Loss • Cash flow • Budget Ideal candidates possess in-depth experience with VBA, financial dashboards, Power BI, an...

...different parts. PART1: I have an excel file with an "CEL ANNUALE" sheet which shows some personal data and some characteristics of the users of a service. The data is entered into the sheet through a userform called "userform1". The data entered through userform 1 are always recorded in the main "CEL ANNUALE" sheet Among these data are: - an "insertion date" field which concerns the date on which a user was added to the service. - a "resignation date" field which reports the date on which a user concluded the service. In addition to the "CEL ANNUALE" sheet there are 12 other sheets called "CEL 01-24" (which refers to the service status as of January 2024), "CEL 02-24" (which refers to the service ...

I'm in need of an expert in VBA programming and thermodynamics to create a VBA code for vapor-liquid diagrams compatible with Microsoft Excel. The code should be flexible enough to work with any two components. The following skills and experience are required: - Proficient in VBA code in Excel - In-depth understanding of Thermodynamics Key requirements include: - Usage of the Wagner equation - equation for the saturated pressure : p_i^* (T)=exp⁡((Aτ+Bτ^1.5+C^2.5+D^5)/(1-τ))×P_c. - bull point equation P= 1/(y_a/(p_a^* (T_pr))+((1-y_(a)))/(p_b^* (T_pr))) - dew point equation P= x_a p_a^* (T_pb )+(1-x_a)p_b^* (T_pb) - Ridders method to find the right temperature for dew point and bull point - The code must be compatible ...

I'm seeking an experienced freelancer with a strong background in Word automation and document editing. Using the “Account #” as the reference point, I want the highlighted values in the paragraph below to be automatically looked up from the values within Table above. Each quarter the Table above will change in terms of the values in the two right columns, and the number of rows will also change. I would like the paragraph to again automatically lookup the referenced values from the new Table. Expertise in Word automation and document editing is essential for this project. Familiarity with VBA scripts for Word or similar is also very beneficial. The chosen applicant should demonstrate an understanding of Word functions, automation techniques, and ...

I urgently need an expert in Excel VBA who is highly skilled to create a tool capable of storing passwords securely. This task is critical and needs immediate attention. Key Requirements: - Development of an Excel VBA sheet with password storage functionality - Emphasis on security measures: While I skipped the question related to specific security measures, the chosen freelancer should be competent in advising and implementing the most appropriate ones such as data encryption, file password protection or two-step verification to ensure the highest level of safety. Ideal Skills: - Proficiency in Excel VBA - Expertise in data security principles - Knowledge about password storage and encryption - Capability to work under tight deadlines Given the urgency of t...

I'm in need of a skilled freelancer who is an expert in Excel 365 and specifically skilled in VBA automating tasks. The main function of this role includes: - Automating tasks in Excel 365 - Utilizing VBA to generate regular reports - Should work in Windows and Macbook both The ideal candidate for this project has strong experience in using Excel 365, with specific knowledge in automating tasks through VBA. I am especially interested in those who have a proven track record of generating regular reports using VBA. Please include examples of similar work in your proposal.

More details: What subject is the classwork for? vba What is the specific task or problem you need help with using VBA? Creating macros for repetitive tasks What type of macro functions should the script perform? Filtering and sorting data

...regarding Excel VBA. Unfortunately, during my preparation, I encountered difficulties using ChatGPT for the exam, which was not successful. Additionally, I faced a delicate situation when it turned out that I had used a portion of a friend's work to help me, which was noticed by the professor since my friend's name was on the Excel file. I am simply seeking an expert specializing in automating tasks in Excel using VBA. The main focus of this project revolves around automating data entry processes. Here, efficiency and accuracy are paramount. The main responsibilities include: - Automating data entry in Excel using VBA - Enhancing the speed and accuracy of data input - Implementing error-checking measures to ensure data integrity The ideal candidate sho...

More details: What subject is the classwork for? vba What is the specific task or problem you need help with using VBA? Creating macros for repetitive tasks What type of macro functions should the script perform? Filtering and sorting data

I have 8 lines of attached php code working fine and operational. I need help to convert it into MS Access VBA

...updated every second. Example: I will give Seconds to Minutes Interval(30 sec to any Minutes) value is one cell, If i give value in excell cell, It start copy the live data value in Ex: Live data in Col A If give 1 min interval A col value copied into F col if one minutes end A col value again copied in G col G-F value stoted in H col then G col value assigned F col- Repeat this process in Excel VBA I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 175 INR and Good review, Dont expect more I am not big fish. it is difficult job d...

...updated every second. Example: I will give Seconds to Minutes Interval(30 sec to any Minutes) value is one cell, If i give value in excell cell, It start copy the live data value in Ex: Live data in Col A If give 1 min interval A col value copied into F col if one minutes end A col value again copied in G col G-F value stoted in H col then G col value assigned F col- Repeat this process in Excel VBA I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 175 INR and Good review, Dont expect more I am not big fish. it is difficult jo...

We have reports generated automatically on daily basis (i have attached a sample for one day 01/01/2024). You may create other days till end of month by changing the alphabets in "Work ID" accordingly. The aim is to consolidate all the days automatically, with the following conditions. - flexibility to choose which date (i may be asked to focus on certain dates only) - to consolidate only Work Status : Completed - to choose which Work Type accordingly (i could just add/minus in the script itself, as we have LOB 1, LOB 2 etc) - once consolidated, there is need to remove duplicates on Work ID as some cases were added accidently from previous day

I'm looking for a freelancer who can assist me with embedding numeric values in Word text paragraphs. This might require advanced knowledge about document automation, as these values will be looked up from a Table within the same document. Here's a bit more about what I need: - You will need to create a system where the embedded values are updated automatically whenever the source Table changes. This should occur without the need for manual intervention. - I highly value clear, precise work and would like to see detailed project proposals outlining your approach to this task. Expertise in Word automation and document editing is essential for this project. Familiarity with VBA scripts for Word or similar is also very beneficial. The chosen applicant s...

I have a specific ACCDE file that needs expert attention. The required tasks for the freelancer include: - Customization of forms and reports in the ACCDE file. This ACCDE file has forms where users can input the data, I would like to export this data into excel/csv or SQL (whichever is conviniant) - Current challenge is, unable to look at the VBA code or export full columns how in the form. The ideal candidate has extensive experience with MS Access, specifically in the customization of ACCDE files and data exportation. They should have in-depth knowledge of form and report design as well as MS Access to Excel/CSV data migration.

I'm aiming to augment my current Skyline Chart, hosted on Microsoft Excel, by including filter slicers and a timeline functionality. This will provide interactive filtering options, visualize data over specified periods and enhance overall user experience. I'd prefer a freelancer with a strong handle on VBA and data visualization in Excel. You'll be dealing with contract and procurement data, hence, prior experience in this area would be advantageous. Tasks include: - Incorporating filter slicers into the existing Skyline Chart - Adding a timeline which fits the current design - Ensuring both new elements accurately represent contract and procurement data

I need a VBA macro expert to automate repetitive tasks in Excel. Specifically, the focus is to build a macro that will update data from multiple database systems, pulling all necessary data and accurately updating the Excel file. The requirements include: - Deep knowledge in Excel VBA and macros. - Extensive experience in dealing with database systems. - Attention to detail to ensure valid and accurate data updating. - A solution-oriented approach to identifying potential issues with the automation. The ideal candidate will have a proven track record in creating VBA macros that interact seamlessly with various database systems. They'll bring efficiency and reliability, turning the repetitive updating process into a seamless, automated one.

...requires updating an existing workbook with new data, automating the creation of rows, columns, and formulas and allowing for an undated workbook to be downloaded without having to re-create all the formulas etc. I am open to the choice of programming language used for the Excel automation, eager to discuss your expertise and preference. Here are the expected tasks: - Modify an existing workbook with new information - Automate the import of current workbooks - Automate the creation of rows, columns, and formulas The frequency of these tasks will be dictated by our data download schedule which is done on an as-needed basis per job schedule. Ideal candidates will have a solid background in Excel automation and demonstrate some proficiency in either Python, VBA (Visu...

preferably a VBA solution, as per file, when click the 'generate' button to have multiple customer's details into one row in next sheet

I am seeking a freelancer possessing a strong command over Excel, VBA, and familiarity with Solver and Holt’s Winter Smoothing. Your task will entail: - Building a sales forecast analysis model using VBA in Excel. Detailed experience with Solver and Holt’s Winter Smoothing is crucial, as these tools will be heavily relied upon for seasonality adjustments and trend forecasting. - Developing a well-documented mini report highlighting the process, results, and interpretations. Effective communication and report writing skills are essential. - Incorporating historical sales data provided by me for analysis. Being able to interpret and manipulate large data sets is a critical component for this job. Previous experience in sales forecast analysis or simi...

Excel VBA Automation- As discussed.

NPV, SIM, Covar and general coding in VBA

I'm in need of an Excel VBA expert who can write a VBA routine to alter the font of a string. See image attached Sub BookLabel() Select Range StartLabel (H2) Select first x characters of string where x = value in cell F2 Set font =16 Font = Bold Down 1 cell Repeat same Continue to loop until some statement such as “End”, below the last record End Sub

Hello. I need to extract the values from this website in a spreadsheet (CSV or XLSX) in an automated way and every 10 minutes: . Must be with a VBA Macro and no required nothing special, only plain text in rows and columns (see attached). You will notice that it corresponds to a website with information about sports betting. The fields to be extracted are ALL the ones you can see per game. For example: - Sport - Country - Championship - Date and time of the event - Equipment - Type of bet (Home/Away, Over/Under 2.5, Final result, etc.) - Etc. Also note that "surebets" with 2 and 3 results appear, depending on the nature of the bet. If you have any doubt, ask me. Look at next examples of 2 results, but 3 results is seemed, adding more columns ...

I am currently looking to make alterations to an existing VBA Skyline chart. Specifically, I need assistance with: - Adding dates to the Form Labels. The dates in question will be the Plan Date, Actual Date, and Forecast Date. - Adjusting axis labels. - Changing the chart's color scheme. The ideal freelancer for this project should have substantial experience in working with VBA Skyline Charts and data labels modifications. They should also have a keen eye for aesthetic details such as color schemes.

I require an Excel expert with in-depth knowledge in VBA for developing a comprehensive invoicing system. I have my qr scanner when I scan product it's shows products details automatically. I attached 5 list of products. Your Task: * Create VBA macros to automate system functionalities * Design invoice templates that encapsulate professionalism * Implement automation for data entry tasks Purpose: The overarching purpose of the invoicing system is to streamline the tracking of sales and payments, automatically calculate finance-related aspects, and generate professional invoices that accurately represent our company. Required Features: * Ability to generate insightful reports on business financial trends * Functionality to send automated reminders for payments ...

I'm in need of a seasoned AutoCAD VBA coder to help me create a functional module for AutoCAD 2024. The core functionality involves: - Copying drawings from one file to another. - Locating the copied drawings within the new file. It's crucial for the module to guarantee that all original attributes and settings are retained in the new file. Ideal candidates should have considerable experience with AutoCAD 2024 and expertise in VBA coding. Please provide examples of your past work with similar projects, if available.

I am seeking a proficient VBA developer who is well-experienced with Excel, particularly in graphical data representation using charts. The project entails improving a skyline chart. Key tasks include: - Modification of the existing skyline chart using specifically Visual Basic for Applications (VBA). - Ensuring the enhanced chart operates efficiently within Excel and handles statistical data accurately. - Testing the final product to confirm accuracy and functionality within various data scenarios. The ideal freelancer for this project will have: - Strong expertise in VBA programming. - Familiarity with Excel functions. - Significant experience in handling and representing statistical data in charts.

Hi, you did an excel vba macro for me in 2019. It worked fine until now but it just broke, its not working anymore. can you help fixing it?

I am in need of a professional to help me create a toolbar plugin for PowerPoint 365. Key Requirements: - Must be able to translate an already created toolbar with VBA code into a comprehensive PPT add-in package. - Must be ready to review the existing codes and functionality I have developed so far. Ideal Skills: - Familiarity with PowerPoint 365 and its functionalities. - Proficiency in VBA scripting and creating PowerPoint add-ins. - Strong knowledge in plugin development and toolbar customization. Please note your experience in similar projects in your bid, and any ideas you have to enhance the toolbar based on your experience will also be appreciated.

I have a simple Excel VBA macro file (attached). The file shows up an additional toolbar on my personal PC, but does not show toolbar on client's PC. NOTE: The client can still run the macro code using the button placed on the grid. I just need to know the right group policy that needs to be setup correctly.

As the client, I'm seeking a skilled Excel VBA macro specialist who can create an automated system for a repetitive task in our operation. The task in question involves a data entry form consisting of Product, Quantity and Price fields that needs to be automated. As a professional with deep knowledge in Excel VBA, automation and data entry, you have: - Proven experience in crafting Excel VBA macros. - Proficiency in automating repetitive tasks. - Extensive understanding of data manipulation. - Excellent knowledge of Excel formulas and functions. Your main job will be to create a macro to automate this data entry form. This will involve auto-filling data into the respective form fields where necessary. This efficiency-generating macro should serve to eli...

Please submit your original charges in bid for this project For this project, I'm looking for a talented programmer who is highly-experienced in working with MySQL and Excel VBA. Your task will be to create a MySQL table with 3 columns. This table will be used in conjunction with Excel VBA to import data. Here are some specifics about the project: - The Excel sheet contains similar data types in a single sheet. - The data type is primarily text strings. - We need a VBA process to export these Excel data strings into our newly created MySQL table. Ideal Skills and Experience: - Expert knowledge in MySQL and Excel VBA. - Proven experience in data import/export between Excel and MySQL. - Detail-oriented and accurate in data handlin...

My project requires a proficient programmer familiar with Excel VBA and MySQL integrations. I'm seeking a solution that incorporates: - Database creation, modification, and updating - Data import and export via Excel VBA The VBA code should be capable of following tasks: - Reading data from the MySQL database - Writing data to the database - Updating existing data - Deleting data I'll be working with various kinds of data, including: - Text data - Numeric data - Date and time data - Binary data Knowledge of Excel VBA programming and MySQL database management forms the crux of this project. Experience in handling different data types and proficiency in database operations will be of paramount significance.

I am struggling with a VBA Excel file where the Macro is not running correctly, and I need someone proficient with VBA and debugging to fix it. The file is crashing frequently, which is causing significant delays and impacting efficiency. • **Macro Issue:** The macro is not running and I am unable to debug or fix it myself. I need an expert who can look into the problem, define what's wrong, and provide a solution that works flawlessly. • **Purpose of the Macro:** I will discuss this further with the successful applicant, but rest assured that your tasks will align with typical VBA Macro functions. Since the purpose of this macro hasn't been disclosed, I am expecting you to have experience with commonly used V...

I am looking for an experienced VBA developer to create a custom add-in for Excel. This project will require: - Developing custom functions to automate the generation of multiple types of charts in Excel, specifically pie charts, bar charts, and line charts. - These charts should be formatted according to our specific design requirements, including our house style and measurements. The ideal freelancer will have exceptional skills and experience in VBA and Excel add-in development. I expect a strong understanding of data analysis and an excellent ability to perform tasks accurately and efficiently. Furthermore, I value clear and regular communication so we can ensure the end result meets our expectations. Please only apply if you are confident you can deliver these tas...

As an entity constantly dealing with vast amounts of data, I need a proficient Excel VBA expert to assist in automating my reporting and dashboarding processes. An ideal candidate for this project should possess the following: Skills and Experience: • Extensive experience developing VBA Macros • Capability to generate reports automatically • Familiarity with handling data across multiple sheets Specific Tasks: • Developing macros to automate data retrieval from sources such as Excel workbooks and CSV files • Implementing these macros to streamline the process of report generation and dashboard updates By simplifying these tasks, this project will enhance our overall productivity and data management processes. It is crucial that the ex...

I'm looking for an expert in Microsoft and Visual Basic for Applications (VBA) to streamline my repetitive financial data entry tasks. Key Tasks: - Develop a VBA script to automate the entry of financial transactions Ideal Profile: - Proficiency in programming with Microsoft and VBA - Previous experience in automating data entry, preferably financial transactions - Strong attention to detail to ensure accuracy in data entry automation - Basic understanding of financial transactions for effective development of the automation system The successful freelancer will create a simplified and efficient data entry process that eliminates the manual input of financial transactions. Attention to detail, speed, and efficiency are vitally important for this project...

I need to redevolop a simple shopping cart based on Excel VBA. Requirement is to rework current design and function. I prefer developer that can with russian and english language, as this would help get some information from former versions. Pls contact me. BR Michael

I am seeking a dedicated and experienced VBA developer to build an inventory management software that tracks both physical and digital products. Key Features Required: - Inventory Tracking: The system needs to provide accurate and updated record of both physical and digital goods. - Purchase Order Management: An automated reordering function based on predefined parameters is paramount for the efficient operation of our procurement process. The ideal freelancer should have a strong background in building inventory management systems with Excel VBA as well as in-depth knowledge of automated reordering functionalities. This knowledge is critical in order to assure the success of this project. It's also expected that the candidate is proactive and asks any needed...

...Creating automation scripts for: - Data Formatting: The job will require you to set up scripts that format data according to preset conditions. Understanding of and experience with conditional formatting in Excel is critical. - Report Generation: I will require automatic generation of reports from collected data. Your experience with creating automated report systems in Excel will come in handy. In terms of skills, experience with Excel including knowledge in macros and VBA scripting is a must-have. The ideal candidate should have developed automatic report systems in the past and has extensive experience with conditional formatting. This project offers you an opportunity to showcase your ability to automate and bring efficiency to tasks. Look...

Necesito un especialista en macros de Excel para desarrollar un simulador interactivo de tasas de interés. El proyecto debe completarse lo antes posible. Sus principales responsabilidades son: - Crear una macro de ...específicas. Aunque no se indica explícitamente, será beneficiosa una comprensión sólida de las tasas de interés, su cálculo y los conceptos financieros relacionados, preferiblemente con un enfoque en tasas de interés fijas, variables y compuestas. Su experiencia se reflejará en el diseño e implementación efectivos del simulador. Por lo tanto, debe tener un buen conocimiento de las macros de Excel, VBA y los modelos financieros. Se valorará tener experiencia previa en finanzas...

In need of a seasoned Excel VBA expert to develop a comprehensive techno-economic analysis tool for solar projects. The automated tool should accomplish the following: - Automate data entry - Generate informative reports - Perform data analysis to inform strategic decision-making Key functionalities to include: - Calculation of Return on Investment (ROI) - Estimation of energy production The tool should take the following inputs to calculate ROI and energy production: - Initial Investment Cost - Annual Energy Production - Energy Tariff - Maintenance Cost Ideal Candidate: - Mastery of Excel and VBA - Previous experience in creating financial/technical analysis tools - Understanding of solar energy industry would be a plus

We're looking to edit an existing automated process created years back. Youll have to see the attachments to see the correlation below. We would like to generate a QR codes containing the information below to then be printed on the LP and MP cards (as seen in the ) attachment. MP Card 1) Date 2) Part Type- MP 3) Item Group Number- 1 of # 4) Order Number- ORD0076301 5) Customer Name- Legend senior living 6) Item- Legend senior living 7) MP Material Type- SPL Cordovan (#192) 8) If "No Image"- No Image 9) Item Quantity- 25 10) Product Line- SPL LB Card 1) Date 2) Part Type- LB 3) Item Group Number- 1 of # 4) Order number- ORD0076301 5) Customer Name- Legend senior living 6) Item- 4 Part 411 7) LB Material- Black 5265 8) Corners Material- SPL Cordovan (#192) 9) If

We require expertise in developing an Excel file that utilizes VBA code to automate specific tasks. Primary objectives of the project include: - Creation of an Excel file referenced to a specific dataset - Designing a robust VBA code system to import data from the reference file - The VBA code should perform complex calculations and data transformations pertinent to technical and economic analysis The ideal candidate will have a rich experience in data analysis, particularly in managing, interpreting, and simplifying complex data systems, with a strong proficiency in Excel and VBA code development. Familiarity with technical and economic analysis would be highly beneficial. Please ensure you have tangible examples of similar work to showcase...

...primary purpose of this workbook is to keep daily track of business transactions with great accuracy. The following features are crucial for the workbook: - Functionality to track daily transactions. - Automated monthly report generation to precisely sum up the data of a month. - The monthly report should include particulars such as expense tracking, revenue tracking, profit calculations as well as an end of the month balance sheet, tracking of sales, and out payments. In the Sales and Out Payments Tracking section, it is vital to monitor the quantity sold, payment received, and payment date. A closing sheet is also something I'm interested in. The ideal candidate would be well-skilled in Excel formulae, VBA (Visual Basic for Applications), applied Mathematics a...

I'm seeking expert help in .NET / VBA programming for a seamless integration between Excel and Outlook. The primary feature of this integration should be automatic updating Excel whenever new contacts are added to Outlook. In addition, a bulk auto-reply feature is desired. ---------------- Please read the attached proposal file carefully. Besides, before establishing a milestone, we are possible to continue to revise and update this proposal along with its specifications within the discussion threads. Prior to accepting the milestones, please ensure to review all the most updated proposal details and specifications. Let’s confirm we have the same proposal with the same modification time before accepting milestones. ---------- Key Tasks: - Develop a...

Excel vba work Macro to move files

For my ongoing work, I need assistance in converting an existent VBA script from Excel 16 on Windows to properly function on Excel 2016 on a Mac. The script I currently have is responsible for automating a series of key tasks which substantially help my productivity, specifically: - Arranging and sorting my data Successful candidates should be comfortable with both operating systems, have an excellent command over Excel, and a deep understanding of VBA scripting. Prior experience in Excel-to-Mac conversions is also beneficial. This job requires clever problem-solving, meticulous attention to detail as well as the ability to clearly communicate the changes made.

Tôi có 1 list file excel báo cáo có chung cấu trúc đc đặt tên file theo quy tắc bao gồm mã đơn vị nộp và danh sách đơn vị nộp báo cáo. Tôi muốn xử lý: - Đánh dấu những đơn vị đã/chưa nộp báo cáo - Đối với các file đã có tiếp tục phân loại nếu ô X có số liệu thì đánh dấu có/ nếu ko có số liệu thì đánh dấu không.