Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi~
I have been hooked up with a very nice VLookup tool for my companies shipping request form (thank you Gord!). Several "Lists" of data is stored in Sheet2, most used for the company Vlookup, other as simple DV dropdown. I would like to know if anyone out there would be willing to send me the code or let me send them my workbook to allow new entries into any dropdown cell to be auto added to its source list, alphabetically. Per Contextures.com, there is a macro that enables this and VB does a fly by on me. The sample spreadsheet I was looking at was "Update Multiple Validation Lists". Thanks as always! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO | Excel Discussion (Misc queries) | |||
Creating a summary list from source data - can you?? | Excel Discussion (Misc queries) | |||
Auto scroll down data validation list | Excel Discussion (Misc queries) | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) |