Forum Discussion
Help with Excel
I would like to know if anyone has done this in excel or if someone can help me with it. I would like to pick up data from two cells in sheet1 after I enter a particular no for e.g. from 1-20 in the...
If I understand what you want, it would be like in cell a1 on sheet1 and cell a2 on sheet 1 to be referenced on sheet2 in any given cell you could use =Sheet1!$a$1 to refer to the a1 cell on sheet 1 and you could use =Sheet1!$a$2 to refer to the a2 cell on sheet 1.