repeat formula

I am preparing a cashflow model which has a column with years starting at say 2023 going on for several decades. I wish to make a periodic income in the adjacent column that starts in say 2025 then repeats every say 3 years. Could someone help construct a formula for this? The start year, the...

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 <colgroup><col><col><col><col><col></colgroup><tbody> <colgroup><col span="5"></colgroup><tbody> A B C D 1 Asset No. Asset Name...

I would like to condense all these vba's since they are doing the same thing with just a different variable. I know this is probably easy I'm just not very familiar with VBA yet. Sub ClearUnwantedCells() Dim rng As Range Dim cell As Range Dim ContainWord As String Set rng =...

I have this formula, which does exactly what I want it to, but in a primative way. It searches for numbers that correspond to another sheet, and pulls out corresponding tag names. However it completes row by row. I would like this formula to automatically repeat itself, for the amount of times...

I have been set a task to try and use data that is in excel and automatically fill in a template that at the moment has to be manually input. there is no bulk import feature. In excel i have rows of data, each row has approx 20 fields. each row with 20 fields has to be manually input into...

Hi guys, Can someone help me how I want to make this codes more shorter? which is I can apply this code in all sheets in open workbook? For workbook that have only 29 sheets is still ok for me, but after this I will have 63 sheets every workbook. I had found this code, but it's not work for me...

So my code is working great, but looking at my code I can't help but think that there must be an easier way to loop through the script so it isn't so repetitive. Any thoughts? Sub Macro1() Dim ActSheet As Worksheet Dim JUNCTION As String Dim BOC As String Dim Amount As String...

Morning, I have no idea what I'm doing and I hope I can explain this properly. I run inventory reports 10-15 times a week. Every time I export the file in Excel, I open and do the same 10 steps. Step 1 I highlight from A6-E6 all the way down to A70-E70 (this changes at times as some reports...