Posted to microsoft.public.excel.misc

Eden397

external usenet poster

Posts: 40

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
INDIRECT function	Tanya	Excel Worksheet Functions	2	May 17th 07 09:06 AM
How to use indirect function?	Eric	Excel Discussion (Misc queries)	2	January 30th 07 03:57 PM
using the INDIRECT function	hot dogs	Excel Discussion (Misc queries)	1	November 1st 06 12:01 PM
Need help on Indirect function	Naveen	Excel Discussion (Misc queries)	3	August 11th 06 06:45 PM
Indirect Function and Sum	gr	Excel Worksheet Functions	2	February 2nd 05 04:16 PM

All times are GMT +1. The time now is 04:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us