+ Reply to Thread
Results 1 to 8 of 8

Need cut and paste data from multiple sheets to one master sheet

  1. #1
    Registered User
    Join Date
    01-04-2013
    Location
    dayton ohio
    MS-Off Ver
    Excel 2010
    Posts
    34

    Question Need cut and paste data from multiple sheets to one master sheet

    Data on sheet 1, sheet 2, sheet 3 are in the same format and layout. Need to copy data from these three sheets to one master sheet(sheet 4). How am I supposed to find last row of the master sheet and paste data to last row+1? Also after this first step is finished, delete all data on sheet 1 to sheet 3. Thanks.

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

    Re: Need cut and paste data from multiple sheets to one master sheet

    There are many unknowns on your request; it would be easier if you could attach your sample workbook. Please go to advance-half way the page, you see an attachment icon, or button.

  3. #3
    Registered User
    Join Date
    01-04-2013
    Location
    dayton ohio
    MS-Off Ver
    Excel 2010
    Posts
    34

    Question Re: Need cut and paste data from multiple sheets to one master sheet

    I need to cut and paste from row 2 to last row that has data in each worksheet (sheet 1 to sheet 3) to the master worksheet.
    Thanks.
    Attached Files Attached Files

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

    Re: Need cut and paste data from multiple sheets to one master sheet

    Please Login or Register  to view this content.
    Last edited by AB33; 01-06-2013 at 06:45 PM.

  5. #5
    Registered User
    Join Date
    01-04-2013
    Location
    dayton ohio
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Need cut and paste data from multiple sheets to one master sheet

    Thank you. Here is another scenario. I want to cut and paste data on the first three tabs only to the master worksheet. But I only want to copy the rows that have a value in column A. The next procedure is after the data are pasted, this time delete the value from range E2:H5 only. Again, thanks for your help.
    Attached Files Attached Files

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

    Re: Need cut and paste data from multiple sheets to one master sheet

    "But I only want to copy the rows that have a value in column A". Is it column A values ONLY you wish to copy, not columns B, C as you have header for these columns in master?

  7. #7
    Registered User
    Join Date
    01-04-2013
    Location
    dayton ohio
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Need cut and paste data from multiple sheets to one master sheet

    Sorry about the confusion. Copy these rows that have a value in column A,do not copy rows that are either blank or "-" in column A.

  8. #8
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Need cut and paste data from multiple sheets to one master sheet

    It is not clear to me what your requirements are, but try this one and can be improved

    Please Login or Register  to view this content.
    Last edited by AB33; 01-07-2013 at 06:07 AM.

+ 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