INDIRET fill
 

Hello,

I would like to use the Indirect function to get data from a file (called 'accent'). I am able to do that, and my first row is ready to go. Now I'd like to have the fill proceed as follows: to add 25 (i.e., down 25 rows) from the cell directly above it. The columns often vary (i.e., I have 5 columns per row from the source file that are being pulled).

Thanks!

INDIRET fill
 

hi,

please show us the formula you use and works well for the first row

--
isabelle



Le 2012-04-13 14:18, marygo a écrit :
Hello,

I would like to use the Indirect function to get data from a file
(called 'accent'). I am able to do that, and my first row is ready to
go. Now I'd like to have the fill proceed as follows: to add 25 (i.e.,
down 25 rows) from the cell directly above it. The columns often vary
(i.e., I have 5 columns per row from the source file that are being
pulled).

Thanks!

INDIRET fill
 

On Friday, April 13, 2012 1:18:57 PM UTC-5, marygo wrote:
Hello,

I would like to use the Indirect function to get data from a file
(called 'accent'). I am able to do that, and my first row is ready to
go. Now I'd like to have the fill proceed as follows: to add 25 (i.e.,
down 25 rows) from the cell directly above it. The columns often vary
(i.e., I have 5 columns per row from the source file that are being
pulled).

Thanks!




--
marygo

If desired send your file to dguillett1 @gmail.com