+ Reply to Thread
Results 1 to 2 of 2

Merge Only Visible Worksheets

  1. #1
    Registered User
    Join Date
    03-20-2017
    Location
    South Dakota
    MS-Off Ver
    2016
    Posts
    1

    Merge Only Visible Worksheets

    I am working with Excel 2016. I have a Workbook that contains a Main worksheet (where I am consolidating the data in a "pretty" format), an ERP New worksheet, an ERP Active worksheet, a 'hidden' Sheet1 worksheet (contains outside ODBC links), and a Master Worksheet that is created with my code. I found this code on this site and would like to customize it so it will only copy the visible worksheets. I want the data starting on row 5 to be copied into the Master worksheet from both the ERP New and the ERP Active worksheets. They both have the same headers, but have different numbers of rows. I want all data from A5:T5 until there is a blank row. I do not want the data from Sheet1 to be merged.

    Any help would be greatly appreciated!! Thank you!


    Please Login or Register  to view this content.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Merge Only Visible Worksheets

    Maybe:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. VBA to insert and merge cells until all text in column is visible
    By teaker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2016, 02:13 PM
  2. [SOLVED] All worksheets are not visible. Can't make them visible.
    By verdugan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-21-2012, 01:19 PM
  3. Replies: 1
    Last Post: 09-10-2012, 06:11 AM
  4. Worksheets not visible
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-16-2012, 07:15 AM
  5. Merge 2 Worksheets (Same concept as RegEdit Merge or Outlook Vcard)
    By stevedes7 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-20-2009, 11:17 PM
  6. [SOLVED] Worksheets not visible in Excel XP
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-30-2005, 05:06 PM
  7. [SOLVED] Visible WorkSheets
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-24-2005, 06:07 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