right click option "pick from a list"

L

Landerson

i'm wanting to know can the information from the "pick from a drop down list"
list be exported some how? I've been handed a load of spread sheets and been
told to create a database with the information. not that good with either
excel or access as you may guess. So i;m trying to build a table and a form
in access and it would save me loads of time if i could or if anyone can
point me in right direction of the best practice or just point out if i;m
going about things the wrong way.. All help would be very much appreciated.
 
G

Gord Dibben

The items in the right-click "pick from list" are only those text(not
numerics) items entered in contiguous cells in that column.

The list is not stored anywhere but in that column and if changes are made to
data in that column, a new list is formed to pick from.

Sounds like a daunting job in view of the fact you're not that good with
either Excel or Access.

The general pratice is to Open Access and create a DB shell there, importing
the data from Excel.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dependent, multiple variable, drop down list 2
Combo box 0
Drop down list from index/match formula 1
Pick from drop-down list gives empty or erroneous result 6
Help with user selectable data presentation 2
How to pull airport flight time from web to excel? 0
Excel 2007 / right-click / pick from drop down list 1
Pick from list to use in a field 2

Top