如何在Excel 2003中的下拉列表中将数据从一个Excel工作表文件显示到另一个Excel工作表 [英] How to show data from one excel sheet file to another excel sheet in dropdown in Excel 2003

问题描述

你好朋友，

我有两个Excel工作表文件，一个是学校代码School.xls，另一个是学生详细信息StudentDetails.xls.在School.xls中，我放置了所有学校代码，并且希望将这些学校代码放在下拉列表的StudentDetails.xls中，以便我可以选择特定的学校代码并输入数据.我无法在StudentDetails.xls中获得这些学校代码.谁可以帮我这个事.我正在使用MS Excel2003.

在此先感谢

问候，
Yogesh

Hello Friends,

I have two excel sheet files one is School code School.xls and other is Student Details StudentDetails.xls. In School.xls I put all the school codes and I want these school code in StudentDetails.xls in dropdown list so that I can select particular school code and enter the data. I am not able to get these school codes in StudentDetails.xls. Can anyone help me on this. I am using MS Excel 2003.

Thanks in advance

Regards,
Yogesh

推荐答案

我认为您会在此链接中找到您的信息:
http://office.microsoft. com/en-us/excel-help/insert-or-delete-a-drop-down-list-HP005202215.aspx [

I think you will find your info in this link :
http://office.microsoft.com/en-us/excel-help/insert-or-delete-a-drop-down-list-HP005202215.aspx[^]

I has detailed instructions how to create such a list.

Cheers

感谢Estys，

此信息很有帮助.我尝试了本文在不同的工作簿中使用不同的工作表"，第3点.但是在我关闭School.xls并尝试访问StudentDetails.xls学校代码下拉列表之后，它没有显示.按照这种方法，我必须打开School.xls才能看到已填充的下拉列表.

你能告诉我这个吗.如何在不每次打开School.xls的情况下显示列表中的数据?

谢谢，
yogesh

Thanks Estys,

This information is helpful. I tried this "Use a different worksheet in a different workbook", point 3 in this article. But after I closed School.xls and try to access StudentDetails.xls school code dropdown list then it is not showing. As per this method I have to open School.xls to see the filled dropdown list.

Can you please tell me this. How can I show data in list without opening School.xls each time?

thanks,
yogesh

这篇关于如何在Excel 2003中的下拉列表中将数据从一个Excel工作表文件显示到另一个Excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！