In vba işler
I am looking for someone who can transfer my current VBA code into GCP Big Query stored procedure. This basic VBA code is readily available for conversion. Primary Requirement: - Maintain the 'IF ELSE CONDITION' functionality of the current code during the conversion process. Ideal freelancer: - Experienced in converting VBA code into GCP Big Query stored procedures. - Skilled at preserving specified functions through the conversion process. - Good understanding of basic VBA code structures. - Excellent problem-solving skills in case any issues arise during the conversion process. Your expertise in this area will not only help in preserving the original functionality of my code but also enhance it using GCP Big Query&#...
I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. Key tasks include: 1. Utilizing VBA to automate the generation of project summary reports. 2. These reports must provide a list of all tasks and their current status 3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors. The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in project management reporting is highly desirable. I'm looking for someone who understand...
I need a competent Lisp programmer's help in dealing with a nagging issue affecting my code. Specifically, it is producing incorrect outputs when engaging with certain external systems. Key tasks include: - Identify the root cause of the output error - Troubleshoot and rectify the logic flaws causing these errors - Make sure code is efficient, secure, and maintainable The ideal candidate for this role will have: - Proven experience working with Lisp and Autolisp even VBA. - Troubleshooting and debugging expertise - A good communicator that can take my rudimentary directions. To make it short, I have a code that is used for underground drilling permits in the CAD environment. I have a LISP suite that stations a line by generating notes, that generates MLead...
I'm in need of an expert in VBA programming and Crystal Reports integration to enhance and extend the functionalities of an existing form in our program. - The form was created with VBA for the purpose of data entry. - The enhancement would involve adding more features to this existing form. - The extension requires integrating it with Crystal Reports for more efficient and agile reporting. - Moreover, I'm looking for someone who can provide ongoing support as needed. The ideal freelancer would have extensive experience in VBA programming, form design, and Crystal Reports. Your portfolio or a demonstration of a similar task you've completed would be much appreciated. A commitment to provide ongoing support on an as-needed...
I'm seeking assistance with my Microsoft Access project involving the creation of queries, forms, reports, and a comprehensive description of t...provided after project commencement) - Creation of 2 forms: A Main and a Subform. The main form is to be designed for data entry. - Devising 2 reports based on set requirements (to be disclosed upon project initiation). - Crafting a detailed written description of the entire database system using a provided template. Ideal assistance would come from someone with proven experience in Microsoft Access, SQL, VBA, and database development. A deep understanding of query development, form creation, and ensuring data integrity within Access databases is crucial. Your ability to communicate effectively to explain complex systems wil...
I'm looking for a professional with Excel VBA expertise who can swiftly help in automating the process of printing specified worksheets from Excel to Word. Here's what's important: * Excel VBA proficiency: This task calls for specialized knowledge of Excel VBA, so your skills in this area will be pivotal. * Existing VBA: I will share the existing vba, the VBA has many tools including the print. * Enhancement required: the existing vba has print funtion where user can print specific sheets, we need to print or covert these sheet to a word file. * Quick Turnaround: I need this project completed ASAP, so ability to work under pressure and deliver on time are key. Please ensure you check the requirment carefully b...
Lütfen detayları görmek için Kaydolun ya da Giriş Yapın.
...updated by reading data from a TXT file. The process must be automated via a script, filling in blank cells, distributed across all the sheets in the document. Key requirements include: 1. The ability to read and accurately interpret all fields from the TXT file. 2. Updated data should be posted to all sheets within the excel document, in the required cells. 3. In the case of data discrepancies within the TXT file, enable an automated resolution by defaulting to a specific value. Leveraging your expertise in data extraction, manipulation, and Excel automation will be instrumental for this project. Ideally, you are proficient in scripts suitable for handling such tasks, debatably the likes of Python or VBA, contingent on your recomme...
I am looking for a script to automatically add 7 days to a date in a table. The date format is dd/mm/yyyy and the date is located in the column "Not done late +35D". The result should be a new column with the date + 7 days, called "Not done late +42D". Specifications: The script must work on Microsoft Word. The script must be easy to use and does not require any programming knowledge. The script must be compatible with recent versions of Word (2013 and above).
I have 2 unfinished Access/VBA projects. I need assistance to finish the projects. My estimation is 3 working days. Max budget : 100$ Please note that I m also a freelancer. Thanks for you bid
I'm experiencing an issue with my VBA code not running as expected on my Mac with Office 365 version of Excel. I am also receiving error messages when attempting to run the code. I'm in need of a freelancer with a strong background in: - VBA Programming - Excel - Debugging - MacOS, specifically the Office 365 version of Excel Your task will be to inspect my code, identify the issue causing it to malfunction, provide fixes, and guide me through the process to avoid such problems in the future. Your debugging skills will be paramount and your ability to communicate clearly is desired. I expect prompt resolution of this issue, without any loss of original functionality. Please ensure you have the specified skills before making a bid.
...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 dashboard...
...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 status as of February 2024) and so on with the sheets "CEL 03-24", "CEL 04-24", "CEL 05-24", up to "CEL 12-24". The data ent...
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 ...
...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, ...
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 G...
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
Hello, I am currently a student in a business school and I am preparing for a makeup session 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 sp...
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
1. If certain condition met, Update value in diffect column in same row 2. It is by Minutes, Data are 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 releas...
1. If certain condition met, Update value in diffect column in same row 2. It is by Minutes, Data are 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 rel...
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
...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 should demonstrate an understanding of Word functions, automation techniq...
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, automate...
I am in need of a proficient Excel automation specialist. This job 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...
preferably a VBA solution, as per file, when click the 'generate' button to have multiple customer's details into one row in next sheet
...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 similar projects will add to your candidacy. I ...
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 pa...
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-generati...
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 acc...
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 VBA functions like automated dat...
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 confide...
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 expert ma...
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 impor...
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
