Naming a range based on uniqueness of another column
The attached sheet has a key in column A, it defines how many are in a range. Using ActiveCell. (assuming the active cell is the first record in a bunch, and I click on it.) So I would like to define a range in column B and column C. So if I place my cursor in A2, it would identify B2 thru B7 and name it "Qtys" and C2 thru C7 as "CatCode"
I would then like to goto sheet2 and be able it paste in Qtys and Catcode.
Is there a way to just grab one row, 4 rows or 6 rows as ranges to use when pasting it into another sheet? GroupingBasedOnAnotherCol.xlsx