+ Reply to Thread
Results 1 to 4 of 4

Problems With Macro to Copy Cells From One Sheet to Next Empty Row In Another Sheet

  1. #1
    Registered User
    Join Date
    03-14-2014
    Location
    Missouri
    MS-Off Ver
    Excel 2003
    Posts
    13

    Problems With Macro to Copy Cells From One Sheet to Next Empty Row In Another Sheet

    I'll start by saying I'm a novice and I am using Excel 2000 to do what I thought was a simple function, so I thought. There are two sheets involved here, a Invoice sheet and a School 1 sheet. The purpose of my macro is to copy four various cells from the Invoice sheet to a row in the School 1 sheet, the next time I run the macro it copies those four to the next row and so on..

    My issue has been that I need to start the row on row 13, trying not to be superstitious here. The macro will copy to the correct row and cells for the first 3 cells but for the final cell it wants to copy to a cell way down the page. It acts as if the cell is unavailable, I have checked and recheck to make sure target cell empty. What could be preventing the macro to copy? Is there a better way to do this, like I said I'm a novice. Any suggestions would be much appreciated, thank you.
    This is my macro:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Problems With Macro to Copy Cells From One Sheet to Next Empty Row In Another Sheet

    I would guess that your column H has some value in it down at the bottom row which you may not be able to see but it causing it to paste in a different location. There are a couple of ways to trouble shoot this:

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Problems With Macro to Copy Cells From One Sheet to Next Empty Row In Another Sheet

    Can you attach samples with some dummy data that doesn't copy to the correct row?

  4. #4
    Registered User
    Join Date
    03-14-2014
    Location
    Missouri
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Problems With Macro to Copy Cells From One Sheet to Next Empty Row In Another Sheet

    When I input the variable and everything worked like a charm, I appreciate your time, thank you!

+ 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. Replies: 0
    Last Post: 03-20-2014, 11:51 AM
  2. Replies: 1
    Last Post: 04-22-2013, 10:34 AM
  3. Replies: 0
    Last Post: 09-15-2012, 06:51 AM
  4. VBA Macro Copy to next empty row, different sheet
    By xenohadden in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-01-2012, 12:41 PM
  5. Copy Multiple Cells to Next empty Cell on New Sheet
    By pk2356 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2010, 10:47 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