D
Dean Hewer
Greetings,
I have an Excel file in which we have mapped out 27 categories of a
retailers store layout.
There are 133 stores (sheets) of these layouts.
The layout represents a section of the shelves in the store. Each section
has certain categories merchandised on it. There could be up to 40 of these
sections.
Currently, the mapping only shows the numerical representation of the
specific category.
That is, Category 1=Fluid Milk
I would like to have these layouts colour keyed by category for a better
visual representation.
I have inserted a sheet at the beginning that has the following (Columns A -
C respectively)
Colour Key - Category Number - Category Description.
Is there anyone who could create a macro that would take the Colour key,
Category # and Category Description and replace the numerical value in the
layout sheets?
If anyone could be of assistance, I would be greatly appreciated. I have a
small test file that has the just the colour map sheet and one stores
layout.
In advance, thanks!!!
_____________________________
Dean Hewer
I have an Excel file in which we have mapped out 27 categories of a
retailers store layout.
There are 133 stores (sheets) of these layouts.
The layout represents a section of the shelves in the store. Each section
has certain categories merchandised on it. There could be up to 40 of these
sections.
Currently, the mapping only shows the numerical representation of the
specific category.
That is, Category 1=Fluid Milk
I would like to have these layouts colour keyed by category for a better
visual representation.
I have inserted a sheet at the beginning that has the following (Columns A -
C respectively)
Colour Key - Category Number - Category Description.
Is there anyone who could create a macro that would take the Colour key,
Category # and Category Description and replace the numerical value in the
layout sheets?
If anyone could be of assistance, I would be greatly appreciated. I have a
small test file that has the just the colour map sheet and one stores
layout.
In advance, thanks!!!
_____________________________
Dean Hewer