+ Reply to Thread
Results 1 to 4 of 4

VBA Macro Copy to next empty row, different sheet

  1. #1
    Registered User
    Join Date
    08-11-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    7

    VBA Macro Copy to next empty row, different sheet

    Hey guys, so I made a macro to copy data from my data entry sheet to my database sheet:

    Please Login or Register  to view this content.
    The main to problems are that its not pasting in in the right collum and its not passing the next entry in the next free row.

    Have attached a screenshot of the two sheets, at the sheet has some personal data, i won't be able to upload it.

    http://i.imgur.com/qnuWr.png

    http://i.imgur.com/hn4En.png
    Hope someone can help me wrap my head round this, been searching all over the web all day !
    Last edited by xenohadden; 09-01-2012 at 11:59 AM.

  2. #2
    Registered User
    Join Date
    08-11-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: VBA Macro Copy to next empty row, different sheet

    I need to fix the coding so that it paste each filled in data from the data entry tab, into an empty row in the database tab.

    Each time I press input data, it should paste onto the other sheet, below any existing lines of data.

    Thanks!

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: VBA Macro Copy to next empty row, different sheet

    Hi, xenohadden,

    as per Rule #8 of the Forum Rules you should add a link to your other thread (itīs Posting Rule #24 at Mr. Excel).

    Ciao,
    Holger

  4. #4
    Registered User
    Join Date
    08-11-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: VBA Macro Copy to next empty row, different sheet

    Quote Originally Posted by HaHoBe View Post
    Hi, xenohadden,

    as per Rule #8 of the Forum Rules you should add a link to your other thread (itīs Posting Rule #24 at Mr. Excel).

    Ciao,
    Holger
    applogise didnt realise, feel free to delete this thread if nessery

+ 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