+ Reply to Thread
Results 1 to 3 of 3

data entry to loop to next row

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    Doha, Qatar
    MS-Off Ver
    Excel 2010
    Posts
    10

    data entry to loop to next row

    Hello all,

    so I have a table to enter data, seven columns... I have wrote a command button with a inputbox code.

    so basicly what I do is.. I click the command button and it asks me to fill the data from cell A2 to G2.

    what I need is that after I fill data on G2, I need to repeat the whole process on the next row which means from A3 to G3 and so on.... in other words I need the code to reach column G then go back to column A but in the next row.

    here is what I have as a code:

    Please Login or Register  to view this content.

    P.S im also attaching the worksheet

    Thanks
    Attached Files Attached Files
    Last edited by m.nimri; 01-15-2014 at 02:26 PM.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: data entry to loop to next row

    Welcome to the forum.

    We'd like to help you but first..

    Pls take some minutes to read forum rules and specially-in this case- rule#3
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    01-09-2014
    Location
    Doha, Qatar
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: data entry to loop to next row

    Thank you for your advice. I did edit it as the rules says. Can you help me now please.

+ 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. Help on duplicate password entry loop to retry
    By jhamer-arthrex in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2013, 01:20 PM
  2. how to entry same number twice when I alr set cannnot entry duplicate data.
    By Adamlearnexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2012, 09:44 PM
  3. Do Loop/Function/VB/Macro to automate system description ID entry
    By ShagNasty in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-02-2012, 04:35 PM
  4. Vba for move data & clear entry screen for entry new data..
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-27-2012, 09:19 PM
  5. Replies: 0
    Last Post: 10-06-2011, 07:03 AM

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