Excel Visual Basic Subroutine
$30-250 USD
Maksettu toimituksen yhteydessä
I have worksheets that need to determine compounded inflation over the useful life of the asset. They are named 'Comp300', 'Comp301' and so on. The worksheets are always in the same format. Cell H7 is always the same field all the worksheets and so on. I have named the cell H7, 'AE', for ease of use. AE stands for average estimate which is the starting number BEFORE the compounded inflation is added. I have separate worksheets that contain only the inflation rates. For example, in the Worksheet 'General Building Inflation Rates', cell A1 contains the inflation rate for 2001. Cell A24 contains the inflation rate of 2024. Using Worksheet 'Comp300' as an example, it has a cell named ITU (Inflation Table Used). The value of ITU is 'General Building Inflation Rates'.
Worksheet 'Comp300' has a cell named AE (Average Estimate) which contains $5533. It also has the 2-digit year cell called YEAR which has a value of 23. Finally, worksheet 'Comp300' has a cell named RUL (Remaining Useful Life in Years) which contains 5.
Worksheet 'General Building Inflation Rates' contains in cell A24 = 400 (4.00%), cell A25 = 350 (3.50%), cell A26 = 300 (3.00%), cell A27 = 250 (2.50%) and cell A28 =200 (2.00%).
I want to call a macro or VB subroutine that accesses the specific Component worksheet and the ITU worksheet, uses the data contained in the cells I mentioned and returns the compounded inflation amount (AECIA) for the cell AE. It would have to set the compounded inflation amount equal to AE (AECIA=AE) at the beginning of every subroutine call so I would always start the subroutine fresh.
So, for example in worksheet 'Comp300': I want AECIA to first be set to AE ($5533). I want the starting year to be YEAR +1 or 24. I want to take the value from cell A24 of worksheet "General Inflation Building Rates" and multiply it by AECIA and add the result to AECIA. It will loop 5 times (value of RUL), applying A24, A25, A26, A27, A28 to AECIA. When the loop completes the RUL, it will return the value of AECIA. Worksheet "Comp301' has different values that will be executed through the subroutine and so on. That's it!
Projektin tunnus: #36717013
Tietoa projektista
43 freelanceria on tarjonnut keskimäärin $153 tähän työhön
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Lisää
Hello, I am an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hi, this sounds pretty straightforward, but i would like to see sample file. Would you mind attaching the file you based this description on? I am available right now and i believe i can help you. Thanks, Milan
"""""""""""""""""""""""""""""""""""""""ADVANCE EXCEL VBA EXPERT/EXCEL VISUAL BASIC (VBA) SUBROUTINE"""""""""""""""""""""""""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL Lisää
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
Hi there! As I have read, I see you need help building your worksheets and I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 pr Lisää
Hello, I am an Excel and VBA/Macro expert. I have read the project details thoroughly and offer my services to create a macro or VB subroutine that accesses the specific Component worksheet and the ITU worksheet, uses Lisää
Hi There! I have understood the requirements for the task. I have 6+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tabl Lisää
Greetings, I am an Advanced Level Excel Formula, VBA & Macros expert and an Accountant. I am very confident to start your project and complete it with all efficiency you are looking for. I understand the requirements a Lisää
With over 7 years of experience in excel usage and an ACCA qualification, I have expertise in all areas of Excel, I can provide you with efficient, accurate, and insightful solutions to your data-related challenges. My Lisää
I am excited to hear about your project for Excel Visual Basic Subroutine and introduce myself as the best fit for this project. With more than 15 years of experience in project management, strategic planning, marketin Lisää
Hey ! I am a professional freelancer with years of experience in Data Processing, Excel, Visual Basic, VB.NET and Visual Basic for Apps. I have keenly read your project requirements and believe this is something I can Lisää
Hello! I am interested in your project Excel Visual Basic Subroutine I have completed similar papers in the past and can assure you of exceptional and original work within the agreed deadline. I have skills in VB.NET Lisää
Dear sir/ma'am With nearly 14 years of coding experience, I have written scripts to automate repetitive manual tasks in Excel and to consolidate multiple Excel files into one with utmost accuracy and speed. I have crea Lisää
Greetings! As a highly experienced Data Analyst, I am offering my services for your project. I have more than 5 years of specialization in the field and hold a Master's degree in data analytics. My knowledge and exper Lisää
Hello There I understand you are looking for someone to help you with your project involving Excel Visual Basic Subroutine. With 9+ years of full stack development experience in Web | Mobile development, I am confident Lisää
SOFTWARE ARCHITECTURE EXPERT GOOD IN JAVASCRIPT, MYSQL, PYTHON, C PROGRAMMING AND HTML HELLO DEAR CLIENT Thank you for sharing your project requirement, I have carefully read the project description and I would like to Lisää
Hi, dear. I have read the description carefully and I am sure that I will satisfy you. Send me message for more discussion. Thanks regards.
Hi there, How are you? I can work with your project requirements mentioned. I can definitely pull it off once provided with detailed file of your requirements. Some points are needed to be discussed before starting so Lisää
