Want to autofill cells with formulas in a range with a dynamic numbe of rows

[hgeo24]

Hi,

I am new to VBA and have been stumped with an issue I'm facing. In Column L, I have a list of ID numbers starting in cell L7 (there are headers above), but the number of rows varies from week to week. Columns M:AB will be filled with formulas (each column will have a different one) and will go down as many rows as there are rows with ID numbers in Column L. I currently don't have any code written for this procedure because I don't know where to start.

Any suggestions would be greatly appreciated.

[Mojave]

Howdy,

I would start by turning your data into an actual "Table".

In L6:AB6, you should have titles, or field headings.
In L7, enter in an ID number.
In M7:AB7, enter in your formulas.

Highlight L6. Oh shoot. I just saw that you are on 2003. I don't remember the sequence for that.
In 2007-13, you click INSERT TABLE from the menu ribbon.
There must be some kind of menu function for 2003.

After the table is made, you can click on the blank line L8 and enter an ID.
The table (aka List Oject) recognizes your entry and expands the table to cover your entry. It also copies down the formulas from the other columns.

No Macros, no programming.

Use the Delete options to delete table rows for future use.