I am trying to automate a large task. I would like to be able to enter a
Task Number into a cell and have several things happen: I would like the
description, the unit of measurement and the unit price automatically
entered. In this same spreadsheet, I would like to be able to carryover from
the prior months worksheet the amount of money already expended to a category
and I would like it it let me know when we are getting close the the maximum
allowed (using font color change or other visual clue).

I hope that this is something that can be done since it will simplify a
large portion of work and make it so only one person has to deal with it.

Barbara

You could use functions like VLOOKUP and SUMIF. It depends on your data layout.

To color cells, use conditional formatting.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Barbara" wrote:

I am trying to automate a large task. I would like to be able to enter a
Task Number into a cell and have several things happen: I would like the
description, the unit of measurement and the unit price automatically
entered. In this same spreadsheet, I would like to be able to carryover from
the prior months worksheet the amount of money already expended to a category
and I would like it it let me know when we are getting close the the maximum
allowed (using font color change or other visual clue).

I hope that this is something that can be done since it will simplify a
large portion of work and make it so only one person has to deal with it.

Barbara