Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Creating a list with entries from cells and manual entry too

I want to create a list with the values populated from some cells and also
include to the list
"None"
"All"

For the time being, I have asked the individuals to do a manual entry. And
have removed the Error Alert function. It works. But is there a way I can
append to the list of the cells additional values also?

Pls suggest.

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,420
Default Creating a list with entries from cells and manual entry too

What do you have already that populates that list?

--
__________________________________
HTH

Bob

"Rims" wrote in message
...
I want to create a list with the values populated from some cells and also
include to the list
"None"
"All"

For the time being, I have asked the individuals to do a manual entry. And
have removed the Error Alert function. It works. But is there a way I can
append to the list of the cells additional values also?

Pls suggest.

Thanks!



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Creating a list with entries from cells and manual entry too

I have a column with a list of steps in Column A
Step 1
Step 2
......
Step n

Adjacent to these columns, I have to enter whether they can go parallel or
not. And if parallel then with which step. The user can select the Step
number from the drop down. Some may not have any other step in parallel. For
them they need to write "None"

My output should be something like say:

Column A Column C (List)
Step 1 Step 7
Step 4 None
Step 8 Step 1






"Bob Phillips" wrote:

What do you have already that populates that list?

--
__________________________________
HTH

Bob

"Rims" wrote in message
...
I want to create a list with the values populated from some cells and also
include to the list
"None"
"All"

For the time being, I have asked the individuals to do a manual entry. And
have removed the Error Alert function. It works. But is there a way I can
append to the list of the cells additional values also?

Pls suggest.

Thanks!




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
Prohibit manual entry via Drop Down Sean Excel Worksheet Functions 2 July 9th 07 11:46 AM
Auto Date with Manual Entry Protection JBallance Excel Worksheet Functions 1 September 23rd 06 02:47 AM
Preventing manual entry in dropdown list ... possible? Maurice Excel Discussion (Misc queries) 4 March 21st 06 06:56 PM
Manual or Formula entry in cell. Naz Excel Discussion (Misc queries) 0 May 24th 05 10:44 PM
Searching a list with repeat entries and creating a sum Brian Connolly Excel Discussion (Misc queries) 1 February 3rd 05 09:41 PM


All times are GMT +1. The time now is 08:37 PM.

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

About Us

"It's about Microsoft Excel"