Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the alternative for PlotArea.Fill. Fill property is hidden | New Users to Excel | |||
Fill handle fill down alternative methods question | Excel Discussion (Misc queries) | |||
Some formulas don't track copies, pastes, fill right, fill down | Excel Discussion (Misc queries) | |||
Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) |