I have the companies in column "A" and run macro to insert row when the company name changes.
Now I would like to name their range of data using their company name in column "A" . Column "C" will always be the right hand side of the range. The number of rows could be as high as 100.
Would like range to be called "ALPHA" and be for range B2:C2
APLPHA A123 20
Next Company Baker, Range B4:C6
BAKER B234 10
Next Company Charlie, Range B8:C9
CHARLIE C567 25