Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add values within cells
This sounds easy but i do nt know...
I have a cell in which it holds a value of qauntity. as i am counting hte qaunity from page to page from my data ( paper source) i want it to add each time i out the new value in the same cell. is htere a funtion or a macro is needed?? ie: cell A2 has value 10.. i found another 15 of the same item and want to add it to the 10 in the cell. the value now holds 25. I want it to where the 10 is in ther and i just put in 15 and then hit add or something to give me the new value. like you would on a calculator. isit possible? i ahve large numbers and many pages to go thru. many thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
add values within cells
You could use the worksheetchange event to do it, but how would you define
when it is appropriate and when it is not appropriate. http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "mlm" wrote in message ... This sounds easy but i do nt know... I have a cell in which it holds a value of qauntity. as i am counting hte qaunity from page to page from my data ( paper source) i want it to add each time i out the new value in the same cell. is htere a funtion or a macro is needed?? ie: cell A2 has value 10.. i found another 15 of the same item and want to add it to the 10 in the cell. the value now holds 25. I want it to where the 10 is in ther and i just put in 15 and then hit add or something to give me the new value. like you would on a calculator. isit possible? i ahve large numbers and many pages to go thru. many thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
add values within cells
hello tom, seems like you are stuck with me each time i
post.. not bad though ..i like your help. That was the ? i had when i was searching for a solution. it is just painstaking and time sonsuming to go back and ad off the sheet and then input new number value in the cell. its actually a one time thing but for 100 items?? whew! thanks tom. -----Original Message----- You could use the worksheetchange event to do it, but how would you define when it is appropriate and when it is not appropriate. http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "mlm" wrote in message ... This sounds easy but i do nt know... I have a cell in which it holds a value of qauntity. as i am counting hte qaunity from page to page from my data ( paper source) i want it to add each time i out the new value in the same cell. is htere a funtion or a macro is needed?? ie: cell A2 has value 10.. i found another 15 of the same item and want to add it to the 10 in the cell. the value now holds 25. I want it to where the 10 is in ther and i just put in 15 and then hit add or something to give me the new value. like you would on a calculator. isit possible? i ahve large numbers and many pages to go thru. many thanks! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
find values in multiple cells and paste row values | Excel Discussion (Misc queries) | |||
average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
conditional formating cells i Excel based on other cells values | Excel Worksheet Functions |