creating dropdown list

[ttowncorp]

im trying to create a dropdown list were for example if i pick "bus-1234" the information under that changes as well. i'm trying to track 1616 buses with ongoing service issues. so i need a 365 rows with 4 columns. "A" will be the column numbers 1-365. "B" column is the date, "C" column is the problem and "D" column is the diagnosis all seperated by thick box borders. problem and diagnosis is nine rows height, 7 column wide with "merge to center" selected. big enough so i can add information in these cells. is this possible?

 

[ttowncorp]

this is perfect. are buses start at 2118. but this is great. i just got to make some tweaks but this is what i was looking for. thank you

 

[ttowncorp]

thanks you for the help. i have one more question. how would i move the on sheet 1(interface) cell A2 to C1 and A4-E4 up to A2-E4 without interfering with the codeing you made for me. or what do i need to change in the code if i rearrange the "interface" sheet one

 

[Roderick_E]

Look in the code for all instances of A2 and change to what you need. Remember to also right click on INTERFACE tab and VIEW CODE, change it there too as well as the saveupdate macro.

 

[Roderick_E]

That won't be enough to fix the other issue you want with starting the data on a different line.