Hi all,
i am very new to VBA, and i am looking for a solution for the following problem.
( i expect for a VBA veteran it would be a simple problem. )
i want the macro to check if L8 & N8 till Q8 (same for L9, N9-Q9) already exists in sheet 2 ("Voorraad") table.
if yes then it needs it to update (overwrite) it with the Qty from M8 in the first sheet ("Optimalisatie")
if no, then it needs to add a row below the table in sheet "Voorraad" and copy in the data from L8 till Q8
i am very new to VBA, and i am looking for a solution for the following problem.
( i expect for a VBA veteran it would be a simple problem. )
i want the macro to check if L8 & N8 till Q8 (same for L9, N9-Q9) already exists in sheet 2 ("Voorraad") table.
if yes then it needs it to update (overwrite) it with the Qty from M8 in the first sheet ("Optimalisatie")
if no, then it needs to add a row below the table in sheet "Voorraad" and copy in the data from L8 till Q8