Excel: Sounds Good (Page 1) 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

Formulas ->Name Manager ->Edit Modify a Range Look carefully at the Reference. You can use the red, white and blue Lookup button to edit the Range.   Try This: Modify a Range Click on the Lookup button.   Go to the Conditional Formula Worksheet  and select cells A1 through E58. This process added another column to the SalesData Range.   Click on the red, white and blue button to return to the Name Manager.