I need a Formula to copy down cell when table expands.

I have a table that needs a formula for a cell.

When table expands down just copy cell from above to expand with table.

The first example is The table with FIRST row filled with data.
Once the table expands it should copy JUST 4 columns ... B G H I
C D E F are ok , they do not need help.

The second table is how it should look when done.
07.png

Those entries are coming from a data user form... The user inputs that name and it changes when they start using the table.
I posted the original sheet but it is pretty confusing.
I just uploaded the almost orginal one....
The sheet has 2 user forms to input data into theFIRST row of the table. First user form fills in B....G...H....I
Column F auto fills with hidden formula and VBA to put a time stamp when column D has data.
Column C just puts a # using a formula when table expands.
Column D is a manual filled number.
Column E FIRST row is user input, but all rows after auto fill to 3700 when data is entered into Column D
The clear sheet button just clears the first row of data, then all data below and deletes all extra rows leaving only first 2 rows.

The part I need help with right now is when I enter data into D and the table expands, I need the static columns to just copy down that not already do that.
The second table at the bottom is just to show what it should like like if data copies down in B G H I

I hope this makes a little sense.
Thanks so much
Chris

Originally Posted by kvsrinivasamurthy

Try this.
In C11 then copy to G11:I11

=IF(len(C11&D11&E11&F11)>0,C10,"")

Copy down all formulas for few rows. As you fill up D:F data will be copied in other columns.

And you ARE referring to Book2-2 (3) the last book I uploaded right?
Yah I have been playing around with it not having much luck....