Excel Visual Basic Subroutine

Lukket Opslået 3 måneder siden Betalt ved levering
Lukket Betalt ved levering

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!

Visual Basic Excel Visual Basic for Apps VB.NET Databehandling

Projekt ID: #36717013

Om projektet

43 bud Remote projekt Aktiv 2 måneder siden

43 freelancere byder i gennemsnit $153 timen for dette job

schoudhary1553

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 Flere

$180 USD in 5 dage
(580 bedømmelser)
8.5
P0L

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.

$200 USD in 3 dage
(506 bedømmelser)
8.1
MimiFL

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

$40 USD på 1 dag
(783 bedømmelser)
7.5
AccountantArman

"""""""""""""""""""""""""""""""""""""""ADVANCE EXCEL VBA EXPERT/EXCEL VISUAL BASIC (VBA) SUBROUTINE"""""""""""""""""""""""""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL Flere

$99 USD på 1 dag
(249 bedømmelser)
7.1
periyannas

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

$240 USD in 7 dage
(188 bedømmelser)
7.0
Giovanni704

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 Flere

$30 USD på 1 dag
(56 bedømmelser)
6.9
hamidr2020

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 Flere

$100 USD på 1 dag
(94 bedømmelser)
6.2
AnjaliMehta

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 Flere

$200 USD in 3 dage
(10 bedømmelser)
5.7
freelancerabdu34

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 Flere

$150 USD på 1 dag
(42 bedømmelser)
4.8
SIBTEHASSANBUTT

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 Flere

$450 USD in 5 dage
(38 bedømmelser)
4.9
AmazingEngr76386

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 Flere

$140 USD in 7 dage
(4 bedømmelser)
4.4
mwikalicarolyne2

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 Flere

$155 USD på 1 dag
(1 bedømmelse)
4.0
theprowriter50

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 Flere

$30 USD in 3 dage
(8 bedømmelser)
4.1
akibul18

Hello! My name is Md. Akibul, and I am a data processing expert with more than five years of experience working on Excel & VBA. I have worked on a number of projects that required repetitive tasks to be automated, such Flere

$112 USD på 1 dag
(5 bedømmelser)
2.6
AshwinSurathkal

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 Flere

$100 USD in 4 dage
(3 bedømmelser)
1.6
publishwiki20

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 Flere

$100 USD in 5 dage
(1 bedømmelse)
0.4
cannomarsh

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 Flere

$140 USD in 7 dage
(0 bedømmelser)
0.0
jamesgordon01791

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 Flere

$140 USD in 5 dage
(0 bedømmelser)
0.0
PowerRapto

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.

$100 USD in 7 dage
(0 bedømmelser)
0.0
rashidamjad

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 Flere

$250 USD in 8 dage
(1 bedømmelse)
0.0