how I can add next column.

[kumawat_s]

i have linked A1 column of new file from B5 column of sheet1 of Payment.xls like as under

=[payment.xls]Sheet1!$B$5

now i want that in B1 coloum of new file the data should be of next 4 column of B5 i.e. B9. what function should I apply


=a1+????????? (for next 4 column of B5 of payment.xls)

thanks in advance.

s karan

[mangesh_yadav]

First select cells A1 to E1. Then enter the following formula in the first cell (note that the selection is still on)
=TRANSPOSE('[payment.xls]Sheet1!$B$5:$B$9)

and since this is an array formula press: control + shift + enter


- Mangesh