G
Guest
I'm a begining excel user so my question is more or less in laymen's terms;
What I would like to do is take a number that I place in one cell and post
it to a list of vertical cells in a different worksheet; as if the number was
being placed one after another in a vertical fashion on another page. The
list that it would be placed in would be determined by the text in an
adjacent cell. Particularly I'm making accounting records and I'm using one
sheet as a general journal and I want the number to post itself to the ledger
account on another sheet. I want the list that it's put in to be determined
by the account title that I put in a cell that is on the same horizontal axis
as it. I was thinking that I could make some sort of conditional test but
excel only allows for 7 nested conditions and i have about 20 so far.
thanks in advance to anyone willing to help me out
-Brian
What I would like to do is take a number that I place in one cell and post
it to a list of vertical cells in a different worksheet; as if the number was
being placed one after another in a vertical fashion on another page. The
list that it would be placed in would be determined by the text in an
adjacent cell. Particularly I'm making accounting records and I'm using one
sheet as a general journal and I want the number to post itself to the ledger
account on another sheet. I want the list that it's put in to be determined
by the account title that I put in a cell that is on the same horizontal axis
as it. I was thinking that I could make some sort of conditional test but
excel only allows for 7 nested conditions and i have about 20 so far.
thanks in advance to anyone willing to help me out
-Brian