+ Reply to Thread
Results 1 to 12 of 12

Macro to edit a cell in a column and go to the next cell below it.

  1. #1
    Registered User
    Join Date
    04-01-2019
    Location
    Bengaluru
    MS-Off Ver
    2016
    Posts
    18

    Question Macro to edit a cell in a column and go to the next cell below it.

    Hi, i'm fairly new to excel and can't find a decent place to learn everything about macros so i'm just learning as per my needs.
    Here i want to edit a cell in a column, and then go to the cell below it. I have created a button, so when i press that button, i want to edit a cell in the specific column and go to the cell below it, so that when i press the button the next time, the macro edits the next cell. Pls help asap.
    Thanks.

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Macro to edit a cell in a column and go to the next cell below it.

    Not clear for me. You can edit a cell and press Enter then the next cell will be selected and so on ...
    Can you give more details?
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    04-01-2019
    Location
    Bengaluru
    MS-Off Ver
    2016
    Posts
    18

    Re: Macro to edit a cell in a column and go to the next cell below it.

    What i want to do is, when i press the button, it should run a macro that should edit a cell. and when i press that button again, it should edit the cell below the previous cell.
    Suppose, i press button, it enteres "Yes" in the first cell of a column, when i press the button for the 2nd time, it goes to the second cell and enters "Yes" in that cell as well.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: Macro to edit a cell in a column and go to the next cell below it.

    Play around with this...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  5. #5
    Registered User
    Join Date
    04-01-2019
    Location
    Bengaluru
    MS-Off Ver
    2016
    Posts
    18

    Re: Macro to edit a cell in a column and go to the next cell below it.

    Thank you so much, that worked

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: Macro to edit a cell in a column and go to the next cell below it.

    ..............................................
    Thanks.gif

    Pls dont forget to mark thread as solved............

  7. #7
    Registered User
    Join Date
    04-01-2019
    Location
    Bengaluru
    MS-Off Ver
    2016
    Posts
    18

    Re: Macro to edit a cell in a column and go to the next cell below it.

    What should i do if i want to rotate the active cell in just a range of 100 cells of the column, and i dont want to have to click a cell and then click the button?

  8. #8
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: Macro to edit a cell in a column and go to the next cell below it.

    I don't understand the question...What is it you actually want to do...
    Explain your scenario or add a sample file...

  9. #9
    Registered User
    Join Date
    04-01-2019
    Location
    Bengaluru
    MS-Off Ver
    2016
    Posts
    18

    Re: Macro to edit a cell in a column and go to the next cell below it.

    I have 2 columns, Date and Task, I want to press a button that would enter "Done" in a cell against a date. The next time i press the same button, it should enter "Done" in the cell below the previous one. My active cell could be anywhere in the sheet, but when i press that button, it should edit the next cell in that specific "Task" column.

    PS. i dont know how to add a sample file.

  10. #10
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: Macro to edit a cell in a column and go to the next cell below it.

    PS. i dont know how to add a sample file.
    Below Post Text Reply Window
    Press
    [Go Advanced]
    [Manage Attachments]
    [Browse] for your file...
    [Upload]
    [Close this window]
    [Submit Reply]


    Edit...Try this...

    Assumes date is in Col A and Task in Col B
    Please Login or Register  to view this content.
    Last edited by sintek; 04-03-2019 at 12:38 AM.

  11. #11
    Registered User
    Join Date
    04-01-2019
    Location
    Bengaluru
    MS-Off Ver
    2016
    Posts
    18

    Re: Macro to edit a cell in a column and go to the next cell below it.

    Thank you so much, I dont understand how this macro is working though. Can you suggest anywhere online that i can learn about this?

  12. #12
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: Macro to edit a cell in a column and go to the next cell below it.

    See attached file...

    Code looks for next available row in Col B and populates it...No matter where cursor finds itself...
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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] lock after edit each cell in column L to Q and stamp date and username in column R and S
    By Norlina Deli in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-09-2019, 06:59 AM
  2. Edit Cell (column B) according to user's selected value on column A
    By cherrydee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2018, 02:40 AM
  3. [SOLVED] want to edit recorded macro code or copy a cell with formula and paste it down to "x" cell
    By bmbalamurali in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 10-25-2013, 04:57 PM
  4. Formula/macro to edit cells in one column based on contents of a cell in another column
    By robbyvegas in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-25-2012, 06:10 AM
  5. Restrict edit cell,row, column
    By tanksalevikrant in forum Excel General
    Replies: 1
    Last Post: 05-10-2007, 03:58 AM
  6. Run macro on cell edit
    By Defoes Right Boot in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-09-2005, 08:05 AM
  7. edit cell by macro
    By helpwithXL in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-04-2005, 02:06 PM

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