Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DropDown List on the fly
I have what I think is a hard 1 but knowing the help given here maybe not.
I have a master sheet sheet1. I have several other sheets, sheet2, sheet3, sheet4, sheet5. On sheet1 I have a name in column B Cell 2. On sheet1 I have the days of the month in column A starting at cell3. So it looks like this. A B Days Dave Bill Andy 01 02 03 04 On sheet2 trhough sheet5 I J K L M N Dave 123 423 8764 2476 126758 Bill 78654 1324 Andy 132 Jack Sheets3 through 5 same as above except the numbers are not the same. What I am looking for is a dropdown list to be created on sheet1 under each name for each day. in the example above on day 01 a dropdown list would be created the the above numbers under Dave 123 423 8764 2476 126758 Under Bill 78654 1324 Under Andy 132 Under Jack No dropdown Sheets2 through 5 will be populated on different days of the month. (The reason for on the fly) I would think this would be done with VBA but not sure. I could run a macro whenever I need the information on sheet1. Thanks in advance for all your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
DropDown List on the fly
http://pmexcelent.dk/test.xls
"Learning VBA" skrev: I have what I think is a hard 1 but knowing the help given here maybe not. I have a master sheet sheet1. I have several other sheets, sheet2, sheet3, sheet4, sheet5. On sheet1 I have a name in column B Cell 2. On sheet1 I have the days of the month in column A starting at cell3. So it looks like this. A B Days Dave Bill Andy 01 02 03 04 On sheet2 trhough sheet5 I J K L M N Dave 123 423 8764 2476 126758 Bill 78654 1324 Andy 132 Jack Sheets3 through 5 same as above except the numbers are not the same. What I am looking for is a dropdown list to be created on sheet1 under each name for each day. in the example above on day 01 a dropdown list would be created the the above numbers under Dave 123 423 8764 2476 126758 Under Bill 78654 1324 Under Andy 132 Under Jack No dropdown Sheets2 through 5 will be populated on different days of the month. (The reason for on the fly) I would think this would be done with VBA but not sure. I could run a macro whenever I need the information on sheet1. Thanks in advance for all your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
DropDown List on the fly
That did it Thank you so much for your help.
"excelent" wrote in message ... http://pmexcelent.dk/test.xls "Learning VBA" skrev: I have what I think is a hard 1 but knowing the help given here maybe not. I have a master sheet sheet1. I have several other sheets, sheet2, sheet3, sheet4, sheet5. On sheet1 I have a name in column B Cell 2. On sheet1 I have the days of the month in column A starting at cell3. So it looks like this. A B Days Dave Bill Andy 01 02 03 04 On sheet2 trhough sheet5 I J K L M N Dave 123 423 8764 2476 126758 Bill 78654 1324 Andy 132 Jack Sheets3 through 5 same as above except the numbers are not the same. What I am looking for is a dropdown list to be created on sheet1 under each name for each day. in the example above on day 01 a dropdown list would be created the the above numbers under Dave 123 423 8764 2476 126758 Under Bill 78654 1324 Under Andy 132 Under Jack No dropdown Sheets2 through 5 will be populated on different days of the month. (The reason for on the fly) I would think this would be done with VBA but not sure. I could run a macro whenever I need the information on sheet1. Thanks in advance for all your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dropdown list determined by another dropdown list | Excel Discussion (Misc queries) | |||
Excell Dropdown List. Display alternate text than found in list. | Excel Discussion (Misc queries) | |||
Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions |