Help with Excel

[marion D]

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 cell beside those two data cells and to fill the data from those two cells in sheet 2 where that particular number you have written like say 1 and fills those cells with the data from the sheet 1 cells. See the sample excel sheet attached.

Thanks for taking the time to read and help me with this doubt.

Regards,

Mario

[#2]

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.