+ Reply to Thread
Results 1 to 8 of 8

Copy rows from multiple sheets paste to new sheet

  1. #1
    Registered User
    Join Date
    08-15-2012
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    73

    Copy rows from multiple sheets paste to new sheet

    Good Day,

    I have a workbook with about 40 sheets. The sheets are all setup the same. 7 row header with the data starting on row 8.
    I would like to copy all rows (starting with row 8 and ending with the last row of data) on all contract sheets. The copied rows will be pasted in the sheet titled OPS View starting at row 8. I've found tons of code online but because of my inexperience I am unable to make them work for me. Any help is greatly appreciated.

    Sample workbook is attached. The real workbook the worksheets have different names (except for OPS View.

    Thank You
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: Copy rows from multiple sheets paste to new sheet

    Try:
    Please Login or Register  to view this content.
    You have two empty macros in the code module for the OPS View sheet. You should delete those macros.
    Last edited by Mumps1; 12-14-2017 at 03:12 PM.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    08-15-2012
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    73

    Re: Copy rows from multiple sheets paste to new sheet

    Hi Mumps1 - Thanks for your help. The results are pasting in cell A2 which is making me lose my header on the OPS View sheet. Can we paste in cell A8? Also can we paste values? The formulas get all messed.

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: Copy rows from multiple sheets paste to new sheet

    Try:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-15-2012
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    73

    Re: Copy rows from multiple sheets paste to new sheet

    Yes!! The data placement is perfect. Can we paste values only? The formulas are all messed up.

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: Copy rows from multiple sheets paste to new sheet

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    08-15-2012
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    73

    Re: Copy rows from multiple sheets paste to new sheet

    Thank you Thank you Thank you . Your help is greatly appreciated.

  8. #8
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: Copy rows from multiple sheets paste to new sheet

    You are very welcome.

+ 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. [SOLVED] Copy Paste From Rawdata Sheets to Multiple Sheets Based on Sheet names
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2017, 11:01 PM
  2. Copy and paste equal rows from master sheet to other sheets
    By Sasquatch2014 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-05-2017, 09:42 AM
  3. [SOLVED] Copy from different sheets- data based on selection and paste rows in new sheet
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2014, 03:30 AM
  4. [SOLVED] copy range from multiple sheets and paste to one sheet
    By David_Hiss in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-05-2013, 09:48 PM
  5. Copy/Paste Rows to Other Sheets, multiple conditions
    By financeguy57 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-17-2011, 01:39 PM
  6. Copy data in multiple sheets and paste into one sheet.
    By Slomaro2000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2008, 05:27 AM
  7. Copy paste WkBk/sheet 1 to multiple wkbks/sheets
    By wrpalmer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2005, 11:05 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