+ Reply to Thread
Results 1 to 2 of 2

Excel 2013 - Appending one sheet to another without cutting and pasting

  1. #1
    Registered User
    Join Date
    08-26-2014
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    1

    Cool Excel 2013 - Appending one sheet to another without cutting and pasting

    Hello - I am looking for a quick way of copying data from one sheet and adding it to another sheet in the same workbook. This data has the same field headings on each sheet (I have about 25 sheets) but different number of rows in each - I would like to consolidate into one sheet without taking the headings. I am sure there must be a quicker or smarter way then using copy and paste?
    Attached Images Attached Images
    Last edited by TomCruise; 08-26-2014 at 11:51 AM. Reason: Would like to add a picture please

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Excel 2013 - Appending one sheet to another without cutting and pasting

    Hi TomCruise,
    Welcome to the Forum.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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. cutting and pasting row in other sheet if cell is empty
    By flunzy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-02-2014, 09:42 AM
  2. Replies: 0
    Last Post: 08-28-2013, 06:45 AM
  3. Cutting row and pasting into new sheet based on criteria
    By goose1000 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-18-2011, 11:54 PM
  4. Cutting/Pasting Data From One Sheet To Another
    By MCatz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2010, 12:23 PM
  5. Replies: 7
    Last Post: 02-14-2006, 03:10 PM

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