Fill columns in a table with a text

[Romano_odK]

Good afternoon,

I would like to fill a few columns with a specific text after refreshing. It that possible. I know how I can fill a cell, but a whole column in a table is something I do not know . In my case F H J and L should filled to the bottom of the table column.
Thank you for your time.

Artikelcode	Omschrijving	Std_locatie	Magazijn	Locatie	Query	Locatie	Deel 3
100000	Vito Glaserfix 111 6x2 mm wit - 10x25 m	P02B	1	P02B	Update voorrd set maglok = '		' where artcode = '
100007	Vito Glaserfix 111 9x2 mm zwart - 10x25 m	P03B	1	P03B	Update voorrd set maglok = '		' where artcode = '
100009	Vito Glaserfix 111 9x3 mm zwart - 10x25 m	Q07A	1	Q07A	Update voorrd set maglok = '		' where artcode = '
103008	Vitoglas 120 celband 9x2 mm wit - 5x20 m	P09A	1	P09A	Update voorrd set maglok = '		' where artcode = '
103013	Vitoglas 120 celband 9x5 mm grijs - 10x10 m	P07B	1	P07B	Update voorrd set maglok = '		' where artcode = '
103020	Vitoglas 120 celband 12x3 mm grijs - 10x20 m	P07A	1	P07A	Update voorrd set maglok = '		' where artcode = '
103033	Vitoglas 120 celband 19x3 mm wit - 5x20 m	P09C	1	P09C	Update voorrd set maglok = '		' where artcode = '
104002	Vitoglas 120 celband 6x4 mm grijs - 320 m	Q03A	1	Q03A	Update voorrd set maglok = '		' where artcode = '

 

[awoohaw]

Thanks for using the xl2bb add in to post. But, we do not know what columns in your post are F,H,J, & L. When using the xl2bb add in it is usually best to post
as a "mini sheet" with all the "selections selected":

 

[Romano_odK]

Locatie controle 3.13.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1		14/09/2023				Update voorrd set maglok = '		' where artcode = '		' and magcode = '		'
2	Artikelcode	Omschrijving	Std_locatie	Magazijn	Locatie	Query	Locatie	Deel 3	Artikelcode	Deel 5	Magazijncode	Deel 6	Samengevoegd
3	100000	Vito Glaserfix 111 6x2 mm wit - 10x25 m	P02B	1	P02B	Update voorrd set maglok = '		' where artcode = '	100000	' and magcode = '	1	'	Update voorrd set maglok = '' where artcode = '100000' and magcode = '1'
4	100007	Vito Glaserfix 111 9x2 mm zwart - 10x25 m	P03B	1	P03B	Update voorrd set maglok = '		' where artcode = '	100007	' and magcode = '	1	'	Update voorrd set maglok = '' where artcode = '100007' and magcode = '1'
5	100009	Vito Glaserfix 111 9x3 mm zwart - 10x25 m	Q07A	1	Q07A	Update voorrd set maglok = '		' where artcode = '	100009	' and magcode = '	1	'	Update voorrd set maglok = '' where artcode = '100009' and magcode = '1'
6	103008	Vitoglas 120 celband 9x2 mm wit - 5x20 m	P09A	1	P09A	Update voorrd set maglok = '		' where artcode = '	103008	' and magcode = '	1	'	Update voorrd set maglok = '' where artcode = '103008' and magcode = '1'
7	103013	Vitoglas 120 celband 9x5 mm grijs - 10x10 m	P07B	1	P07B	Update voorrd set maglok = '		' where artcode = '	103013	' and magcode = '	1	'	Update voorrd set maglok = '' where artcode = '103013' and magcode = '1'
8	103020	Vitoglas 120 celband 12x3 mm grijs - 10x20 m	P07A	1	P07A	Update voorrd set maglok = '		' where artcode = '	103020	' and magcode = '	1	'	Update voorrd set maglok = '' where artcode = '103020' and magcode = '1'
9	103033	Vitoglas 120 celband 19x3 mm wit - 5x20 m	P09C	1	P09C	Update voorrd set maglok = '		' where artcode = '	103033	' and magcode = '	1	'	Update voorrd set maglok = '' where artcode = '103033' and magcode = '1'
10	104002	Vitoglas 120 celband 6x4 mm grijs - 320 m	Q03A	1	Q03A	Update voorrd set maglok = '		' where artcode = '	104002	' and magcode = '	1	'	Update voorrd set maglok = '' where artcode = '104002' and magcode = '1'
11	104004	Vitoglas 120 celband 9x3 mm grijs - 480 m	Q04A	1	Q04A	Update voorrd set maglok = '		' where artcode = '	104004	' and magcode = '	1	'	Update voorrd set maglok = '' where artcode = '104004' and magcode = '1'
Standaardlocatie

Cell Formulas
Range	Formula
I3:I11	I3	=[@Artikelcode]
K3:K11	K3	=[@Magazijn]
M3:M11	M3	=CONCAT(Table_Query_from_100[@[Query]:[Deel 6]])

I understand, I added it the right way now.