Pls disregard, this won't work, sorry
--
Cheers,
RyanR

--- pls click yes if I''ve helped you ---


"RyanR" wrote:

My approach would be as follows....

Assumption, the result table will 4 columns, no more, no less....

In B1 type "=A1", in B2 type "=A5" without the quote marks.
Select B1:B2, and drag across to column E (to copy the formula)
Then select rows 1:2, and drag down as far as you need to fill the rows.

--- pls click yes if I''ve helped you ---
--
Cheers,
RyanR




"Brinto Roy" wrote:

Hi,

I need to fill a table using cell reference as below,by drag n fill
method:

Source Required Table
A B C D E
A1 A1 A2 A3 A4
A2 A5 A6 A7 A8
A3 A9 A10 A11 A12
A4 €¦ €¦ €¦ ..
A5
€¦.
€¦
Any clue how to go for it?

Thanks,
Roy.