LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default How can I put a list into a range of cells

On sheet1 cells a1 to a10 have unique values, what I want to do is when a
user clicks on a cell in a range of cells in sheet2 column B the user can
only select the values on sheet1(a1:a10), can someone help me out, thanks in
advance!

 
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
extend the range of cells for a drop down list Marge Excel Worksheet Functions 9 April 4th 23 10:46 AM
List Disctinct Strings from Range of Cells golddave Excel Worksheet Functions 23 December 11th 09 04:18 AM
Create a drop-down list from a range of cells weswhite7 Excel Worksheet Functions 2 July 8th 09 09:50 PM
Can excel list the possible combinations from a range of cells Syndrome Excel Worksheet Functions 6 September 9th 06 09:00 AM
Condensing a list/range with blank cells to a new list/range without blanks KR Excel Worksheet Functions 4 July 5th 05 04:23 PM


All times are GMT +1. The time now is 02:06 PM.

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

About Us

"It's about Microsoft Excel"