Excel，尝试使用Row（）引用单元格以从其他选项卡中间接（）拉取数据

Target Tab Name     Data (date)     Formula used to grab it

1   RTP SVC MCU         01/31/15        ='RTP SVC MCU'!G1
2   RTP SVC MCU         01/31/15        =INDIRECT("'" & B2 & "'!G1")
3   RTP SVC MCU         #REF!           =INDIRECT("'" & ("B" & ROW()) & "'!G1")

Row test        B5  ="B" & ROW()
Target Tab Name     Data (date)     Formula use