+ Reply to Thread
Results 1 to 5 of 5

Adding Value on a Cell ?

  1. #1
    Registered User
    Join Date
    11-05-2014
    Location
    Istanbul
    MS-Off Ver
    2007
    Posts
    3

    Adding Value on a Cell ?

    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?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Adding Value on a Cell ?

    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

  3. #3
    Registered User
    Join Date
    11-05-2014
    Location
    Istanbul
    MS-Off Ver
    2007
    Posts
    3

    Re: Adding Value on a Cell ?

    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?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Adding Value on a Cell ?

    see my last comment in post 2

  5. #5
    Registered User
    Join Date
    11-05-2014
    Location
    Istanbul
    MS-Off Ver
    2007
    Posts
    3

    Re: Adding Value on a Cell ?

    Sorry, Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula for adding a percentage from one cell and adding the total of 2 others
    By Kandra in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-04-2013, 06:48 AM
  2. Replies: 0
    Last Post: 06-12-2013, 09:48 AM
  3. Replies: 4
    Last Post: 05-06-2013, 03:13 PM
  4. [SOLVED] Adding an if statement to vba and adding 1 onto the cell value
    By Nicola13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2012, 05:13 AM
  5. Adding Image into a excel cell and adding a hyperlink to the image
    By saravananiyyanar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2011, 04:16 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1