将一张信息传送给另一张 [英] Transferring one sheet information to another

问题描述

我有一个下拉列表，其名称不同。我想使它在表单中选择适当的名称时，其他工作表的内容显示在sheet1上。有人熟悉这样的代码，还是可以的？实际上是许多隐藏的食谱，用户可以在一张纸上查看不同的食谱，无论用户选择哪一种。食谱的格式可以被认为是一样的。

非常感谢任何帮助。

感谢您。

解决方案

要使其正常工作，您需要使用 INDIRECT 和 ADDRESS 函数。

如果我们将Sheet name存储在Sheet1.A2单元格中，那么代码将像这样对于单元格B2：

  = INDIRECT（$ A $ 2&！& ADDRESS（ROW（B2）; COLUMN（B2）））
  

这可能会被复制到您想从其他工作表获取的范围内。

Rgds

I have an dropped down list with the names of different sheets. I would like to make it such that when I select the appropriate name in sheet, the contents of another sheet is shown on sheet1. Is anyone familiar with such a code or if it is possible? It is actually many hidden sheets of recipes where the user can view the different recipes all in one sheet whichever the user selects. The format of the recipes can be assumed to be the same.

Any help is much appreciated.

Thank you.

解决方案

To make it work, you'll need to use INDIRECT and ADDRESS functions.

If we have the sheet name stored in Sheet1.A2 cell, then the code would be like this for the cell B2:

=INDIRECT($A$2&"!"&ADDRESS(ROW(B2);COLUMN(B2)))

This could should be copied across the range you want to take from other sheets.

Rgds

这篇关于将一张信息传送给另一张的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！