I have 2 worksheets ( 'Sheet1' takes the data from 'sheet2' )
In sheet1 the data is in cells:-
A1,B1,C1,.....
A5,B5,C5,.....
A10,B10,C10,.....
.
.
.
and so on...
It is required that these cells takes the values from sheet2 in the form of a table. i.e.
'Sheet1' A1 = 'Steet2' A1
'Sheet1' B1 = 'Steet2' B1
'Sheet1' C1 = 'Steet2' C1
'Sheet1' A5 = 'Steet2' A2
'Sheet1' B5 = 'Steet2' B2
'Sheet1' C5 = 'Steet2' C2
'Sheet1' A10 = 'Steet2' A3
'Sheet1' B10 = 'Steet2' B3
'Sheet1' C10 = 'Steet2' C3
.
.
and so on.....
please help how this can be achieved.
i tried using Offset command ,but was not successful
Bookmarks