Fill columns in a table with a text

Romano_odK

Active Member
Joined
Jun 4, 2020
Messages
380
Office Version
  1. 365
Platform
  1. Windows
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.

ArtikelcodeOmschrijvingStd_locatieMagazijnLocatieQueryLocatie Deel 3
100000Vito Glaserfix 111 6x2 mm wit - 10x25 mP02B1P02BUpdate voorrd set maglok = '' where artcode = '
100007Vito Glaserfix 111 9x2 mm zwart - 10x25 mP03B1P03BUpdate voorrd set maglok = '' where artcode = '
100009Vito Glaserfix 111 9x3 mm zwart - 10x25 mQ07A1Q07AUpdate voorrd set maglok = '' where artcode = '
103008Vitoglas 120 celband 9x2 mm wit - 5x20 mP09A1P09AUpdate voorrd set maglok = '' where artcode = '
103013Vitoglas 120 celband 9x5 mm grijs - 10x10 mP07B1P07BUpdate voorrd set maglok = '' where artcode = '
103020Vitoglas 120 celband 12x3 mm grijs - 10x20 mP07A1P07AUpdate voorrd set maglok = '' where artcode = '
103033Vitoglas 120 celband 19x3 mm wit - 5x20 mP09C1P09CUpdate voorrd set maglok = '' where artcode = '
104002Vitoglas 120 celband 6x4 mm grijs - 320 mQ03A1Q03AUpdate voorrd set maglok = '' where artcode = '
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
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":

1694698813580.png
 
Upvote 0
Locatie controle 3.13.xlsm
ABCDEFGHIJKLM
114/09/2023Update voorrd set maglok = '' where artcode = '' and magcode = ''
2ArtikelcodeOmschrijvingStd_locatieMagazijnLocatieQueryLocatie Deel 3Artikelcode Deel 5MagazijncodeDeel 6Samengevoegd
3100000Vito Glaserfix 111 6x2 mm wit - 10x25 mP02B1P02BUpdate voorrd set maglok = '' where artcode = '100000' and magcode = '1'Update voorrd set maglok = '' where artcode = '100000' and magcode = '1'
4100007Vito Glaserfix 111 9x2 mm zwart - 10x25 mP03B1P03BUpdate voorrd set maglok = '' where artcode = '100007' and magcode = '1'Update voorrd set maglok = '' where artcode = '100007' and magcode = '1'
5100009Vito Glaserfix 111 9x3 mm zwart - 10x25 mQ07A1Q07AUpdate voorrd set maglok = '' where artcode = '100009' and magcode = '1'Update voorrd set maglok = '' where artcode = '100009' and magcode = '1'
6103008Vitoglas 120 celband 9x2 mm wit - 5x20 mP09A1P09AUpdate voorrd set maglok = '' where artcode = '103008' and magcode = '1'Update voorrd set maglok = '' where artcode = '103008' and magcode = '1'
7103013Vitoglas 120 celband 9x5 mm grijs - 10x10 mP07B1P07BUpdate voorrd set maglok = '' where artcode = '103013' and magcode = '1'Update voorrd set maglok = '' where artcode = '103013' and magcode = '1'
8103020Vitoglas 120 celband 12x3 mm grijs - 10x20 mP07A1P07AUpdate voorrd set maglok = '' where artcode = '103020' and magcode = '1'Update voorrd set maglok = '' where artcode = '103020' and magcode = '1'
9103033Vitoglas 120 celband 19x3 mm wit - 5x20 mP09C1P09CUpdate voorrd set maglok = '' where artcode = '103033' and magcode = '1'Update voorrd set maglok = '' where artcode = '103033' and magcode = '1'
10104002Vitoglas 120 celband 6x4 mm grijs - 320 mQ03A1Q03AUpdate voorrd set maglok = '' where artcode = '104002' and magcode = '1'Update voorrd set maglok = '' where artcode = '104002' and magcode = '1'
11104004Vitoglas 120 celband 9x3 mm grijs - 480 mQ04A1Q04AUpdate voorrd set maglok = '' where artcode = '104004' and magcode = '1'Update voorrd set maglok = '' where artcode = '104004' and magcode = '1'
Standaardlocatie
Cell Formulas
RangeFormula
I3:I11I3=[@Artikelcode]
K3:K11K3=[@Magazijn]
M3:M11M3=CONCAT(Table_Query_from_100[@[Query]:[Deel 6]])


I understand, I added it the right way now.
 
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top