L
LeahT
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!
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!