Results 1 to 4 of 4

goto function

Threaded View

jbrandon goto function 06-13-2010, 12:26 PM
royUK Re: goto function 06-13-2010, 12:30 PM
jbrandon Re: goto function 06-13-2010, 12:32 PM
royUK Re: goto function 06-13-2010, 12:32 PM
  1. #1
    Registered User
    Join Date
    06-13-2010
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    6

    Talking goto function

    Hi there,

    Hope someone can help. I've been looking for a while now but can't seem to find what i'm looking for.

    Basically I need cell B16 to jump to cell B2 automatically once the cell is active.

    I have a sheet like this
    B2 1
    B3 3
    B4 4 and so on.... and when i get to

    B16 I don't want to enter anything but as soon as I hit enter on cell B15 and B16 becomes active, I want it to jump back to B2 so i can start the process again and enter new values.

    Any ideas?

    Many thanks
    Last edited by jbrandon; 06-13-2010 at 12:35 PM. Reason: solved in a flash

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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