Hi Guys,
So I a simple indirect function that looks into another file (the name
of which is in my sheet in cell I1) and find the value in cell A3 of
the sheet in that file called Output. This is that function:
=INDIRECT("["&$I$1&".xls]Output!A3")
However, when i drag this formula down the reference A3 remains the
same instead of become A4, A5 etc etc, as the formula is dragged down.
How can i modify my formula so when i drag it across and down the A3
reference section changes accordingly?
Any help is gratefully appreciated
David
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
