+ Reply to Thread
Results 1 to 4 of 4

Trying to copy multiple worksheets into one single worksheet

  1. #1
    Registered User
    Join Date
    10-13-2003
    Posts
    27

    Trying to copy multiple worksheets into one single worksheet

    Good Morning,
    I have a file with 50+ worksheets, and I am trying to select all sheets, and copy them into one single worksheet. Is that possible? Thanks much.

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Trying to copy multiple worksheets into one single worksheet

    I'm assuming each sheet has identical layout, perhaps varying in # of rows.
    1) What columns are being copied?
    2) What row does data start in? (I assume you don't want to re-copy headers, if any.)
    3) Is there any column that ALWAYS has data from top to bottom, with no blanks? (We can use that to find last row.)

  3. #3
    Registered User
    Join Date
    10-13-2003
    Posts
    27

    Re: Trying to copy multiple worksheets into one single worksheet

    Thank you for your response. I had to go in another direction, but appreciate your help!

  4. #4
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Trying to copy multiple worksheets into one single worksheet

    Perhaps you could share your solution so others could learn from it.
    In any event, you "OWN" this thread, so if you're done with it, please go to Thread Tools up top and mark it as SOLVED. Thanks-Lee

+ 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. Copy Data from multiple worksheets & append to single worksheet
    By Rubicon9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2016, 04:46 PM
  2. [SOLVED] Copy column data from multiple worksheets to single worksheet based on header criteria
    By nateaskins in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-21-2014, 10:42 AM
  3. Macro to copy tables from specific worksheets into a single worksheet.
    By roshanvmech in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-12-2013, 09:07 AM
  4. Copy multiple lists from multiple worksheets into single worksheet
    By gowtham_pec in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2013, 04:44 AM
  5. Copying multiple rows from multiple worksheets to a single worksheet
    By Malkave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2012, 06:35 AM
  6. Append multiple worksheets into single worksheet
    By steve-waters in forum Excel General
    Replies: 1
    Last Post: 01-02-2008, 06:11 AM
  7. [SOLVED] Need to have multiple worksheets use a single worksheet
    By storm5527 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2005, 07:06 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