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.

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.

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.