i am newbie to excel and i need some help in this issue
i have copied A1 cell from sheet 1 into A1 cell from sheet 2
what i need to do is to drag A1 of sheet 2 horizontally (B1, C1, D1) and get the vertical values (rows) of sheet 1: A2, A3, A4, etc...
Is it possible
because i would to deal with sheet 1 only and get the results on sheet 2 automatically
Thank you in advance