| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect function
=INDIRECT($A$3&"!B53")
I want to autofill down my column but have the B53 change to B54, B55, etc. How do I set that up. I think it has something to do with "rows"? Thanks, Eden 397 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect function
Hi,
Possibly =INDIRECT("A3")&B54 Mike "Eden397" wrote: =INDIRECT($A$3&"!B53") I want to autofill down my column but have the B53 change to B54, B55, etc. How do I set that up. I think it has something to do with "rows"? Thanks, Eden 397 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect function
$A$3 is the cell containing the tab name that I want to pull B54 from so I
need it to stay as is but was wondering if I could use the "row" function to autofill my B54 with the next cell down. "Mike H" wrote: Hi, Possibly =INDIRECT("A3")&B54 Mike "Eden397" wrote: =INDIRECT($A$3&"!B53") I want to autofill down my column but have the B53 change to B54, B55, etc. How do I set that up. I think it has something to do with "rows"? Thanks, Eden 397 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect function
=INDIRECT($A$3&"!B"&ROW(B53))
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Eden397" wrote in message ... =INDIRECT($A$3&"!B53") I want to autofill down my column but have the B53 change to B54, B55, etc. How do I set that up. I think it has something to do with "rows"? Thanks, Eden 397 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect function
"Bernard Liengme" wrote: =INDIRECT($A$3&"!B"&ROW(B53)) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Eden397" wrote in message ... =INDIRECT($A$3&"!B53") I want to autofill down my column but have the B53 change to B54, B55, etc. How do I set that up. I think it has something to do with "rows"? Thanks, Eden 397 LIFE SAVER!! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect function
Perhaps =INDIRECT($A$3&"!B"&ROW(B53))
Tyro "Eden397" wrote in message ... =INDIRECT($A$3&"!B53") I want to autofill down my column but have the B53 change to B54, B55, etc. How do I set that up. I think it has something to do with "rows"? Thanks, Eden 397 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect function
=INDIRECT($A$3&"!B" & ROW(53:53))
Gord Dibben MS Excel MVP On Thu, 21 Feb 2008 12:07:01 -0800, Eden397 wrote: $A$3 is the cell containing the tab name that I want to pull B54 from so I need it to stay as is but was wondering if I could use the "row" function to autofill my B54 with the next cell down. "Mike H" wrote: Hi, Possibly =INDIRECT("A3")&B54 Mike "Eden397" wrote: =INDIRECT($A$3&"!B53") I want to autofill down my column but have the B53 change to B54, B55, etc. How do I set that up. I think it has something to do with "rows"? Thanks, Eden 397 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDIRECT function | Excel Worksheet Functions | |||
| How to use indirect function? | Excel Discussion (Misc queries) | |||
| using the INDIRECT function | Excel Discussion (Misc queries) | |||
| Need help on Indirect function | Excel Discussion (Misc queries) | |||
| Indirect Function and Sum | Excel Worksheet Functions | |||
Linear Mode
