View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pablo pablo is offline
external usenet poster
 
Posts: 76
Default Copy records that are 4 rows apart

Dear reader,

I have a bit of a problem copying from one worksheet to another. I need to
copy some dates from worksheet B to worksheet A. Currently these worksheets
are set up this way
WORKSHEET A -
A B
1 Part Date
2 xy 3/24/08 Formula used: =(worksheetb!B5)
3 yz (I would like a formula that will skip four rows and copy cell
B9

WORKSHEET B (contains the data I need to copy)
A B
1 Part Date
2
3 (Cells A2:A5 are merged)
4
5 xy 3/24/08
6
7 (Cells A6:A9 are merged)
8
9 yz 3/25/09

Please help!