One more point.

Column D contains "time last changed" so's you can keep track of intervals.


Gord

On Mon, 04 Dec 2006 17:36:26 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

First................grab a clipboard, paper and pencil.

Second..............wander around warehouse and make a list of all lights by
location.

Number these 1 through whatever.

Start Excel and open a new workbook.

Transfer the data to the worksheet..........numbers in Column A, location in
Column B.

In column C, which is titled "Date Changed" enter the date when you change any
of the lights.

To enter the current date in a cell, hit CTRL + ;(semi-colon)


Gord Dibben MS Excel MVP


On Mon, 4 Dec 2006 17:06:00 -0800, David J <David
wrote:

I need to create a layout of the lights in a warehouse, the lights are being
replaced and I need to be able to track the lights as they are changed. Any
suggestions, ideas or help would be appreciated