This was asked long ago, but I think there's a better approach than the one already suggested, so here it is.

I would advice to have the master file as you suggest, facility-independent (with no particular configuration data on it), and load the facility configuration from an xml file that will be specific to each one, and that you or the people there could manipulate/customize/modify (being xml very human-readable).

Take a look at this for ideas on how to parse the xml data.

So, for instance, you could store data to populate your variables:

<machine facility="Facility 1" name="Machine1">
    <labels>A2:A20</labels>
    <data>B2:B20</data>
</machine>

To populate it like this (after parsing it with the approaches you will find following the link):

Set Inputdata(0) = Sheet1.Ranges(machine1.labels)
Set Inputdata(1) = Sheet1.Ranges(machine1.data)
Set newChart = ChartCreator(machine1.facility, Inputdata)

This was asked long ago, but I think there's a better approach than the one already suggested, so here it is.

I would advice to have the master file as you suggest, facility-independent (with no particular configuration data on it), and load the facility configuration from an xml file that will be specific to each one, and that you or the people there could manipulate/customize/modify (being xml very human-readable).

Take a look at this for ideas on how to parse the xml data.

So, for instance, you could store data to populate your variables:

<machine facility="Facility 1" name="Machine1">
    <labels>A2:A20</labels>
    <data>B2:B20</data>
</machine>

To populate it like this (after parsing it with the approaches you will find following the link):

Set Inputdata(0) = Sheet1.Ranges(machine1.labels)
Set Inputdata(1) = Sheet1.Ranges(machine1.data)
Set newChart = ChartCreator(machine1.facility, Inputdata)

I would advice to have the master file as you suggest, facility-independent (with no particular configuration data on it), and load the facility configuration from an xml file that will be specific to each one, and that you or the people there could manipulate/customize/modify (being xml very human-readable).

Take a look at this for ideas on how to parse the xml data.

So, for instance, you could store data to populate your variables:

<machine facility="Facility 1" name="Machine1">
    <labels>A2:A20</labels>
    <data>B2:B20</data>
</machine>

To populate it like this (after parsing it with the approaches you will find following the link):

Set Inputdata(0) = Sheet1.Ranges(machine1.labels)
Set Inputdata(1) = Sheet1.Ranges(machine1.data)
Set newChart = ChartCreator(machine1.facility, Inputdata)

This was asked long ago, but I think there's a better approach than the one already suggested, so here it is.

I would advice to have the master file as you suggest, facility-independent (with no particular configuration data on it), and load the facility configuration from an xml file that will be specific to each one, and that you or the people there could manipulate/customize/modify (being xml very human-readable).

Take a look at this for ideas on how to parse the xml data.

So, for instance, you could store data to populate your variables:

<machine facility="Facility 1" name="Machine1">
    <labels>A2:A20</labels>
    <data>B2:B20</data>
</machine>

To populate it like this (after parsing it with the approaches you will find following the link):

Set Inputdata(0) = Sheet1.Ranges(machine1.labels)
Set Inputdata(1) = Sheet1.Ranges(machine1.data)
Set newChart = ChartCreator(machine1.facility, Inputdata)