Excel 2013 - bringing in a custom list from another Excel spreadsheet


I have created a simple custom list in an Excel spreadsheet (Spreadsheet_A).  I have successfully linked the spreadsheet to another spreadsheet (Spreadsheet B).

I can see the values in the Spreadsheet_A when I bring up the custom lists dialog.

Can someone tell me how to copy the custom list into Spreadsheet_B?
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You want VBA or manually ?
moriniaAdvanced Analytics AnalystAuthor Commented:
Can you post the workbook ? as I don't really understand your question.
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

ProfessorJimJamMicrosoft Excel ExpertCommented:
Custom list should be available in all workbooks, if you have created it in the same machine.

if you are bringing a workbook Spreadsheet_A that had used custom list which it was set up in a different machine then here you need to do the followings to make it work in  (Spreadsheet B)

first thing,  open Spreadsheet_A that has custom list already  put the first value of the custom list in a cell and drag down so that it fills the details of the custom list into the excel range of cells.

then go to Excel<File<Options<Advanced   there  scroll down until "General" and you find the Custom List under the "General"   then  the diologbox opens as you can see in the embedded image below.

select NEW LIST as shown in screenshot then click ADD then on the small range box next to "Import" button click and then select the range where you have put the custom list of Spreadsheet_A  then click on "Import" and then "OK" and then your custom list will be avilable in all of the workbooks in the current machine.

moriniaAdvanced Analytics AnalystAuthor Commented:

I am able to import the list in.  My question is, how do I now bring it into a new spreadsheet, once the list is in "Custom Lists"?
ProfessorJimJamMicrosoft Excel ExpertCommented:
ok this is simple

find out what is the first value in the custom list

lets assume your custom list is like this

then as you can see put the first value in the custom list in any cell then move the cursur of the mouse to the cornor of the cell until you see a black cross then click on that cross and drag it either vertically or horizontally then you will see that it works and the next cells values will be the values in your custom list.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Not my cup of tea these custom lists ... hv never had to work with those. good material we never cease to learn.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.