+ Reply to Thread
Results 1 to 8 of 8

How to enter data then move automatically to new cell?

  1. #1
    Registered User
    Join Date
    11-20-2005
    Posts
    33

    How to enter data then move automatically to new cell?

    Hi,

    I am entering lots of family history data into a spreadsheet. At the simplest I have columns (in cells A1 B1 C1) the headings, Surname, Forename, Year. Right now, I enter in cells A2 B2 and C2 say: Smith <Tab> John <Tab> 1555 <Enter, move mouse to the A column in the next row down). What I want to happen is when I have entered the last data in a row and pressed <Enter> I move automatically to the A-column in the next row down.

    Is this possible?

    Regards and a Merry Christmas to all

    Wibs

  2. #2
    Don Guillett
    Guest

    Re: How to enter data then move automatically to new cell?

    This is worksheet event and must be put in the sheet module. So, right click
    sheet tab>view code>copy/paste this>modify to suit>SAVE

    Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
    If Target.Row > 1 And Target.Column = 3 Then ActiveCell.Offset(1, -3).Select
    End Sub

    --
    Don Guillett
    SalesAid Software
    dguillett1@austin.rr.com
    "Wibs" <Wibs.2092iy_1134933300.7622@excelforum-nospam.com> wrote in message
    news:Wibs.2092iy_1134933300.7622@excelforum-nospam.com...
    >
    > Hi,
    >
    > I am entering lots of family history data into a spreadsheet. At the
    > simplest I have columns (in cells A1 B1 C1) the headings, Surname,
    > Forename, Year. Right now, I enter in cells A2 B2 and C2 say: Smith
    > <Tab> John <Tab> 1555 <Enter, move mouse to the A column in the next
    > row down). What I want to happen is when I have entered the last data
    > in a row and pressed <Enter> I move automatically to the A-column in
    > the next row down.
    >
    > Is this possible?
    >
    > Regards and a Merry Christmas to all
    >
    > Wibs
    >
    >
    > --
    > Wibs
    > ------------------------------------------------------------------------
    > Wibs's Profile:
    > http://www.excelforum.com/member.php...o&userid=28922
    > View this thread: http://www.excelforum.com/showthread...hreadid=494464
    >




  3. #3
    Ron Coderre
    Guest

    RE: How to enter data then move automatically to new cell?

    Have you considered a Data Form?

    Try this:
    A1: Surname
    B1: Forename
    C1: Year

    Select A1:C1
    Data>Form
    (Excel will give a warning...ignore it and click OK)

    A data form will open.
    [Tab] advances through fields
    Pressing [Enter] goes to the next record

    Something you can work with?

    ***********
    Regards,
    Ron

    XL2002, WinXP-Pro


    "Wibs" wrote:

    >
    > Hi,
    >
    > I am entering lots of family history data into a spreadsheet. At the
    > simplest I have columns (in cells A1 B1 C1) the headings, Surname,
    > Forename, Year. Right now, I enter in cells A2 B2 and C2 say: Smith
    > <Tab> John <Tab> 1555 <Enter, move mouse to the A column in the next
    > row down). What I want to happen is when I have entered the last data
    > in a row and pressed <Enter> I move automatically to the A-column in
    > the next row down.
    >
    > Is this possible?
    >
    > Regards and a Merry Christmas to all
    >
    > Wibs
    >
    >
    > --
    > Wibs
    > ------------------------------------------------------------------------
    > Wibs's Profile: http://www.excelforum.com/member.php...o&userid=28922
    > View this thread: http://www.excelforum.com/showthread...hreadid=494464
    >
    >


  4. #4
    Peo Sjoblom
    Guest

    Re: How to enter data then move automatically to new cell?

    If you have default excel settings and are using tab to go to the next cell,
    that is how it is supposed to work
    look under tools>options>edit and make sure move selection after enter is
    checked and it's set to down, then if you use the tab key it should go to
    the first column one row below when pressing enter

    --
    Regards,

    Peo Sjoblom

    (No private emails please)


    "Wibs" <Wibs.2092iy_1134933300.7622@excelforum-nospam.com> wrote in message
    news:Wibs.2092iy_1134933300.7622@excelforum-nospam.com...
    >
    > Hi,
    >
    > I am entering lots of family history data into a spreadsheet. At the
    > simplest I have columns (in cells A1 B1 C1) the headings, Surname,
    > Forename, Year. Right now, I enter in cells A2 B2 and C2 say: Smith
    > <Tab> John <Tab> 1555 <Enter, move mouse to the A column in the next
    > row down). What I want to happen is when I have entered the last data
    > in a row and pressed <Enter> I move automatically to the A-column in
    > the next row down.
    >
    > Is this possible?
    >
    > Regards and a Merry Christmas to all
    >
    > Wibs
    >
    >
    > --
    > Wibs
    > ------------------------------------------------------------------------
    > Wibs's Profile:
    > http://www.excelforum.com/member.php...o&userid=28922
    > View this thread: http://www.excelforum.com/showthread...hreadid=494464
    >



  5. #5
    JMay
    Guest

    Re: How to enter data then move automatically to new cell?

    No code required;
    Just highlight A2:C100
    and enter your data and TAB 100% of time (No use of Enter key.
    HTH



    "Wibs" <Wibs.2092iy_1134933300.7622@excelforum-nospam.com> wrote in message
    news:Wibs.2092iy_1134933300.7622@excelforum-nospam.com...
    >
    > Hi,
    >
    > I am entering lots of family history data into a spreadsheet. At the
    > simplest I have columns (in cells A1 B1 C1) the headings, Surname,
    > Forename, Year. Right now, I enter in cells A2 B2 and C2 say: Smith
    > <Tab> John <Tab> 1555 <Enter, move mouse to the A column in the next
    > row down). What I want to happen is when I have entered the last data
    > in a row and pressed <Enter> I move automatically to the A-column in
    > the next row down.
    >
    > Is this possible?
    >
    > Regards and a Merry Christmas to all
    >
    > Wibs
    >
    >
    > --
    > Wibs
    > ------------------------------------------------------------------------
    > Wibs's Profile:
    > http://www.excelforum.com/member.php...o&userid=28922
    > View this thread: http://www.excelforum.com/showthread...hreadid=494464
    >




  6. #6
    Registered User
    Join Date
    11-20-2005
    Posts
    33
    Many thanks for the suggestion. Could you please explain what you mean by 'highlight'. You are not talking of 'selecting' A2:C100 are you?

    Regards

    Wibs
    Quote Originally Posted by JMay
    No code required;
    Just highlight A2:C100
    and enter your data and TAB 100% of time (No use of Enter key.
    HTH




    "Wibs" <Wibs.2092iy_1134933300.7622@excelforum-nospam.com> wrote in message
    news:Wibs.2092iy_1134933300.7622@excelforum-nospam.com...
    >
    > Hi,
    >
    > I am entering lots of family history data into a spreadsheet. At the
    > simplest I have columns (in cells A1 B1 C1) the headings, Surname,
    > Forename, Year. Right now, I enter in cells A2 B2 and C2 say: Smith
    > <Tab> John <Tab> 1555 <Enter, move mouse to the A column in the next
    > row down). What I want to happen is when I have entered the last data
    > in a row and pressed <Enter> I move automatically to the A-column in
    > the next row down.
    >
    > Is this possible?
    >
    > Regards and a Merry Christmas to all
    >
    > Wibs
    >
    >
    > --
    > Wibs
    > ------------------------------------------------------------------------
    > Wibs's Profile:
    > http://www.excelforum.com/member.php...o&userid=28922
    > View this thread: http://www.excelforum.com/showthread...hreadid=494464
    >

  7. #7
    JMay
    Guest

    Re: How to enter data then move automatically to new cell?

    Yes, selecting is alternative lingo.
    Left Click and hold down on A2, and drag to C100 and
    release mouse button.



    "Wibs" <Wibs.209bbm_1134944701.3714@excelforum-nospam.com> wrote in message
    news:Wibs.209bbm_1134944701.3714@excelforum-nospam.com...
    >
    > Many thanks for the suggestion. Could you please explain what you mean
    > by 'highlight'. You are not talking of 'selecting' A2:C100 are you?
    >
    > Regards
    >
    > WibsJMay Wrote:
    >> No code required;
    >> Just highlight A2:C100
    >> and enter your data and TAB 100% of time (No use of Enter key.
    >> HTH
    >>
    >>
    >>
    >>
    >> "Wibs" <Wibs.2092iy_1134933300.7622@excelforum-nospam.com> wrote in
    >> message
    >> news:Wibs.2092iy_1134933300.7622@excelforum-nospam.com...
    >> >
    >> > Hi,
    >> >
    >> > I am entering lots of family history data into a spreadsheet. At the
    >> > simplest I have columns (in cells A1 B1 C1) the headings, Surname,
    >> > Forename, Year. Right now, I enter in cells A2 B2 and C2 say: Smith
    >> > <Tab> John <Tab> 1555 <Enter, move mouse to the A column in the next
    >> > row down). What I want to happen is when I have entered the last

    >> data
    >> > in a row and pressed <Enter> I move automatically to the A-column in
    >> > the next row down.
    >> >
    >> > Is this possible?
    >> >
    >> > Regards and a Merry Christmas to all
    >> >
    >> > Wibs
    >> >
    >> >
    >> > --
    >> > Wibs
    >> >

    >> ------------------------------------------------------------------------
    >> > Wibs's Profile:
    >> > http://www.excelforum.com/member.php...o&userid=28922
    >> > View this thread:

    >> http://www.excelforum.com/showthread...hreadid=494464
    >> >

    >
    >
    > --
    > Wibs
    > ------------------------------------------------------------------------
    > Wibs's Profile:
    > http://www.excelforum.com/member.php...o&userid=28922
    > View this thread: http://www.excelforum.com/showthread...hreadid=494464
    >




  8. #8
    Registered User
    Join Date
    11-20-2005
    Posts
    33
    My goodness.

    4 different methods proposed. All four work!!

    What a forum!

    Thanks to all

    Wibs

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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