Oct 10 2018 08:40 PM
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
Oct 10 2018 09:18 PM
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.