Thread: fill cells with even increment rows from a different worksheet
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default fill cells with even increment rows from a different worksheet
=OFFSET('Sheet2'!$A$1,12*ROW()-12,0)

Entered in Sheet1 B1 and dragged down.


Gord Dibben Excel MVP


On Wed, 7 Dec 2005 10:11:02 -0800, "FormulaChallenged"
wrote:

Hi,

Could anyone give me a formula to import data from A1, A13, A25 etc at 12
row increment in sheet 2 to B1, B2, B3 etc in sheet 1?

Thanks
FormulaChallenged
Reply With QuoteReply With Quote