Results 1 to 9 of 9

Need press enter key to move down one cell and to the left one cell

Threaded View

  1. #1
    Registered User
    Join Date
    11-29-2018
    Location
    Martinez, CA
    MS-Off Ver
    Excel 2018
    Posts
    20

    Need press enter key to move down one cell and to the left one cell

    Hello,
    I have a chart where a macro has made formatting changes and added formulas to existing data.
    Now I just need to enter data into two columns on each row but there are over 100 rows.
    I would like pressing the enter key on my numeric keypad to take the active cell down and to the left.
    Is there a code I can add to my macro for these two columns to make that happen?
    In the attached, I would like pressing the enter key to take me from C4 to B5 with the one keystroke
    Thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 12
    Last Post: 04-29-2024, 06:52 PM
  2. Move anohter column after return when I press enter
    By jc83ph in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2019, 03:14 AM
  3. Not move to next Textbox after press ENTER/TAB Key, after SetFocus
    By ajimieta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2017, 12:42 AM
  4. How to run auto press 'Enter' key on certain cell before printing?
    By putritersenyum in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2016, 08:50 AM
  5. [SOLVED] To move cursor to the next row automatically when we enter press
    By catchnanan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-19-2013, 09:13 AM
  6. Cell gives incorrect value when I press ENTER.
    By Matthew.Newlove in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 04-25-2012, 10:58 AM
  7. must press enter 2x to move cell focus
    By Lynn in forum Excel General
    Replies: 0
    Last Post: 03-18-2005, 03: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