How to ferase value in column "Aantal" if "Locatie" is not "A00"

[Romano_odK]

Good afternoon,

I got a table with values that are refreshed from a SQL database. I get lines with itemcode, description etc where the stock is in column "J" (Voorraad) on every location (Locatie). What I would like to accomplish is that I won't see the value in column "Aantal" if the "Locatie" in column "I' is not "A00".
This has to be done every time I refresh the table, can this be done?

Thank you for you time and efforts.

Romano

Artikelcode	Omschrijving	Kostprijs	Vrrdrek	Ontvgstdatum	Aantal	Magazijn	Std_locatie	Locatie	Voorraad
100000	Vito Glaserfix 111 6x2 mm wit - 10x25 m	1	3901	11/07/2023	96	1	P02B	A00	121
100001	Vito Glaserfix 111 6x2 mm zwart - 10x25 m	2	3901	18/04/2023	96	1	P04B	P04B	106
100002	Vito Glaserfix 111 6x3 mm wit - 10x25 m	3	3901	11/07/2023	96	1	P02B	P02B	63
100003	Vito Glaserfix 111 6x3 mm zwart - 10x25 m	4	3901	25/04/2023	96	1	P04B	P04B	40
100004	Vito Glaserfix 111 6x4 mm wit - 10x25 m	5	3901	06/09/2023	96	1	P02B	P02B	97
100004	Vito Glaserfix 111 6x4 mm wit - 10x25 m	6	3901	06/09/2023	96	1	P02B	P02C	60
100005	Vito Glaserfix 111 6x4 mm zwart - 10x25 m	7	3901	31/03/2021	96	1	A00	P04B	53
100006	Vito Glaserfix 111 9x2 mm wit - 10x25 m	8	3901	18/07/2023	60	1	P01B	P01B	20
100007	Vito Glaserfix 111 9x2 mm zwart - 10x25 m	9	3901	16/08/2023	60	1	P03B	P03B	118

 

[Joe4]

I don't see anything in that code that would produce an error, it would just ignore it and go to the next file.
Are you sure that you don't have errors somewhere on your sheet?

Please show/tell us the following:
- What is the exact error message you are getting?
- Does it give you a "Debug" option, and if it does, if you hit it, what line of code does it highlight?
- Can you show us a sample of data when this error occurs?