What type of data is contained in the X-coord and Y-coord values and how are
these values mapped to cells or locations on the second sheet? How is the
Item value related to a color that is to be used on the second sheet?


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"Mr B" wrote in message
...
Howdy,

I have programmed in Excel in a long time and am not sure where to
begin...

I have some data in 5 column such as:
Name, City, X-coord, Y-coord, Item

I want to run through this data and create a map in the second sheet where
at the given X, Y coordinates for each person, it colors that cell a
certain
color based on the "Item" and then creates a Comment for the cell
containing
the Name and City.

I know this should be pretty darn easy but I'm rusty and need some
guidance.
Some things I know I need a

How to set the fill color via a command.
How to insert a comment via a command.
Basically everything to get me started.

Thanks for any and allhelp.