Any help would be much appreciated! I need to insert a cell reference into a link.
Specifically I want to replace the ZIP code from the link below with a ZIP in a specific cell. I'd like to be able to replace 44839 with whatever ZIP is in A3, A4, etc. Each ZIP will be in a different row and I'll ultimately be pulling data from over 70 different spreadsheets. Any assistance would be a huge help!
=+'[Claritas - Senior Life 2013 - 44839.xls]Sheet2'!D3
Hi and welcome to the forum
You can use INDIRECT() to pull text in to become part of a formula reference. However, INDIRECT() only works on open workbooks, unless you install the Morefunc add-in
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