Loop - Do until based on the numbers of rows from database

Hey folks,

So I am having some problems to find out a code that could help me to complete a simple task. I basically have a gigantic database held by an independent range of formulas. Everytime that I refresh the database (using another code that I created) new lines are added to it. However, the independent range of formulas that I've just mentioned, does not follow the change (obviously), and that's where my problems begin.

I want to create a loop that copy a range of formulas from the cells above, and do this action based on the numbers of rows that my database has.

Do you guys have any ideas?

If you could attached a sample workbook as stated in yellow above this page, it would help get you answers and examples.
Sound like you would need a variable to hold the record count from the database to use as a part of a dynamic range so that the formulas are applied down..

And just to be clear, all this is within an excel worksheet correct

Here is how i use something similar in my reports.. Obviously adjust the ranges and worksheet names

    Dim LastRow As Long

    ' THIS GET A TOTAL COUNT OF ROWS BASED ON THE DATABASE
    LastRow = ThisWorkbook.Worksheets("XXXXXX").Range("A" & Rows.Count).End(xlUp).Row

    ' APPLY FORMULA
    ThisWorkbook.Worksheets("XXXXXX").Range("K2").FormulaR1C1 = "=DAYS(TODAY(),RC[-8])"

    ' AUTOFILL DOWN THE FORMULA TO THE APPROPRIATE FIELDS BASED ON THE LAST ROW OF THE DATABASE
    ThisWorkbook.Worksheets("XXXXXX").Range("K2").AutoFill Destination:=ThisWorkbook.Worksheets("XXXXXX").Range("K2:K" & LastRow)

Now if you already have the formula setup in the cell, you can always find the last row of the formula column and apply the autofill from there .
Seems there may be 2 ways to do it..

#1 handle the entire process in VBA, assign the formula and autofill all in the macro
#2 apply the formula on the sheet/cell then autofill in the macro

You are specifically asking about looping code so the minimum we need is to see what your looping code says.

Better still upload the workbook, anonymised if necessary. Pictures are rarely much help. Remove unnecessary rows, we don't need to see zillions, just as long as it is truly representative.

That said, problems with loops are often associated by making changes to rows within the loop. Try processing the loop from the bottom row upwards.

If you found the suggestion or solution helpful, please consider adding reputation to the post. Thank you