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.

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.

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.

Hi Ryan,

Thanks for the prompy reply.
But the solution that you provided does not seem to solve the problem :
(
After I select B1:B2,and drag across to column E..the column name even
changes,i.e A1 changes to B1,C1...which i dont want.
even tried with "=$A1" to keep the column name constant..But even
thats not helping!

Thanks,
Roy

Yeah..it doesnot!

--- Roy

This seems ok ..
In B1: =OFFSET($A$1,ROWS($1:1)*4+COLUMNS($A:A)-5,)
Copy B1 across to E1, fill down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

Wow!
Worked like a charm! :)
Great help.thanks!

Thanks,
Roy