I am having a similar issue identified in this thread. http://www.excelforum.com/excel-form...a-pattern.html
I am having a similar difficulty, but I don't fully understand the formula used to remedy this problem. I would like to enter data on Page1 and pull from certain cells.
On Page2 B4:
I summing data from Page1 from B6:Y6
and in B5:
I am summing data from Page1 from B9:Y9
The INDEX:INDEX solution (identified in the posted thread) should work in my case, but I cannot figure out what the arguments truly mean to the formula so I can apply it elsewhere.
Help is appreciated.
Bookmarks