Copy range, but only if value does not exist in table

[Daniel_72]

Hi

I have a workbook with 2 sheets named “Export” and “Data”.

Sheet “Export” have data from B8:G1000 but the number of rows will change every time I update the list.
Sheet “Data” have a table named “Tabell5” and column B in that table is named “order”.

I want to check every row (column B) in sheet “Export” and check if value already exist in sheet “Data” Table column B (columns header named “order”).
If the value already exists, then skip and go to check next row.

If value not exist I want to copy the row from sheet “Export” but only values from range column B:G and then paste it in sheet “data” Table column B:G.
Is it possible to do that? Can someone help me?

Thanks in advance