Auto-update of value in cell

[enxocoebl]

Hey. I have prepared an excel sheet that records customer data. I have a "total purchase amount" column. I want it to automatically update itself when i print the bill(which is on another sheet). For example a1 refers to total purchase amount of customer xxx. When he/she purchases goods worth say 500$.. I want it to be automatically added to the previous total in a1 and show the new value( previous value+500$) in the same cell... I am explaining so much bcos i am not familiar with the terms used in excel.

 

[kevin lazell]

hi enxocoebl
put this formula in cell(a1)
recall()+(a1)
cheers
kevin

 

[enxocoebl]

Hey i did that. But there is no reference to the other cell i want..that is in the example 500$ is to be added to the value in a1. 500$ is in cell c1. I tried putting recall(c1)+(a1).. But that doesnt work either. And recall formula isnt showing up in the help pop up. I have excel 2007. Thank you in advance

 

[kevin lazell]

hi enxocoebl

formula should be entered into cell(a1)

recall()+(c1)
if the recall function is not in your list of functions
then you will need to download morefunc
from mrexcel website i think or maybe google morefunc

cheers

kevin

 

[enxocoebl]

i ve downloaded all updates. recall function just isnt there. i googled recall function and didnt find what i was looking for. is there another function. i ll use it even if it is lengthy. thanx for the quick replies

 

[kevin lazell]

hello enxocoebl
in google search engine type microsoft morefunc add in

in the list of sites that come up click on the one that says

something like how to download and install morefunc

and watch the tutorial video

cheers

kevin

 

[enxocoebl]

hey thanx man.. it worked. i downloaded the extra func. however it is not as easy as i thot it is. the calculation part.. i have another question can i post it here or should i post it as a new thread?
recall function helpd a lot. thanx kevin.

 

[kevin lazell]

Hi enxocoebl
You will need to start a new thread
Unless the next question is related
You are more likely to get someone
That knows the answer to your new question
The guys and gals on here know a lot
But I can't imagine that everybody
Knows everything
I m glad your last post has been sorted

Cheers

Kevin

 

[enxocoebl]

Hey whats a tracer arrow?
I get circular reference warning all the time when i use recall function.. And a value error in the cells
=if($c$4=$ab4,(recall()+$g$4),$ae4)...formula in entered in ae4
c4 has a barcode number, ab4 also has a list of barcode numbers. G4 has the bill amount which needs to be added to ae4.
I get a value error in ae4. I tried everything( changing dollar signs everywhwere) still doesnt work. Please help...
C4 to i4 (one row only is fixed) ab4 to af4 is dynamic..
Thank you.

 

[kevin lazell]

hi
try this formula in ae4

=IF(C4=AB4,RECALL()+G4)

little concerned you say you have a barcode in c4 and a list of barcodes in ab4
surely c4 is never going to equal ab4

good luck

kevin