I have three sheets "Budget", "Cklog" and "Disbursements".

Budget contains several line items annualized in one column and /26 (pay
periods) in another.
________B________________C_______________D________ _____
18.| CATEGORY ANNUALIZED PER PAY PERIOD
19.| Food $4500.00 $173.07


"Cklog" has a column (G8) labled "Net Income". Net is calculated for each
pay check

_____E________________F_______________G___________ __
DATE GROSS NET

8.| 17FEB06 $191.05 $167.52
9.| 03MAR06


"Disbursements" has a column "J" labeled FOOD which contains =BUDGET!$D$19
copied to all cells (26) in column "J". This causes $173.07 to appear in all
cells in column "J". Column "J" is totaled at the bottom causing a
annualized total instead of an accumulated to total.

How do i keep $173.07 form appearing in "J" until a new entry appears in
Cklog[s NET Column