Excel - Split one LONG column into two smaller columns

Hi Experts,
I have a workbook that has a table with a long list of names.
I want to copy the list of names and split it into two columns so it is easy to print.

I also have a small list that I also want to copy into the same remote sheet without splitting.

I would love it if it was easy to change the size of the range if names are added, or if columns change later on.
Thanks so much

Have a look.
Image helperSource.xlsx
Remote.xlsx
chris pikeAsked:
Who is Participating?
 
Ejgil HedegaardConnect With a Mentor Commented:
Here is a solution with formulas.
Names in 2 tables in source workbook.
I duplicated the names to show the result.
Table1 split at position 46, with values up to 60 if exist.
Table2 start in position 61 as shown in picture.
Save both workbooks in same folder, then Excel will make the links work.
Source.xlsx
Remote.xlsx
0
 
Roy CoxGroup Finance ManagerCommented:
There's no data in the Remote workbook and very little in the other one.
0
 
chris pikeAuthor Commented:
They are dummy sheets, on the data sheet you will have 40ish cells of names

I want to split it into two columns on the remote sheet in those exact locations

I hope that helps
Thanks
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Roy CoxGroup Finance ManagerCommented:
There's only 10 names in the example.

I can't see what exact locations you mean.

When you post example workbooks make sure that you demonstrate the source data and the required result exactly, that will help provide an accurate answer.

Do you want a VBA solution?
0
 
chris pikeAuthor Commented:
OK , great I will do that next time for sure.  Thanks

Formula would be great if it is possible, I never have any success with modifying VBA if I have to add of change a row or anything.
Formulas sometimes are a bit easier I think.

I am lost with VBA.
Thanks so much
Chris
0
 
chris pikeAuthor Commented:
THanks Ejgil.
Always appreciate your help/
Chris
0
 
chris pikeAuthor Commented:
Thanks for your help.
Always find a way to make it work.
Cheers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.