Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Accounting Functions - List box
I am not sure if this is possible...I am trying to create a type of general
journal/ledger all in one...what I would like is to have a general journal/register worksheet (wksht 1) for each month...and on that have a drop down list for the general ledger accounts which will be on another sheet (wksht 2). SO...you would input the transaction into the one worksheet (wksht 1), pick the ledger account form the list...it then takes the amount and places it on the second worksheet (wksht 2) into the correct column based on what account you chose from the list. The columns on the ledger worksheet would show all the transactions for that account instead of just adding them into one cell! Does that make any sense...and is it possible to do!? I need to be able to look at ledger accounts per month...and currently I am inputing manually into each ledger column for each month's worksheet...I was hoping to just be able to have it pull from the general journal worksheet but still breakout properly on the individual monthly sheets! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identify & List unique values from a list using functions/formulas | Excel Worksheet Functions | |||
List of Control functions | Excel Worksheet Functions | |||
List of in this workbook only Functions | Excel Worksheet Functions | |||
WORKSHEET FUNCTIONS - LIST OF ALL ?? | Excel Worksheet Functions | |||
custom list with accounting format | Excel Discussion (Misc queries) |