Ask Your Question
1

Link to external file for dropdown list

asked 2020-07-23 20:31:31 +0200

richramik@yahoo.com gravatar image

Hey Gang:

I'll try again.

FILE A contains some formatted data. FILE B contains a list of cities.

I need to reference the cities in FILE B in order to populate a cell in FILE A.

How do I reference/link the list in FILE B??????

Thanks, Rich Ramik

edit retag flag offensive close merge delete

Comments

It is my understanding that you want to link to data stored inside an external secondary spreadsheet, is this correct?

lazarus477 gravatar imagelazarus477 ( 2020-07-24 02:16:11 +0200 )edit

Yes.

FILE A will have the link to the drop down list that is stored in FILE B (city names).

Ideally, the list in FILE B will be seen in FILE A, then select the appropriate city.

richramik@yahoo.com gravatar imagerichramik@yahoo.com ( 2020-07-27 17:27:33 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2020-07-23 21:59:45 +0200

richramik@yahoo.com gravatar image

I followed your instructions, but ended up with an error reference. See the following.

C:\fakepath\WHAT I DID.odt

Thanks, Rich Ramik

edit flag offensive delete link more

Comments

Don’t think the #REF! Is correct.

You're right, after this step, everything else no longer made sense. In cells B3: B5 City 1 .City 2. City 3 should have appeared, and not an error. Hmmm... Can you try doing it on some other computer? Perhaps there is a problem with the settings of this particular computer (system, office)?

JohnSUN gravatar imageJohnSUN ( 2020-07-24 05:14:27 +0200 )edit

Will do later today. I'll post results.

richramik@yahoo.com gravatar imagerichramik@yahoo.com ( 2020-07-24 15:55:42 +0200 )edit

By the way, I'm running 6.4.5.2

richramik@yahoo.com gravatar imagerichramik@yahoo.com ( 2020-07-24 15:59:03 +0200 )edit
0

answered 2020-07-24 02:20:11 +0200

lazarus477 gravatar image

If you wish to link to data stored in an external file then try following these instructions: Link to External Data

edit flag offensive delete link more

Comments

This is inserting all of the cities in FILE B. I need a drop down of the cities so I am able to select the appropriate city.

richramik@yahoo.com gravatar imagerichramik@yahoo.com ( 2020-07-27 17:31:14 +0200 )edit
0

answered 2020-07-23 20:54:31 +0200

JohnSUN gravatar image

What's the problem? Open both files. Select file B. Select all cities and copy. Switch to file A, in an empty space, press Ctrl+Shift+V, mark Link and press OK.

InsLink.png

Press F2 to go to cell editing, select the resulting formula and copy. Create a data validity allow cell range, in the Source paste the formula you just copied. Make sure everything works as it should and clear the inserted list of cities, it is no longer needed.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-07-23 20:31:31 +0200

Seen: 42 times

Last updated: Jul 24