Suppose you are adding inventory details for all your stores. You can use data validation to keep your region entries astute.

If window to create ADI template appears, click cancel and return back to navigation window. Using the open Excel ADI inventory worksheet, select ‘Add-Ins’ on tool bar, ‘Oracle’ drop down menu.

Wheelwright, Steven C., and William Schmidt. "Scientific Glass Incorporated: Inventory Management, Spreadsheet Supplement (Brief Case)." Harvard Business School Spreadsheet Supplement 104-210, June ...