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.