I have a data base with prospective projects worldwide. I use a workbook with
worksheet for every country within my markets. The worksheets all have the
same headers, date entry, type, contact, value, etc. Each worksheet has the
same column and row size. At the end of each row there is a column with the
header HOT LIST. I would like to be able to place a "X" in that last cell if
the project becomes hot, and when I do this, the data in this row is copied
to a HOT LIST worksheet within my Prospect List workbook database.

I hope someone out there can help, thanks in advance
--
Bill Bula
Sales Manager
Westad Industries