+ Reply to Thread
Results 1 to 6 of 6

Copy paste values from sheets into one master sheet

  1. #1
    Valued Forum Contributor
    Join Date
    08-10-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    721

    Copy paste values from sheets into one master sheet

    I need a looping code that copies and pastes data from each sheet in a workbook to the bottom of the sheet called "Data", then move on to the net sheet and repeat the process.

    Here is what I have so far, but the code just loops the Data sheet, rather than ignore the data sheet!

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Copy paste values from sheets into one master sheet

    Please find attached
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    08-10-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    721

    Re: Copy paste values from sheets into one master sheet

    AB33 you are a legend.

    I deleted the

    Please Login or Register  to view this content.
    as I want to continually add to the data spreadsheet with more and more, so I didnt want that to be erased every time i ran the macro .... thanks!!!

    I have found a problem....
    With your code that identifies the last row of data, i have noticed that in my data at times I may have hundreds of blank rows then randomly there will be a "0" or something. Your code looks for that and therefore copies all those blank rows to the data sheet. How can I overcome this?


    Solved with this addition

    Please Login or Register  to view this content.
    Last edited by nickmax1; 03-20-2013 at 10:17 AM.

  4. #4
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Copy paste values from sheets into one master sheet

    In which column are the blank rows? I can include few lines to delete them

  5. #5
    Valued Forum Contributor
    Join Date
    08-10-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    721

    Re: Copy paste values from sheets into one master sheet

    thanks AB33 - solved it with this addition to your code:

    Please Login or Register  to view this content.

  6. #6
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Copy paste values from sheets into one master sheet

    Nick,
    Great!
    That was about going to suggest. Instead of looping through each row in each sheet to identify blanks, it would be efficient to do on a summary sheet.
    Sorry for not helpful with your earlier request?

  7. #7
    Valued Forum Contributor
    Join Date
    08-10-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    721

    Re: Copy paste values from sheets into one master sheet

    AB33

    you have been a great help....thankyou

+ 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