Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to prevent copied data from appearing until triggered by anoth
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
New data will not sort with existing data from copied file | Excel Worksheet Functions | |||
prevent display of data series dropping to graph x axis for null d | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |