View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_16_] Steve[_16_] is offline
external usenet poster
 
Posts: 28
Default Return the values in another sheet

I have 2 sheets in a workbook. I am trying to code a procedure which
will cause the value of Sheet 2 to return the value contained is Sheet
1. Each row increments by 4 (ie - B4, B8, B12, B16...) and starts at
row 4, except for B5.

Sheet 2 A1 = value in sheet1 B4
Sheet 2 B1 = value in sheet1 C4
Sheet 2 C1 = value in sheet1 B5

Sheet 2 A2 = value in sheet1 B8
Sheet 2 B2 = value in sheet1 C8
Sheet 2 C2 = value in sheet1 B9

Sheet 2 A3 = value in sheet1 B12
Sheet 2 B3 = value in sheet1 C12
Sheet 2 C3 = value in sheet1 B13

And so on, until Sheet 1 ends, around row 2,500.

Thanks in advance for any assistance...