I have table that shows the number of events.
I would like to add a number to a cell. Whenever i enter a value to that cell, it must be added to that cell's old value. Is this possible?
I have table that shows the number of events.
I would like to add a number to a cell. Whenever i enter a value to that cell, it must be added to that cell's old value. Is this possible?
Hi, welcome to the forum
Does your table contain values of formulas?
If formulas, and if your table starts in A2 to J10, and you put your value in A1, then adjust those formulas to something like this...
=your-formula+$A$1
If your table contains values, then tith your value in A1, copy that cell, then highlight yout table, select Paste Special from te Paste drop-down, check Add, OK
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you very much,
But my table contains values and right now i'm checking the events and i need to add "1" everytime to the table. Isn't there any easy way to make it work?
see my last comment in post 2
Sorry, Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks