Jul 09 2021 04:59 AM
Hi guys,
What is the best solution for me to search a name in the table and copy/pull these rows with these names below and add in a different sheet.
For example
Sheet 1
column A ( I have few names)
Jaime 18, UAT 111111-0000
Kristian
Paula
Sheet 2 -
column A ( I have few names) Column B ( address) C ( Telephone)
Jaime 18, UAT 111111-0000
Kristian 10, Br 000000-000000
Paula 1 Buckingham Palace 1000-000000
I have 5000 records in the sheet 2
I want to take all rows with those names Jaime, Kristian and Paula that are in the sheet1 and search all these names in the sheet 2 and when they found this name take the rows and add these rows in a different sheet. What is the best way to search these names from the Sheet1 and pool the information from the table sheet2 and add in the sheet3 ?
I really appreciate if you can help me.
Thanks,
Jaime.
Jul 09 2021 07:31 AM
Please click and read this Link, will help us all to find a solution for you.
Otherwise we need too much time to explore the issue.
Time what we can invest in other issues.
Welcome to your Excel discussion space!
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Jul 09 2021 09:28 PM - edited Jul 09 2021 09:30 PM