# Excel Visual Basic Subroutine

İlan edilme: 3 ay önce Teslim sırasında ödenir
Teslim sırasında ödenir

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!

Proje NO: #36717013

### Proje hakkında

43 teklif Uzak proje Aktif 2 ay önce

## Bu iş için 43 freelancer ortalamada \$153 teklif veriyor

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 Daha Fazla

\$180 USD in 5 gün içinde
(580 Değerlendirme)
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 gün içinde
(506 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(783 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(249 Değerlendirme)
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 gün içinde
(188 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(56 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(94 Değerlendirme)
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 Daha Fazla

\$200 USD in 3 gün içinde
(10 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(42 Değerlendirme)
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 Daha Fazla

\$450 USD in 5 gün içinde
(38 Değerlendirme)
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 Daha Fazla

\$140 USD in 7 gün içinde
(4 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
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 Daha Fazla

\$30 USD in 3 gün içinde
(8 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
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 Daha Fazla

\$100 USD in 4 gün içinde
(3 Değerlendirme)
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 Daha Fazla

\$100 USD in 5 gün içinde
(1 Yorum)
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 Daha Fazla

\$140 USD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

\$140 USD in 5 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
0.0