Results 1 to 6 of 6

[HELP] How to merge two identical sheets in one sheet (with formulas)? Without duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    02-04-2015
    Location
    Brasil
    MS-Off Ver
    2013
    Posts
    14

    [HELP] How to merge two identical sheets in one sheet (with formulas)? Without duplicates

    Hi guys,
    I have two different sheets that have the same layout, but come from two different sheets with completely different formulas. I´ve wanted to make a single data base so I could use in the pivot table, so I need to merge them, if possible avoiding possible duplicates.
    My problem is that they are dynamic every day each of them will have new data added in, and I´ve wanted to merge them both on a single sheet automatically.
    This problem is part of a huge sheet that I´ve wanted to work without any interaction, I cannot think of any way I would merge both, hopefully someone can help me with that.

    Here follows the Example Sheet:

    Thanks in Advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 09-04-2014, 05:08 AM
  2. [SOLVED] Merge many sheets into one, re-order cols, include sheet name on merged sheet rows
    By EXLwiz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-11-2014, 02:48 AM
  3. Add row in sheet with formulas and merge
    By DupkeVFR in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2013, 05:22 PM
  4. Replies: 3
    Last Post: 10-19-2011, 04:25 AM
  5. Pull data from identical sheets onto master sheet
    By veritas1 in forum Excel General
    Replies: 2
    Last Post: 08-18-2011, 05:45 AM
  6. Replies: 0
    Last Post: 03-10-2010, 01:25 PM
  7. compare 2 sheets and remove identical rows in sheet 2
    By VBisgreat in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2009, 04:41 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