Hello, First time poster so apologies if I am not explaing my issue very well.
I have a list of data that I need to display on another worksheet based on what a user selects from several drop down menus.
For example if I select a Colour, Rank, and Specialisation it displays them on another worksheet. I dont know any VBA or macros so I would prefer to stick with formulas if possible?
I've attached my spreadsheet for you to look at and I thinks its easier to understand once you look at it.
Thanks
I want to populate a ComboBox from the Control Tool Bar on Sheet 1 with Cells contained within a Range on Worksheet 2, i.e., Sheet 2 Cells A1:A3 need to show in my ComboBox on Sheet 1.
The ListFillRange from ComboBox Properties does not allow a user to point to a range of cells from another sheet. How do I insert a List Fill Range for a ComboBox when the Range is located on a separate worksheet? I have searched here, but all seem to be using code versus syntax in regard to naming the range from a separate sheet.
I can easily accomodate my desire with Data Validation. However I had a preference for the ComboBox due to the fact the Drop-Down Handle on a ComboBox shows even when the cell is not selected. Does anyone know how to format the dropdown handle when using to Data Validation to show even when the cell is not selected?
Thanks in Advance!
I want to duplicate a cell including te data validation on the template sheet.
Any ideas?
Hello all, I am trying to figure out how to get data validation to work from sheet 1 to sheet 2 without the drop down list.
I have a spread sheet that has serial numbers. Say I start with sheet 1 I make this jan. I input all my serial numbers I have used for jan. Now on sheet 2 I want to put serial numbers, but I want to make sure I do not duplicate serial numbers from sheet 1 onto sheet 2.
Is there a way to do data validation on sheet 2 to make sure I do not duplicate the serial number from sheet 1?
I have tried the drop down list and that is not what I need. I want to be able to put whatever the serial number is, but if it is duplicated I want excel to tell me that number has been used before. I am using Excel 2007.
Thanks and hope someone can answer this question.
Jerry
Hi,
Is it possible to have a dynamic data validation drop down list in Sheet1 that references a dynamic range in sheet 2?
I couldnt figure it out. I know I can have a dynamic drop down list if the data validation cell and the dynamic range are in the same sheet because Ive tried it and it works. I did this by selecting my range and making it a table. I am using excel 2007.
Thank you.
How can I use data validation allowing only entries from a range on another sheet?
When I use the validation dialogue box, it will not allow me to reference a range on another sheet.
I am wondering if anyone has figured out a trick how to get around Excel not letting a Validation List reside on a different worksheet?
Cheers,
Doug
Hi Guys,
I have a sheet named "Mileage Defaults", and in the first column I have a header (field name), "Location". I also selected the whole column including the column name and named the list "Location" as well.
On another sheet, I want to only allow locations that have been defined in that list, but I'm not sure how to reference that. I tried just typing in "Location" in the Data Validation Source, but now my dropdown only contains one item, "Location".
Any suggestions on referencing my list?
Thanks
