Forum Discussion
Excel formulas
Hi, Is there a way to enter a number in a cell - "income" then hit "enter" button and it disappears summing all entered numbers in next cell "quantity" ?
So this is my table.
here's what I'm trying to do
I guess there would be a little bit different algorithm
Hi Mix
Sorry for the late response, busy times!
Apologies, I likely haven't understood your requirements properly and I think seeing your spreadsheet that the answer is also outside my experience.
I do think a macro is the likely answer but you'll need the help of the more experienced people here to fill that gap!
I hope you find the answer to your question, might be worth researching on Google for ideas too. Chances are others have produced something that you could try.
Best wishes
Damien
Sorry for the late response, busy times!
Apologies, I likely haven't understood your requirements properly and I think seeing your spreadsheet that the answer is also outside my experience.
I do think a macro is the likely answer but you'll need the help of the more experienced people here to fill that gap!
I hope you find the answer to your question, might be worth researching on Google for ideas too. Chances are others have produced something that you could try.
Best wishes
Damien
- Anyway, thanks for all your help and support)