**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need to look to a table of data where column 1 represents employee name, and show all rows of that data where the employee name matches a certain value

Solved by K. L. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
15/03/2018 - 12:59

Hi

Excelchat Expert
15/03/2018 - 12:59

Welcome to got it pro

User
15/03/2018 - 01:00

Thanks

Excelchat Expert
15/03/2018 - 01:00

do you have any sample data so that i can help?

Excelchat Expert
15/03/2018 - 01:00

ok

Excelchat Expert
15/03/2018 - 01:01

A1?

User
15/03/2018 - 01:01

No. But lets start with this. In a separate tab I wast to bring back all rows that match Dean

Excelchat Expert
15/03/2018 - 01:01

ohk

User
15/03/2018 - 01:02

I want to bring back something like this

Excelchat Expert
15/03/2018 - 01:02

so you want to search all values against dean in sheet 1 and paste in sheet 2?

User
15/03/2018 - 01:03

Yes

Excelchat Expert
15/03/2018 - 01:03

but there are 2 rows of dean?

User
15/03/2018 - 01:03

Or lots of rows of Dean with other people in between

Excelchat Expert
15/03/2018 - 01:03

ohk

Excelchat Expert
15/03/2018 - 01:05

see columns F, G , H and I

Excelchat Expert
15/03/2018 - 01:05

we can do like this

Excelchat Expert
15/03/2018 - 01:06

get all data for dean in column F,G,H and I

Excelchat Expert
15/03/2018 - 01:06

does this help?

User
15/03/2018 - 01:06

Need to have it not have blank spaces

User
15/03/2018 - 01:06

I have a list of credit card charges for all of our employees in one file

Excelchat Expert
15/03/2018 - 01:06

since there are multiple rows of dean we cannot use proper vlookup also

User
15/03/2018 - 01:06

I need to separate that file into a separate file for each employee

Excelchat Expert
15/03/2018 - 01:06

hence this blank will come

User
15/03/2018 - 01:07

I know...:( That's my struggle

Excelchat Expert
15/03/2018 - 01:07

let me figure out this blank thing

User
15/03/2018 - 01:07

How can we get the blank not to come

User
15/03/2018 - 01:07

Thanks.

Excelchat Expert
15/03/2018 - 01:07

ok

Excelchat Expert
15/03/2018 - 01:07

figuring out

Excelchat Expert
15/03/2018 - 01:09

can we not remove this blank manually?

User
15/03/2018 - 01:10

Manually?

User
15/03/2018 - 01:10

Trying to avoid that

User
15/03/2018 - 01:10

I can sort the raw data by name if I need to

Excelchat Expert
15/03/2018 - 01:10

ok

Excelchat Expert
15/03/2018 - 01:11

so even if the blank come you can sort the data by name

Excelchat Expert
15/03/2018 - 01:11

so blank will automatically move down

Excelchat Expert
15/03/2018 - 01:11

will that help?

User
15/03/2018 - 01:11

??? not sure...how?

Excelchat Expert
15/03/2018 - 01:11

i mean in column f,g,h,and i when dean come

Excelchat Expert
15/03/2018 - 01:11

just sort them by name

Excelchat Expert
15/03/2018 - 01:12

and blank will move dow

Excelchat Expert
15/03/2018 - 01:12

like this?

Excelchat Expert
15/03/2018 - 01:12

will that not help?

User
15/03/2018 - 01:12

I would have to do that to 100 tabs...one for each employee.

Excelchat Expert
15/03/2018 - 01:13

then i guess that can be done using macro

Excelchat Expert
15/03/2018 - 01:13

vba code

Excelchat Expert
15/03/2018 - 01:13

where yo wll have to write a vba code and then run it once

User
15/03/2018 - 01:13

Can you help with that?

Excelchat Expert
15/03/2018 - 01:13

all the data will get sorted in that manner

Excelchat Expert
15/03/2018 - 01:13

i have no idea about vba code

Excelchat Expert
15/03/2018 - 01:13

but i know it can be done

User
15/03/2018 - 01:14

Is there anyone else who we can get to help with this?

Excelchat Expert
15/03/2018 - 01:14

this excel formula should also be pretty useful i guess

Excelchat Expert
15/03/2018 - 01:14

just that blanks are coming

User
15/03/2018 - 01:15

How about this...If I have a file where it is already sorted by name...

User
15/03/2018 - 01:15

Can I get excel to create a new tab for each break in name

Excelchat Expert
15/03/2018 - 01:16

i think that will also need a vba code

Excelchat Expert
15/03/2018 - 01:17

have a go through this

Excelchat Expert
15/03/2018 - 01:17

https://www.extendoffice.com/documents/excel/3196-excel-tab-name-equal-to-cell-value.html

Excelchat Expert
15/03/2018 - 01:17

this will help in vba code

Excelchat Expert
15/03/2018 - 01:18

please do give good rating

Excelchat Expert
15/03/2018 - 01:18

it really helps a lot

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*