How to use cell reference?
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.
|