Populate cells when filling a value in another cell

[Romano_odK]

Good evening,

Got a table and in that table I got cell G5 which is empty. When I put a value in it, it should then populate table column G starting with the header on G6 until the end of that table column with that same value. When I clear cell G5 it should also empty column G. Is that possible?

Thank you for your time,

Kind regards,

Romano

 

[BSALV]

It's a table so if you enter the formula in G7 =$G$5 it's for the whole listcolumn, without the header.
You can't apply a formula in the header.

 

[Romano_odK]

It's a table so if you enter the formula in G7 =$G$5 it's for the whole listcolumn, without the header.
You can't apply a formula in the header.

Good evening,
Thank you for your reply. This I know, but that won’t solve my problem in this case, there can’t a formula in the column cell unfortunately.