Hi there!
I use Excel 2003 (SP2) (dutch language) and would like to find a solution for the following situation:
In a financial administration I want to manually insert as less as possible, for obvious reasons ;-). I only want to insert the information from my bank receipts, like "date", "description" and "amount", and after that, manually insert per line a number, corresponding one of the book accounts (like, "sold books"). Every line should be formatted like that, without knowing how many lines I need.
The product should be (an overview of) a series of book accounts, in which only the lines are mentioned which are relevant for that book account. I don't want empty lines or clogging zero's in the book accounts.
I already tried inserting in the book account an IF-statement like
, where
invulschema afschriften is the worksheet in which I fill in the bank receipt lines;
F4 in the bank receipt worksheet is the cell in which I inserted the book account;
D1 is the cell that contains the desired book acount number; and
D4 in the bank receipt worksheet contains the amount I need copied.
It works this far: I get the desired amounts in the right place. But it also leaves either zero's or - blanking out zero's - empty lines. And that looks really silly (quite annoying actually) in a book account.
Can anyone solve this? Is there a function that says "IF cell X CORRESPONDS WITH cell Y THEN copy cell Z to next empty row ELSE ignore" or something? Or is there a way to work around this?
Thanks in advance,
Kisses,
Tanja.
I use Excel 2003 (SP2) (dutch language) and would like to find a solution for the following situation:
In a financial administration I want to manually insert as less as possible, for obvious reasons ;-). I only want to insert the information from my bank receipts, like "date", "description" and "amount", and after that, manually insert per line a number, corresponding one of the book accounts (like, "sold books"). Every line should be formatted like that, without knowing how many lines I need.
The product should be (an overview of) a series of book accounts, in which only the lines are mentioned which are relevant for that book account. I don't want empty lines or clogging zero's in the book accounts.
I already tried inserting in the book account an IF-statement like
Code:
ALS('invulschema afschriften'!F4=D1;'invulschema afschriften'!D4;0)invulschema afschriften is the worksheet in which I fill in the bank receipt lines;
F4 in the bank receipt worksheet is the cell in which I inserted the book account;
D1 is the cell that contains the desired book acount number; and
D4 in the bank receipt worksheet contains the amount I need copied.
It works this far: I get the desired amounts in the right place. But it also leaves either zero's or - blanking out zero's - empty lines. And that looks really silly (quite annoying actually) in a book account.
Can anyone solve this? Is there a function that says "IF cell X CORRESPONDS WITH cell Y THEN copy cell Z to next empty row ELSE ignore" or something? Or is there a way to work around this?
Thanks in advance,
Kisses,
Tanja.
),"",z)[/color]