VBA Code needed to repeat formulas

[AbuFawaz]

You guys have helped me in the past and I'm sure you will help me again:

So I have Sheet1 that includes a list of assets from which I generate cash flows

A B C D 1 Asset No. Asset Name Duration (Months) Cost 2 1 Asset 1 12 5,000 3 2 Asset 2 15 15,000 4 3 Asset 3 10 4,500 <colgroup><col span="5"></colgroup><tbody> </tbody>

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

in Sheet2 I have a set of formulas to produce the cash flows in this range (A1:J75).

What I desperately need is for this code to be able to repeat this range of formulas for each asset on top of each other so I can use them as a database later for dashboarding purposes.

Many thanks in advance.

 

[DanteAmor]

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

On sheet 2, give a couple of examples of formulas for two assets.

 

[AbuFawaz]

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

On sheet 2, give a couple of examples of formulas for two assets.

Perhaps I have made my question a bit hard, all I need is to repeat the same set of formulas in the range (A1:J75) for multiple times, like I need the same formulas to be in range (A76:J150) and then (A151:J225) and so on... lets say for 100 times or more.

 

[KennyGreens]

Perhaps I have made my question a bit hard, all I need is to repeat the same set of formulas in the range (A1:J75) for multiple times, like I need the same formulas to be in range (A76:J150) and then (A151:J225) and so on... lets say for 100 times or more.

I'm rather confused, if the exact same formula is going to be used in the range (A1:J225) why not just use the autofill feature for the formula? Why do you need a macro for this? Is it because there is data past the range A1:J225 that you do not want using the formula?

 

[AbuFawaz]

I'm rather confused, if the exact same formula is going to be used in the range (A1:J225) why not just use the autofill feature for the formula? Why do you need a macro for this? Is it because there is data past the range A1:J225 that you do not want using the formula?

I have it figured with no macros but what I need is a macro that will repeat the same calculations of the range and output the values only not the formulas. Sorry english is not my first language so I might have asked the question in a wrong way.