Using Name | Create is great to assign auto names to ranges of cells. But it can't be used if products (say for a different region, or quarter) are captured on the same sheet. When I use the create command on the second block of data, it informs me that range names will be replaced.
Is the a way to automatically name similar ranges eg.. Prod1, Prod2, Prod3... if the names are identical? Any suggestions before I start searching or wasting time with a macro or something!