heroofgoodwi
12-18-2017, 03:34 AM
Hey all,
I have been looking for a method to utilise VBA to allow a user to select a new title from a list of sheets from a drop down box and then click a button which would run a piece of VBA which would change a series of Match Index cells to represent the new selection.
Currently the cells contain something like this.
=IFERROR(INDEX('Full £ Template 10_2017'!E6:BA6,MATCH(Report!$C$4,'Full £ Template 10_2017'!$E$3:$BA$3,0)),0)
What I would like the end result to be is for the user to be able to change the date in the formula to match the one on the new template. For example moving from:
'Full £ Template 10_2017'
to
'Full £ Template 11_2017'
If anyone has any suggestions it would be greatly appreciated.
I have been looking for a method to utilise VBA to allow a user to select a new title from a list of sheets from a drop down box and then click a button which would run a piece of VBA which would change a series of Match Index cells to represent the new selection.
Currently the cells contain something like this.
=IFERROR(INDEX('Full £ Template 10_2017'!E6:BA6,MATCH(Report!$C$4,'Full £ Template 10_2017'!$E$3:$BA$3,0)),0)
What I would like the end result to be is for the user to be able to change the date in the formula to match the one on the new template. For example moving from:
'Full £ Template 10_2017'
to
'Full £ Template 11_2017'
If anyone has any suggestions it would be greatly appreciated.