Vba Projects

Very quick VBA task

Task 1 - Calculate the target values (Cells D4:D6) In columns E, F and G, I want it to fill in calculated values in the range E24 to G28, but only the number of years specified in the cells in row 12. So if they select in row E12 "2" then it will only calculate the values in cells E24 and E25. Task 2 - create arrays to calculate the Assumed lower range and Assumed Worst Case I don't want these displayed on the sheet but I do what the values calculated into the range (E4:F6)

pre-funded

Excel VBA for weighted sum model

Hello, I am looking for a developer who can create a utility analysis in Excel with VBA. The task is defined as follows: - Create a utility analysis (weighted sum model) for an application example of your choice - The documentation and description of the application example is provided on an Excel worksheet. - The data management (criteria and alternatives) takes place in an Excel worksheet. - The weights for the criteria and their evaluation are queried in VBA and saved in the Excel worksheet. - The utility values are calculated with VBA and saved in the Excel worksheet. The following constructs are to be used in the VBA code: 1) Subroutine / subfunction with variable transfer 2) Array/Record 3) Data management in Excel using Application.Range (“A1”), Application.Value or Application.Cells(i,j) The task is to be submitted as an Excel file / Excel workbook with macros (xslm). The expected formula for the weighted sum model / utility analysis is to be found here: https://en.wikipedia.org/wiki/Weighted_sum_model Thank you for your interest and best regards

Looking for VBA Master

We are looking for a VBA programmer to modify legacy systems running on microsoft Access. You should have good experience of VBA programming. This is a longterm project because we have many scripts to work on, therefore we're looking for someone who can quote an hourly rate for the work.

VBA project to process data in Excel

The spec is in the Word document Essentially data will be pasted onto one page of an Excel spreadsheet each month and then 4 dynamics reports run from that. So on 4 pages of Excel there will be dropdowns to select the criteria and then I want to be able to hit a button to process the data from the data sheet into a report. Once I have selected the freelancer, I will share the Excel file.

VBA to unhide sheets based on Windows Login Username

I have a workbook where I want the windows user login to decide which sheet get unhidden, everything else should stay hideen.

I need a VBA code to open a sports website and click buttons.

I need someone who is a specialist in Excel, VBA Macros and web scraping. You will need to understands soccer fixtures including: home team, draw, away team, specific odds and how bets are placed. The VBA code will read the urls from an excel table open the urls navigate to the sports website page with the soccer fixtures and place the bets by clicking the appropriate buttons based on the data in the specific cells from the excel table. Once the first row of the table has been fully tested and working a loop will be added to the code to loop through the entire table. I have added a screenshot of how the bet slip should look based on the top row of the table and the excel table with the urls. Please check that you can access the website before submitting a bid. Thanks

opportunity

Excel Timesheet - VBA

Hi, I have a timesheet that I need automating, I have already started it, I can email a copy as it won't allow me to attach. I would like the below functions: Timesheet in Excel one timesheet/file per employee. File to only be opened by employee & approver, require username & password, one for employee and the other for Approver, other employees should not be able to access other colleague’s timesheet that are kept in the same file location in share drive. Employee to enter the timesheet and then submit for review. On Submit – email to be sent to approver and secondary approver. Approver to then login into timesheet and either Approve – which will then lock that timesheet from being edited and save a PDF copy into drive, and for a new timesheet for following week to be created. And to send email to employee with timesheet status that its been approved. Rejected – This will send email to the employee to say it’s been rejected and in body of email to be text with reason (user input). Once the timesheet is approved I need all the timesheets data to be transferred to another excel file that has been set up as a table in order to run pivot/Queries. Please note we use share point.

opportunity

Excel Customer Relationship Manager, (CRM) Development Project

We are seeking an experienced Excel contractor with advanced skills to develop a custom Excel-based CRM system with login and dashboard. The ideal candidate should be proficient in the following areas: 1. Advanced Excel Expertise: Must demonstrate mastery of Excel functions and techniques, including VBA (Visual Basic for Applications), to deliver sophisticated solutions. 2. Dashboard Design and Customisation: Ability to create interactive and visually engaging dashboards, tailored to our specific CRM needs. 3. Spreadsheet Automation: Skilled in automating processes within Excel, enhancing efficiency and user experience. 4. Security and Password Protection: Proficient in implementing robust password protection, both for login access and for certain sensitive sections within the CRM. Upon appointment, a full brief and detailed guidance will be provided to help create these specific areas within the CRM system. If you are interested in this opportunity, please send examples of similar work you have completed that demonstrate your capabilities in these areas. I look forward to reviewing your expertise and seeing how you might contribute to this project. Thanks, Chin

I have an excel spreadsheet that I need formulas inserted into

I require assistance in implementing formulas and functions within an Excel workbook comprised of multiple sheets. The main data sheet contains a table with event information. I would like to create an interactive cover sheet utilizing dropdown lists and smart formulas. Specifically, a dropdown menu should allow selection of an event from horizontal labels on the data sheet. Once selected, relevant details for that event should automatically populate on the cover sheet from the correlated cells on the data sheet. This will generate customized cover sheets for each event. Input is also sought regarding additional intelligent formulas and artificial intelligence tools that could optimize the workflow. Experience with dynamic Excel functions, pivot tables, VBA macros, and conditional formatting would be particularly beneficial to provide recommendations for maximizing efficiency. Will have the sheet available today at 4pm UK time and I need formulas etc inserting by 1pm Tuesday 22nd October, UK time.

opportunitypre-fundedurgent

Create & Display Dynamic Gantt chart on Userform Excel vba

Workbook with two worksheets and userforms. 'Data Input' userform already created and coded. Userform to display gantt chart created but requires coding to display dynamic Gantt chart Copy of workbook as database will be uploaded to business one.drive and shared with max of 5 users to use at any one time (downloaded and saved to user one.drive) 5 x columns on worksheet to be used for gantt chart: - Company name - Start Date - End Date - Total Days - Total Working Days Dynamic Gantt chart required to display in userform displaying (vba coding required): X - axis - 4 x 'dates' data labels displayed at top - 1. rolling calendar dates in days - 2. rolling calendar dates in weeks - 3. rolling calendar dates in months - 4. rolling calendar dates in years X - axis - Horizontal Bar Chart area - to display customer 'booked time slot' - could be anything from 1 working day up to 2, 3, 4, weeks - A 'Provisional' time slot would display in colour orange - A 'Confirmed' time slot would display in Green * When a 'Provisional' time slot has been 'Confirmed', (cmd btn) colour would change from orange to green). * Open to all and any suggestions on types of configurations on how to display days, weeks, months, years Y - axis - Customers name Seeking a freelancer to work on this immediately AI explanation: This project requests the development of a dynamic Gantt chart within an Excel userform for workload scheduling and resource management. The workbook contains two worksheets, including a populated “Data Input” userform for raw data. An additional userform has been created but requires VBA coding to generate the Gantt chart visualization. The chart will display on the userform with the X-axis showing four timescale filters - dates in days, weeks, months, and years. A horizontal bar chart area below will include colored bars to represent customer booking slots from one day to multiple weeks. Provisional slots will show orange, and slots that are confirmed will turn green when the status is updated. Data for the chart pulls from five columns on a worksheet: company name, start date, end date, total days, and working days. The dynamic chart should automatically refresh and resize based on this data. When complete, the anonymized workbook will be uploaded to a shared online drive for up to five simultaneous users to access, view, and edit booking information from their individual accounts. This project provides an opportunity to develop a useful project management tool with interactive Excel capabilities. Coding is needed to link the chart area to the raw data and allow user-driven changes to slot statuses and visualizations. Design customization for optimal display of the timescale and booking slots is also welcome. The client seeks a skilled freelancer

Excel VBA

I need help with some excel formulas for Mac. I need values in cells B31 to B50 to move to other columns depending respectively on cells L6 to L21. The problem is that in the original cells there are somewith multiple values in different lines, if so, values should move to different columns amongst themselves depending on what is in the same line of the cells L6 to L21. For example, if there is a value in B31, it should move to a column given by what is in cell L6. If it says "Platano", the value should stay at B31. If it says "Malanga Blanca" it should move to B32. And so on with different products. If theres multiple lines (and values) in cell, B31, each value should be assigned to its appropriate column depending on what is in cells L6 to L21. In summary, I need to move the values from some cells to a different one depending on its specific line of the other cell.

VBA/Macro to transform Spreadsheet records into Visual Layout.

I am trying to create automation from spreadsheet records that can make an aisle layout of the store info. I have attached a spreadsheet with the table records, 2 image examples. I do not know the best way to execute the layout, by inserting shapes or just formating cells.

VBA script to import regular txt files into MS ACcess

We receive refular text files via FTP. They are multi lined text files (example attached) I need to setup some VBA that scns the directory for any new files . Import them into access. Most order files have 1 item, but can have several. We are not interested in the detail rows, only to know how many detail rows there are. example: "HEADER","INVOICE","00701439","28/08/2024","","S398","GBP","#7538361-10755","","****" "DETAIL","1","8436563184826","1","Stereo Dri","CECIL TAYL","#7538361-10755","1","20","8.99","1.80","8.99","","","8.99","1.80" "SAC","2","","1","SHIPPING","","C","1","20","2.22","0.44","2.22","0","2.22","2.22","0.44" "SAC","3","","1","HANDLING","","C","1","20","0.95","0.19","0.95","0","0.95","0.95","0.19" "TAXSUMMARY","1","3","20","12.16","2.43" "TOTAL","8.99","0.00","3.17","2.43","14.59" "TRAILER","00701439","1","3"

Customer Referrals - Excel to Relational Database

A charity offers advice to the elderly and vulnerable abut staying safe online. People call a hotline and ask for a visit. The visit is assigned to a volunteer, often the volunteer can complete the consultation in a single visit, sometime it may take 3 or 4. Clearly there are customers, volunteers and meetings so the data should be in multiple tables but currently everything is in a single excel file with one row for each 'case'. There is no 'user interface', the excel file has some data validation rules but doesn't use tables or any advanced features to allow searching, sorting etc. The charity are not convinced that the excel file needs any revision. I have some experience in Access (dating back 20+ years) - I suspect things have moved on a bit. The charity has a Sharepoint site but only uses its basic functionality. I would like to create a better version. I'm reasonably proficient with excel and could do 'something' I suspect that, if I did, I would need to re-do everything if ever we got as far as integrating this with sharepoint. It may be that a 'properly' designed excel sheet could integrate with sharepoint and we could do it that way? I'm not proficient with Sharepoint. I would like to convert the excel file to a relational database that I could then design a suitable front end for. This database would function in a 'stand alone' way for immediate use but later integrate into sharepoint relatively easily. (as mentioned - I'd be happy to design forms in excel using VBA but I think we're maybe past that now? Is this possible? (it 'kind of' is using Access but maybe this isn't the way to go?). This is a self funded project that I'd like to 'show' to the charity. Whilst I'm happy to 'negotiate' I'm hoping that it doesn't involve too much work and won't be expensive ...? NB I do not respond to automated replies as there always seem to be a lot of "I can do your project" generic replies but I will get back to anyone who (I think) has taken the time to read the proposal. I hope this doesn't sound unfair ...?

Excel Query Using VBA & SQL Server Database

Got a simple request as follows I have a SQL Svr DB containing the follwoing fields: RACEID DATE OF RACE NAME OF GREYHOUND RESULT ODDS I have a spreadsheet where it gives all the possible pairs of runners (30 rows of 2 selections) I need you to write a query that builds a head to head result summary for all 30 combinations of dogs WHERE they have raced against each other before, which can be found by them both belonging to the same RACEID in the DB So runner 1 versus runner 2 thru to 6 only where they have the same RACE ID obviously Then runner 2 versus runner 1 thru to 6 only where they have the same RACE ID obviously Then runner 3 versus runner 1 thru to 6 only where they have the same RACE ID obviously and so on Where 2 Greyhounds have raced before against each other (same Race ID) I need to write back the values of: RACEID DATE OF RACE RESULT ODDS for each of the pair of Greyhounds who have raced against each other. I have attached the spreadsheet showing Race, Dog1 (col B), Dog 2 (col C) There are multiple sheets (1 race per sheet) Is this something you could do for me.

PDF Loan Term doc Automate with Calculations, Interactive fields

I am seeking a skilled freelancer with expertise in Excel or Google Sheets to upgrade and streamline an existing loan term sheet. The goal is to automate calculations, implement drop-down menus, and include functional buttons to enhance the usability and efficiency of the term sheet. I also welcome feedback and suggestions for any additional improvements. Below are the specific features and updates needed: ### **Key Features to Implement:** 1. **Drop-down Menus:** - **Principal & Interest / Interest Only** options. - **Term:** Options for 12 Months and 360 Months. - **Holdback Construction:** Include "N/A." - **Payment Type:** P&I (Principal & Interest), IO (Interest Only). - **Prepayment Penalty:** Options for None, 12, 24, 36, 48, and 60 months. - **Reserve Escrow:** Options for 3, 6, 9, and 12 months. 2. **Automated Calculations:** - **Fee Calculations:** Automate fields for Origination Fee, Loan Processing Fee, Legal Review Fee, Document Preparation Fee, and Underwriting Fee. These fees should automatically populate in a "Lender Fees" section. - **Estimated Title Insurance:** Automatically calculate as 1.5% of the loan amount. - **Liquidity or Cash-back Calculation:** For cash-out refinancing, include automated deduction of fees and payoff amounts to show estimated liquidity. - **Interest Rate Calculation:** Include fields to calculate monthly payments based on the total loan amount, interest rate, and amortization schedule. Adjust payments according to the selected payment type (P&I or IO). - **Loan-to-Value (LTV) Ratio:** Add an automated calculation for the LTV ratio based on the entered loan amount and property value. 3. **Clear and Save Buttons:** - Add a "Clear" button to reset the term sheet to default values for new entries. - Include a "Save" button to store the completed term sheet entries. 4. **Additional Features:** - **Validation Checks:** Ensure all required fields are filled out before saving or finalizing the term sheet. - **Notes Section:** Add a section for notes or comments to include any special terms or conditions. - **Risk Indicator:** Implement a simple color-coding system based on the LTV ratio or other risk factors (e.g., green for low risk, red for high risk). - **Dynamic Loan Adjustment:** Introduce a field for quick modifications to loan terms if adjustments are made during the process. - **Amortization Table Generation:** (Optional) If feasible, automate the generation of an amortization schedule based on loan details. 5. **Automated Summary Section:** - Add a summary section that updates automatically with key details like total fees, monthly payment amount, LTV ratio, and other vital loan terms. ### **Skills Required:** - Expertise in Excel formulas, VBA (Visual Basic for Applications), Google Sheets scripting, or other spreadsheet automation tools. - Experience with form-building and creating user-friendly interfaces within a spreadsheet. - Knowledge of financial calculations, including interest rates, amortization, and loan fee structures. ### **Expectations:** - Implement the features mentioned above. - Provide feedback or suggestions for additional improvements. - Ensure the term sheet is easy to use and requires minimal manual input after setup. If you have experience in financial or loan documentation automation and are interested in this project, please reach out with examples of similar work.

MS Access and Excel VBA developer

Hello, I am a European software developer specializing in custom software using MS Access and Excel VBA. I am looking for an experienced MS Access programmer to support various projects, primarily focusing on the development of customized MS Access applications. The ideal candidate should have proven knowledge in MS Access and SQL, along with strong skills in VBA programming. Good English communication is also required. If interested, please share your portfolio and experience. Best Regards Lutz

VBA Script and VB ASP Web Code

I am looking to integrate the opensource Android SMS gateway found here (https://github.com/capcom6/android-sms-gateway) in to a project. Full documentation can be found on their git and API details I need someone who can write me a VB ASP procedure that will sit on an IIS server and: 1) can register a webhook with the SMS gateway software running on an Android phone somewhere on the local network. 2) receives SMS messages forwarded by the SMS gateway on that android phone, and store them in a table within an MS Access database. 3) Delete the webhook if we ever need to Key points: • All of the hardware involved will be on the local network. • Intention is to register the webhook once, then the server will run permanently in the background. • This is for an extension of existing project (moving from using 3rd party gateway to one on our own network) • Some long text messages will be received and need to be handled as such (trimming to the 500 character field length) • Errors need to be trapped and logged on the server as a log file. • The lighter and simpler the code, the better.. I'm looking for robust 24/7 operation that processes SMS messages quickly. • MS Access is currently a 2003 MDB but we're in the process of porting to a 2019 update, so something that works for both JET & ACE would be ideal. Anticipated workflow: {first time config} https://xxx/sms-start - this will prompt for a local host ID and the url of the Android SMS gateway, store this in a config on the web server, and will then use this information to register a web hook with the SMS Gateway server. Running this page and submitting it should overwrite the current config and prompt to create a new webhook on the SMS gateway. {day to day operation} https://xxx/sms-receive - When the Android server receives an SMS, it will forward it on to this address as a POST message. The server will then store the data in the MS Access database {if we ever stop using this server} https://xxx/sms-decommission - This page will use the information in the config file to delete the web-hook from the SMS gateway.

VBA/Macro Developer with Finance Modeling Experience

Create our own templates for every single financial model Create templates for the higher workflows or Analysis use cases that use the financial models (e.g M&A, LBO, Structured Finance, Risk, Portfolio Management, etc) Create templates for company profiles and other reports that get generated from the financial models Document and tag all fields and cells so that the information becomes part of the project Beacon glossary Create vba macros for every financial model Create vba macros for every other template (consider generating powerpoint presentations too) Document and test all the scripts and ensure they work flawlessly Create python scripts to extract and transform data from data sources or APIs in order to fill the financial models identified in Milestone 1. Create and test workflows from Data ingestion Data transformation Updating the financial models Generating amazing Excel Macros to present the models Generating the presentations if necessary Create Google App Scripts versions of the Macros (for Google sheets version) Investigate creating Excel Plugin for the templates

Reporting software in Access DB

I'm looking for a database professional, to help finish designing and coding my reporting software. Software has been started, and now I need to finish it. I have done a little coding, but I'm not fluent. Software needs to work on both 32 and 64 bit computers. Software is Access database for engine and storage. The software will need to be able to have both user input, and self calculate certain parameters. It will begin with the user login. If the user is an "Admin", they have access to the full software availability. If the user is NOT an "Admin", they have limited access to only certain features of the software. This will limit the "User" table to only be updated by a system admin, and not just anyone. The software I'm creating is for my job. It's to make my job a ton easier. The software must be able to print various reports, and automatically save the dB file, via upload to a given website, or FTP. This can be done once the majority of the software is functioning properly. I will attach all associated written files. I don't believe I need to start fresh, but am open to simple solutions. I've originally wrote this software in Excel VBA, but it's not secure. Any and all help appreciated.