I have a formula that will only autofill one part.
The formula is
=INDIRECT("'"&C1&"'!A3")
Excel will change the C1 to C2 and C3 and so on...
The only part I need filled is the A3 (A3, A4, A5 and so on), but I cant get the A3 to change at all.
Do I have an error in my formula that is causing this not to autofill?
hi and welcome to the forum
try this...
=INDIRECT("'"&C1&"'!"&A3)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks