Copying cells from one sheet to another
In Sheet2!A1 use the formula
=IF(ROW()=1,Sheet1!A1,IF(MOD(ROW(),10)=0,INDIRECT( "Sheet1!A"&(ROW()/10)+1),""))or=IF(ROW()=1,Sheet1!A1,IF(MOD(ROW(),10 )=0,OFFSET(Sheet1!A$1,ROW()/10,0),"")) and copy downIt's interesting that you have 9 rows difference between the first twodestinations, but 10 rows difference between subsequent pairs.--David Biddulph"Andrew" wrote in ...I have data in sheet one, A1 thru A50, and in another sheet these cells are referneced. I need to copy as follows: Sheet 1 A1 to Sheet 2 A1 Sheet 1 A2 to Sheet 2 A10 Sheet 1 A3 to Sheet 2 A20 Sheet 1 A4 to Sheet 2 A30 and so on.... but everytime I try to copy Sheet 2 A10 gets the data from Sheet1 A10 and not A2. How do I get around this? Thanks. P.S. I am in office 2000 and 2003.
|