I am facing some ridiculous deadlines on a few major projects and really need some help here. I am using a lot of linked reports that have to be rewritten each month. For example smaller formulas look like this:
=('S:\PUBLIC\Production\Job Cards\MOLDING\2013\11 November\[440A SIDE SPOILER JOB CARD.xls]Production Parts'!B$228*2)+'S:\PUBLIC\Production\Job Cards\MOLDING\2013\11 November\[440A SIDE SPOILER JOB CARD.xls]Production Parts'!B$262+'S:\PUBLIC\Production\Job Cards\MOLDING\2013\11 November\[440A SIDE SPOILER JOB CARD.xls]Production Parts'!B$292
What I want to do is extract the file path from the above formula and make it a composite of several cell references.
So what I need is to have a cell where they can change the month and another where we can change the year. So I set up several named cells that look like this:
_MONTH =11 November
_YEAR =2013
_JOBCARD ='S:\PUBLIC\Production\Job Cards\MOLDING\
_PATH =_JOBCARD & _YEAR &"\" &_MONTH
I tried several versions, I am hoping for something like this:
=('_PATH &"\[440A SIDE SPOILER JOB CARD.xls]"Production Parts'!B$228*2)+'_PATH &"\[440A SIDE SPOILER JOB CARD.xls]"Production Parts'!B$262+'_PATH &"\[440A SIDE SPOILER JOB CARD.xls]"Production Parts'!B$292
Thanks ahead of time for any help.
Bookmarks