Question description:
This user has given permission to use the problem statement for this
blog.
I need to know if there is a formula that can take a list of names and return them into separate tables, a few rows apart
Solved by Z. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
04/12/2017 - 09:11
hi
User
04/12/2017 - 09:11
Hello. I'll paste and example
Excelchat Expert
04/12/2017 - 09:11
my name is mahmud
User
04/12/2017 - 09:14
Is there a way to get this list of names separated into the first cell under "worker..." in each table
Excelchat Expert
04/12/2017 - 09:17
sorry got cut off
Excelchat Expert
04/12/2017 - 09:17
ok im here
Excelchat Expert
04/12/2017 - 09:18
ok i think you solution will be using a macro
Excelchat Expert
04/12/2017 - 09:19
which version of excel are you using?
User
04/12/2017 - 09:21
10, This is going to be a fairly large file. Is there a formula that can be used instead? Would a macro interrupt the other sheets?
Excelchat Expert
04/12/2017 - 09:23
is the list's length fixed?
Excelchat Expert
04/12/2017 - 09:23
say you have 10 items on the list of names?
User
04/12/2017 - 09:24
the list is not fixed because we could lose or gain a worker at anytime
User
04/12/2017 - 09:25
Using excel 2010
Excelchat Expert
04/12/2017 - 09:26
i suggest you get 2016
Excelchat Expert
04/12/2017 - 09:26
a macro will do it
Excelchat Expert
04/12/2017 - 09:27
we copy the list as the first step for the macro
Excelchat Expert
04/12/2017 - 09:27
then we paste it where we want it
Excelchat Expert
04/12/2017 - 09:27
then we create a button and assign the macro to it
Excelchat Expert
04/12/2017 - 09:29
also, we can use a formula with some criteria to vlookup the list
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.