Instead of a direct link..............

Place a conditional formula in those cells.

Something like

=MIN(J1,Sheet1!A1)

Or

=IF(Sheet1!A1100,J1,Sheet1!A1)

Schedular can enter the daily plan number in J1 to suit his needs for today.


Gord Dibben MS Excel MVP

On Wed, 23 Dec 2009 08:11:02 -0800, JK <jasonk at necoffeeco dot com wrote:

I have a workbook with a number of worksheets (2003.) The 2nd and 3rd
worksheets have cells that are linked to the 1st worksheet. This workbook
will be used to schedule production. The 1st worksheet has a list of products
that we produce.

The 1st worksheet has a column for the min # of cases we need to keep in
stock at all times and the max # of cases we must keep in stock at all times.
The 1st worksheet also contains a column where the production scheduler would
enter the actual # of cases in stock.

The 2nd worksheet in the workbook takes the actual cs in stock and compares
it to the total # of cases we should keep in stock to come up with a total #
of cases we need to make in order to keep the inventory levels within the min
& the max.

The 3rd worksheet is basically a copy of the 2nd worksheet except I want the
production scheduler to be able to modify the suggested qty's to create a
production plan for the day.

However, the 3rd worksheet will be either linked to the 1st or the 2nd
worksheet and will display the recommended qty's to make. It would be
impossible to make what is recommended becuase there simply is not enough
time in the day to do so. Therefore, the production scheduler will need to
modify the recommended qty's in order to create a plan for the day. If the
scheduler modify's any of the linked cells the links will be broken.

How would I make it so that the linked cells (recommendation) can be
modified without breaking the links?

Sorry so lengthy - appreciate your help.

Jason