Add missing data at the end of a list

[RSRSRS]

Hello there,

I am looking for a VBA code that would help me to find out which customers are missing in my list vs another list.

Please see attached the file. The tab "SQL" is updated each month with the revenue of customers, name of the customer is in column A, the revenue in column D and name of the product in column C.

I would like to be able to automatically update the tabs "Prod 1", "Prod 2" and "Prod 3" with the new customer names from tab "SQL", I would like the update to be done at the end of the existing list from column A of each of tab Prod 1, Prod 2 and Prod 3. In a second time, do you think it's possible to automatically update the revenue too from columns C, D, E in tabs Prod 1, Prod 2, Prod 3? There is one column per month.

Would somebody be able to help me for the customer list? I am very novice on VBA and the formulas with the INDEX MATCH + array would be too heavy.

Many thanks for your help.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue in your Commercial Services thread.