Hi,
I'm never really used excel,
I'm more of a programmer myself, but at the company i work at they use excel alot.
Now i'm searching for a way to simplify something small.
We have a list of customers that bought stuff.
Next to the name is the value they spended.
This for each prodect they bought.
They are nicly ordered.
When we have our next customer there is an empty line where we calculate the total of the customer spended value.
Now what i'm searching for is an easy code i can just past on top,
copy down and it will only calculate the total value on the empty line.
Something like,
If cell left is empty, select name (3 left 1 up) and then calculate value of all.
Is this possible?
Ifso can someone help me the right direction?
Kind regards,
Kristof;
I'm never really used excel,
I'm more of a programmer myself, but at the company i work at they use excel alot.
Now i'm searching for a way to simplify something small.
We have a list of customers that bought stuff.
Next to the name is the value they spended.
This for each prodect they bought.
They are nicly ordered.
When we have our next customer there is an empty line where we calculate the total of the customer spended value.
Now what i'm searching for is an easy code i can just past on top,
copy down and it will only calculate the total value on the empty line.
Something like,
If cell left is empty, select name (3 left 1 up) and then calculate value of all.
Is this possible?
Ifso can someone help me the right direction?
Kind regards,
Kristof;