Copy lines of data based on a Cell

Hello,

i have a GIANT database to work daily.

I need to copy whole line of data based on the ID, the same ID can repeat many times in the database.

So i have a DB full of data and based on ID i have to extract on full lines so i can work on them

Capture.JPG

I have to search many ID per day so it will save me much time.

Tx in advance

Hello MigueX,

Here's a possibility. Place this code in a standard module and assign it to a button:-

Please Login or Register  to view this content.

Enter an ID into B1 in Sheet2, click on the button and the code will filter for the entered ID in sheet1, Column A and then display the relevant data in Sheet2.

I hope that this helps.

Cheerio,
vcoolio.