Please Help Fill Down problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stephen - 08 Feb 2007 20:11 GMT

Sorry about the cross post but I'm getting desperate...

row 1 contains headers. col A and C contain values. I need to populate Col B
with values like the following

B2 needs to read R2C3
B3 needs to read R2C4
B4 needs to read R2C5
B5 needs to read R3C3
B6 needs to read R3C4
B7 needs to read R3C5
B8 needs to read R4C3
B9 needs to read R4C4
B10 needs to read R4C5

etc...

I was given...
=OFFSET($C$4,INT((ROW(A1)-1)/3),MOD(ROW(A1)-1,3))

But it's not working because of the values that I have in columns A and C.

Any and all help is greatly appreciated.

Reply to this Message

JMB - 09 Feb 2007 01:15 GMT

check your other post for another suggestion.

> Sorry about the cross post but I'm getting desperate...
>
[quoted text clipped - 19 lines]
>
> Any and all help is greatly appreciated.

Reply to this Message

Stephen - 09 Feb 2007 12:16 GMT

got it! Thank you. I'm cross posting the solutions that worked for me in
hope that others can benifit too. It amounts to either using a marco

Sub test()
Row = 2
a = 2
Do
For i = 3 To 5
Cells(Row, 2).Value = "R" & a & "C" & i
Row = Row + 1
Next i
a = a + 1
Loop Until Row > 735
End Sub

or one of two formulas...

="R"&INT(ROW(A3)/3)+1&"C"&MOD(ROW(A2)+1,3)+3

or without the cell references...

="R"&INT((ROW()+4)/3)&"C"&MOD(ROW()+1,3)+3

I ended up using the macro so I did not have to convert the formulas into
their values.

Thank you to everyone for their input.

> check your other post for another suggestion.
>
[quoted text clipped - 21 lines]
> >
> > Any and all help is greatly appreciated.

Reply to this Message