Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 1st 05, 11:55 PM
Landerson
 
Posts: n/a
Default right click option "pick from a list"

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.

  #2   Report Post  
Old February 2nd 05, 01:09 AM
Gord Dibben
 
Posts: n/a
Default

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

On Tue, 1 Feb 2005 14:55:03 -0800, Landerson
wrote:

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.


  #3   Report Post  
Old February 2nd 05, 01:14 AM
Debra Dalgleish
 
Posts: n/a
Default

You can use an Advanced Filter to export a unique list of items. There
are instructions in Excel's Help, and he

http://www.contextures.com/xladvfilter01.html

Landerson wrote:
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.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pick from a list Alicia Excel Worksheet Functions 2 July 31st 08 03:20 PM
Undoing LINKS in Excel 2000 jayceejay New Users to Excel 3 January 4th 05 06:58 PM
How do I pick a number from a list in Excel? pugsly8422 Excel Worksheet Functions 4 January 3rd 05 07:07 PM
Pick From List Barry Excel Discussion (Misc queries) 1 December 23rd 04 02:08 PM
Data Validation List Option Affecting Other Cells? tomrobs Excel Worksheet Functions 1 November 5th 04 05:26 PM


All times are GMT +1. The time now is 02:27 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017