Hi,



I'm not totally familiar with excel and I need to extract data from tab 1 to tab 2.

But using a list of names in tab 2 I need it to show only the data of specific people (I don't want to use only the filter option shift+ctrl+L).

Then, every time I type a name in tab 2, it reflects the proper in each cell according to the name it belongs to. See mage attached

Let me know if this explanation is enough or you need me to explain further.

Thanks in advance,

Attached Images

example of data.jpg (135.1 KB, 18 views)

A workbook, rather than a picture of one, would go a long way to encourage people to help you.

Hi p45cal,

Done.

Thanks for the advice.

Attached Files

Performance Report Annual test.xlsx (25.1 KB, 9 views)

See attached.

Attached Files

MSOfficeForums38783Performance Report Annual test.xlsx (24.8 KB, 22 views)

Awesome work, exactly what I needed.

Appreciate the help.