Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating sub-sheet
I download my bank statement from the internet onto a spreadsheet, then code
the items for accounting purposes. Is there any way that I can create a 'Sub-sheet' that enables me to split some statement items into several account codes without inserting whole rows to show the split? eg. an item on bank statement is $1,000. I want to keep the total visible in its original location but be able to split the transaction into say stationery $100 & computer $900 and have those split accounts available to accumulate through SUMIF function in another sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Lookup function and compare | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |