close

I am building a workbook that has a summary sheet and several worksheets. Is
there a way to drag and autofill so that the fomula will change the sheet
number?
Example: Sheet1, Cell A1 is equal to Sheet2, Cell D1. I would like to drag
this formula down so it it will auto fill Sheet1, cell A2 as being equal to
Sheet3, cell D1 and then Sheet 1, cell A3 equal to Sheet4, cell D1 and so on.
Is this possible?

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()