Hello, How I can extract unique data from table based on a criteria from another sheet and put the result on the same sheet where the criteria

[Rahaf]

Hello, How I can extract unique data from a table based on criteria from another sheet and put the result on the same sheet where the criteria
with auto adjust the result in the range with vba

 

[Luke M]

I'd suggest running an Adv Filter. It's designed so that you have a data table, criteria range, and output range. You can also sepcify unique records only. It's easy enough to do manually, but if you want to use VB: https://www.contextures.com/exceladvancedfiltervba.html

 

[inddon]

Hello, How I can extract unique data from a table based on criteria from another sheet and put the result on the same sheet where the criteria
with auto adjust the result in the range with vba

Hello Rahaf,

See if this helps you:
https://chandoo.org/forum/threads/c...k-to-another-using-ado-sql.41488/#post-247529

It is using the DAO method (SELECT statement). In Sub
Sub RS2WS, it rearranges the columns.
This is based on external workbook, Data Tables. You can reference the external workbook as your current workbook