数据验证与选拔 [英] Data validation & selection
问题描述
亲爱的所有人,
我有一个下拉列表中的数据.
当我从下拉列表中选择一个选项时,与该特定选项相关的条目应显示在另一列中.
当我更改一个选项时,条目应出现在与下一个选项相关的其他列中.
我该怎么办?
我可以通过查找对单个条目执行此操作,但是对于多个条目可以执行此操作.
实际上,我有一个工作簿,其中有很多工作表,就像:
在Sheet2中,我有项目详细信息,在Sheet1中,我有项目名称的下拉列表,
我要
当我在Sheet1的下拉列表"Project1"中选择时,应显示Project列中的所有详细信息,当我选择另一个项目时,则应显示该项目的详细信息.
我认为我已经出于上述目的编写了vba脚本,但是请告诉我.
Dear All,
I have data in a drop-down list.
When I select an option from the drop-down list entries related to the particular option should be displayed in another column.
When I change an option, entries should be come in other columns related to the next option.
How can I do this?
I can do it for single entry with lookup but what for multiple entries.
Actually, I''ve workbook, in which I''ve many sheets, Just Like:
In Sheet2, I''ve Project Details, and in Sheet1 I''ve drop down list of Project Names,
I want,
When I select in Sheet1''s drop-down list "Project1", all details in the columns of Project should be appear, when I make select another project then details of that project should be appear.
I think I''ve to write vba script for the above purpose but How can I do this, please tell me.
推荐答案
您在哪里保存数据? br/> 如果您有一个包含数据的工作表,则可以应用与列号有关的简单复制和粘贴功能.
然后它将偏移1列,或者,如果完成,则清除并重置.
显示您所拥有的,我们将能够更好地为您提供帮助.
ps对于从工作表中提取数据并根据用户输入将其显示在单独的工作表中,我做了类似的操作,因此假设我的理解是正确的,我可能会得到一个很好的答案.
我可以通过电子邮件将您使用的工作表发送给您.
Where are you holding the data?
If you have a worksheet with data then you could apply a simple copy and paste function relating to the column number.
It would then offset by 1 column, or, if you have finished, clear and reset.
Show what you have and we will be better able to help you.
ps I do something similar for pulling data from a worksheet and showing it in a separate sheet according to a user input, so I may have an ready answer, assuming my understanding is correct.
I could email you the worksheet I use.
这篇关于数据验证与选拔的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!