DropDown List on the fly

[Learning VBA]

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.

 

[excelent]

http://pmexcelent.dk/test.xls

"Learning VBA" skrev:

 

[Learning VBA]

That did it Thank you so much for your help.

http://pmexcelent.dk/test.xls

"Learning VBA" skrev: