+ Reply to Thread
Results 1 to 11 of 11

macro to record and enter data in a new row

  1. #1
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    222

    macro to record and enter data in a new row

    Evening Guys,

    I am trying to have a macro send the data from sheet 2 to sheet 3, record the data then next time shift down a row and enter the new data below and below every time new data is entered.

    I have recorded a macro, but I am stuck with the recording the data and then returning to a new row.

    Any help much appreciated



    Stephen
    Attached Files Attached Files
    Last edited by stephen1000; 03-17-2009 at 08:07 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: macro to record and enter data in a new row

    see the contacts form here

    http://www.excel-it.com/vba_examples.htm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    222

    Re: macro to record and enter data in a new row

    thanks for that

    will look see if I can figure it out

    cheers

  4. #4
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    222

    Re: macro to record and enter data in a new row

    Hi Roy,

    I am a bit stuck, not sure if I am doing it right; obviously not

    posted the work book

    compile error

    variable not found

    help please
    Attached Files Attached Files

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: macro to record and enter data in a new row

    Stephen,

    These assignments
    Please Login or Register  to view this content.
    ... refer to the CodeName property of the worksheets, not the Name property, and there is no sheet with CodeName Sheet2.

    Look in the VBE and change the CodeName of each sheet to agree with the Name.

    Or change the assignment to use the Name:
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: macro to record and enter data in a new row

    As Shg says you need to amend the sheet references & alo create a Named Range - DataInput, to refer to the input cells
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    222

    Re: macro to record and enter data in a new row

    Quote Originally Posted by royUK View Post
    As Shg says you need to amend the sheet references & alo create a Named Range - DataInput, to refer to the input cells
    I must be thick, dont see what you have done!

    not sure what shg means about naming

    sorry

    stephen

  8. #8
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    222

    Re: macro to record and enter data in a new row

    Hi Guys


    me finks i sorted it, its all coming together slowly
    Attached Files Attached Files

  9. #9
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: macro to record and enter data in a new row

    Very nice macro, Stephen.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  10. #10
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    222

    Re: macro to record and enter data in a new row

    Quote Originally Posted by JBeaucaire View Post
    Very nice macro, Stephen.
    Morning Dude, thank you, not me Everyone around all over the WORLD

  11. #11
    Registered User
    Join Date
    12-24-2010
    Location
    Cambodia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: macro to record and enter data in a new row

    Could u explain me, or show me step by step to do this? or just a small example with a few row r column. thanks

+ 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