Vba to make a database from specific filtered cells in specific columns of various workbooks respect to "no duplication" and sort if there is any link

[amir9510]

Hi Everyone:

I'm new to this forum and I searched my cases and need your help.

I have several workbooks which are reports of different classification of processes of products.(same product but different Serial Numbers).

Now I need to make a database for each Serial No. which includes the whole FILTERED rows (each row has an assigned number) of all reports against this S/N with some characteristics:

1- No duplicated value in updated list
2- Look for any probable link between items
3- If there is a link, put the linked item in a column with the same row, otherwise add in the rows (previous loaded report(s) can be as reference(s)t to find the links)


This reports will be changed always and need to clear last database and make new one,

I really appreciate for your help in advance.

Amir