**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.*