I very sorry that I wasted your time by not providing enough information.
I am using Excel 2003
And to restate the question:
How do you create a single drop down box to fill multiple cells using a range of entries on a different worksheet
The cell below package type needs to be a drop down box from Worksheet #1
based on the selection in the drop down box, the next two cells need to be filled in by using the related columns
I hope this makes it clearer
Here is the link for the file I made for you.
For more information on how to add combobox, since you do not have the Developer tab in Excel 2003, click on View then point to Toolbars then click Control Toolbox. That is where you can add the ComboBox.
I hope that helped. If you have time to rate my service, that is highly appreciated!If you have any other questions, please ask me or reply to me – I’ll be happy to respond.Thank you!Best regards,Jess
Not sure what you mean by "Point the Combobox Cell value in this selection cell"
Sorry it has taken a while to get back to you. The screen shots were a big help in finding out what is wrong.
My main problem now is that your screen shot of Format Control is not the same as mine.
You have 5 selections
Mine only has the first 4 tabs, the Control tab is missing
Is there anyway to add that tab?
It has taken a bunch of time to grasp the concepts, but it finally looks like I have gotten it to work
Two more question regarding the combo box
1) Is it possible to have the dropdown arrow hidden until you click on the cell?
The issue here is that changing column widths is problematic due to the fact that the column names for a single column change back and forth between 4 different column names with the maximum cell entry width being different under each column name. So to try to keep the spreadsheet from getting to wide, I have to juggle where the various entries are placed.
2) Is it possible to make the combo box with a height smaller than .22?
I am able to make it bigger, but if I try to make it smaller it simply reverts back to .22. If not, then I would have to increase the row height to match the combo box height.
Thanks for all the help you have been giving me, It is very much appreciated and you will be getting an excellent rating
Thank you very much
I was a great help, it took a while to get there and I learn a lot on the way.
Thanks for you for your patience with me.