+ Reply to Thread
Results 1 to 2 of 2

Moving Cells back to orginal cell after data is calculate.

  1. #1
    Registered User
    Join Date
    09-16-2016
    Location
    Ohio, USA
    MS-Off Ver
    2010
    Posts
    43

    Moving Cells back to orginal cell after data is calculate.

    Is there any way I can make my calculator automatic move my selected cell back to the first entry once I run the calculation.

    Currently I'm have my first variable in C4 and then my second in C5 the out put of the calculation from those cells goes into C6. After I enter a variable in C4 I hit enter then enter the variable in to C5 hit enter and it drops down to C6.

    I'm trying to make it so when in C5 and I hit enter my selected cell moves back to C4 so I can make another calculation. I do many calculation with this. It would just be a time saver. If its not possible no biggy I'll just deal with it.

    Thank you for any help or guidance in advance,
    TJ

    P.S. if you would like a copy of the workbook that I'm working on just let me know

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Moving Cells back to orginal cell after data is calculate.

    In Worksheet_SelectionChange

    Please Login or Register  to view this content.
    Kind regards
    Leo

+ 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] New to VBA Need help on moving rows back and forth between sheets based on cell Value
    By stkachuk07 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-24-2016, 01:12 PM
  2. Replies: 9
    Last Post: 07-29-2014, 11:41 AM
  3. Copying over cells from one sheet to the next and deleting orginal cell source
    By masond3 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-27-2013, 07:54 AM
  4. Getting back the orginal saved spread sheet?
    By mard in forum Excel General
    Replies: 1
    Last Post: 11-15-2008, 06:52 PM
  5. [SOLVED] how do i get my orginal excel file back after saving over it
    By dennis in forum Excel General
    Replies: 2
    Last Post: 07-03-2006, 03:10 AM
  6. Replies: 1
    Last Post: 08-29-2005, 04:05 PM
  7. Moving data back and forth between Excel and SQL Server
    By Robert Pfister in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2005, 10:06 PM

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