Thread: [Solved] Does Excel have a way of using variables to easily update reference formulas?
View Single Post
 
Old 10-19-2016, 07:59 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
You can replace the reference with
INDIRECT("'G:\Accounting\_Acct\Facility\Allocation s\"&year(A1)&" Allocations\" &text(a1,"m-yyy")&"\["&text(a1,"m-yyy")& "Monthly Allocation & Fee Calculation.xlsx]Fee Summary'!$A$70:$H$78"

where A1 contains the date

( I hope I got that one right, but you've got the idea)
PS disregard the space in the first occurrence of " allocations", it's a forum bug
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote