VBA code to transfer data to another table

[ramo114]

Hello helpers,

please help me get some VBA code for the following:

1. I have Table 1 and table 2.
2. Data about products get entered in Table 1 and transfered to Table 2
3. Products are numbered but there could be several products with the same number
4. On selecting L3, I want the code to check if there are entries in Table 2 for the selected product. If there are, they should be populated in Table 1. Otherwise, new entries will be recorded in Table 1 which should be transfered to Table 2
5. After transfering to Table 2, I want Table 1 cleared for the next entry
6. If data already exist in Table 2 and then shown in Table 1 on selecting product number in L3, any updates to the existing entries should update Table 2 as well.

[dflak]

I am not sure what you mean by "After transferring to Table 2, I want Table 1 cleared for the next entry."

We are transferring FROM Table2 to Table1.

As for updating items in Table 2 when an item with that number is changed in Table 1, that cannot be done due to ambiguous primary keys. For example if I update one of the item 3s in Table 1 which item 3 do I update in Table 2?

Attached is as far as I could take it with the given instructions.