How to prevent copied data from appearing until triggered by anoth
 

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

How to prevent copied data from appearing until triggered by anoth
 

Try something like ...
=If(isblank(CKLOG!$G9),"",BUDGET!$D$19)
Rgds,
ScottO


"Denny Crane" <Denny wrote in
message ...
| 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
|

How to prevent copied data from appearing until triggered by a
 

Scott thanks for your imput however, BUDGET copies to the cell holding the
formula wether CKLOG is blank or not.
Of course, i only want it to copy when there is a value in Cklog

I don't know, it mighjt be the MadCow but, if you have some other ideas I
would like to try them.

"ScottO" wrote:

Try something like ...
=If(isblank(CKLOG!$G9),"",BUDGET!$D$19)
Rgds,
ScottO


"Denny Crane" <Denny wrote in
message ...
| 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
|