Stuart Stout
asked on
VBA to remove duplicated lines from 2 tables pulled from a url
Hello.
on the attached ss the URL tab, I have 2 tables being pulled from a url, what i need to do is remove the lines in the second table l18:t78 where they appear in the top 24 rows of the first table B18:j78.
ASA--Swimming---2018-British---Home.xlsm
on the attached ss the URL tab, I have 2 tables being pulled from a url, what i need to do is remove the lines in the second table l18:t78 where they appear in the top 24 rows of the first table B18:j78.
ASA--Swimming---2018-British---Home.xlsm
ASKER
hi, due to both tables being a qualification list that is not an option.
Do you need to compare both lists or not?
ASKER
I need to remove the line in the second table where it appears in the top 24 rows of table 1
ASKER
the data in the tables is fluid and changes daily plus depends upon the selection made in rows 4, 6, 7 & 8
If a row from table2 appears below row24 of table1, should it remain intact? i.e. not considered as a duplicate row?
ASKER
yes, only remove from table 2 if it appears in the top 24 rows of table 1 .
the data in the tables is fluid and changes daily plus depends upon the selection made in rows 4, 6, 7 & 8
You have to scan the list per your given conditions you already mentioned
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Just the job. Did exactly what was required many thanks
You're welcome Stuart!
2. Then use a loop to scan through the list to find out duplicated lines.