+ Reply to Thread
Results 1 to 2 of 2

VBA to add from previous cell

  1. #1
    Registered User
    Join Date
    06-27-2014
    Location
    Arkansas
    MS-Off Ver
    365
    Posts
    57

    VBA to add from previous cell

    Hello, I am trying to get vba to look at cell A18 then add 15 and put this number into Cell A19. I want to set up a loop to do this for each cell from A18: A918 always adding 15 to the cell above. So cell A20 would be A19 + 15, A21 would be A20+15 and so on. Any help would be appreciated. Thanks

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: VBA to add from previous cell

    You can try this-
    Please Login or Register  to view this content.
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

+ 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] Find certain word, copy and paste cell in previous row if previous row is blank
    By steven_e in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2013, 12:53 PM
  2. [SOLVED] Make Cell Reference to Either a cell in Previous Tab or the Previous Tabs Name
    By paddyk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2013, 01:13 PM
  3. Auto-move previous content from cell a to cell b by changing cell a
    By Matt81a in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2013, 03:32 PM
  4. [SOLVED] Find last previous non blank value and summarise previous 6 months
    By Lady_Shaz in forum Excel General
    Replies: 7
    Last Post: 12-11-2012, 06:20 AM
  5. Replies: 1
    Last Post: 04-30-2012, 06:02 AM
  6. Replies: 0
    Last Post: 10-14-2011, 12:09 PM
  7. Replies: 1
    Last Post: 12-01-2010, 03:20 PM
  8. Replies: 3
    Last Post: 11-17-2010, 04:28 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