View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
pcor pcor is offline
external usenet poster
 
Posts: 148
Default Copy lines from sheet 2 to sheet 6

I have some data in sheet 2 in col I.
the data I want to capture is spaced by 7 spaces all the ay down:
EX:
I have data in sheet 2 col I row 1 ,7,14,21 etc

I would like to show the data in Sheet 2 to Sheet 6 col B row 1,2,3,4, etc
thanks