excel 引用其他工作簿
To make it easier for people to enter data, you can create drop down lists on an Excel worksheet.
为了使人们更容易输入数据,您可以在Excel工作表上创建下拉列表 。
Usually the source lists are stored in the same workbook as the drop downs. However, with named ranges, it is possible to use a list in a different workbook.
通常,源列表与下拉列表存储在同一工作簿中。 但是,使用命名范围 ,可以在其他工作簿中使用列表 。
In the screen shot shown below, the original list is in the workbook at the left. The drop downs are in a different workbook, on the right.
在下面显示的屏幕快照中,原始列表在左侧的工作簿中。 下拉列表位于右侧的其他工作簿中。
有一个赶上 (There Is a Catch)
My preference would be to keep the lists and drop downs in the same workbook, but if you need to have them in separate files, this technique will allow you to do that.
我的偏好是将列表和下拉列表保留在同一工作簿中,但是如果您需要将它们放在单独的文件中,则可以使用此技术进行操作。
There's one catch though, when using this data validation technique. The source workbook, which contains the original list, must also be open, when you are using the drop down lists.
使用这种数据验证技术时,有一个问题。 使用下拉列表时,包含原始列表的源工作簿也必须处于打开状态。
So, it's not a perfect solution, but it's fairly easy to implement, as long as you remember to open the other workbook too.
因此,这不是一个完美的解决方案,但是只要您也记得打开其他工作簿,它就很容易实现。
Excel 2010说明 (Excel 2010 Instructions)
I've just uploaded a video with instructions for this technique in Excel 2010, so you can see the steps for creating the named ranges and data validation drop down lists.
我刚刚在Excel 2010中上传了包含有关此技术说明的视频,因此您可以看到创建命名范围和数据验证下拉列表的步骤。
The written instructions for Excel 2007 and Excel 2010 are in this blog post: Data Validation List From Different Workbook
Excel 2007和Excel 2010的书面说明在此博客文章中: 来自不同工作簿的数据验证列表
翻译自: https://contexturesblog.com/archives/2012/01/05/excel-drop-down-from-list-in-different-workbook/
excel 引用其他工作簿