software

DATA:

A1 A2 (these three colums combined in one column)
765100SWISS MISS CIDER MIXCS$28.50
765100SWISS MISS CIDER MIXCS$30.00
054020SYRUP CUPS MAPLE 100-1 OZ.CS$13.30

Both A1 and A2 are pull-down menus.
If user pulls down menu and selects A1, then A2 is returned to the right of
it.
If user pulls down menu and selects A2, then A1 is returned to the left of it.

Any ideas?--
Jason Kaloyanides
Tech. Support Coord.
New England Coffee
Sales DepartmentYou can do this with programming. There's an example he

www.contextures.com/excelfiles.html

Under Data Validation, look for Dependent Cell Examples

JK (New England Coffee) wrote:
gt; DATA:
gt;
gt; A1 A2 (these three colums combined in one column)
gt; 765100SWISS MISS CIDER MIXCS$28.50
gt; 765100SWISS MISS CIDER MIXCS$30.00
gt; 054020SYRUP CUPS MAPLE 100-1 OZ.CS$13.30
gt;
gt; Both A1 and A2 are pull-down menus.
gt; If user pulls down menu and selects A1, then A2 is returned to the right of
gt; it.
gt; If user pulls down menu and selects A2, then A1 is returned to the left of it.
gt;
gt; Any ideas?
gt;
gt;