Excel Sheets

[prasadsg2005]

Hello all,

I have 2 different tabs in a Workbook.
In sheet1 I have all the dates starting from A1 and so on.
Now in Sheet2 in B2 i need the 1st cell say Sheet1 A1 but the next value from Sheet1 A2 i need to be entered in Sheet2 but in B12. The next will be Sheet 1 A3 to be entered in sheet2 B22 and so on.

I have almost 180 Entries and doing it manual taking lot of time and same is error bound as well.

Thanks,
Prasaad Gaikwad

 

[steve the fish]

This should work copied down:

=IF(MOD(ROW()-2,10)=0,INDEX(Sheet1!A:A,ROUNDUP(ROW()/10,0)),"")