Results 1 to 44 of 44

Merge multiple sheets data into 1 sheet based on multiple criteria (List Based)

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    906

    Merge multiple sheets data into 1 sheet based on multiple criteria (List Based)

    Hello,

    I am looking for a help to combine 2 worksheet data for non-identical headers.

    Now the macros will do the following:-

    1. Look for a Code from worksheets list (Column A) into worksheets data in column D
    2. Look for a Status from worksheets list (Column C) into worksheets data in column F
    3. And look for a Dates from worksheet list (Start date column D & End date in column E) into worksheets data column C.

    If the entire criteria match within the specified dates then copy specific columns (Excluding Column F, I, J, K & R) from worksheets data and past to worksheets statement. After copy the data then look for the below match.

    From worksheets list look for the provider name into worksheets Resubmission Adjustment into column F and look for the batch no in column B which is present in worksheets “Data” in column G and worksheets “Resubmission Adjustment” in column D cell value is Resubmission Adjustment the copy those rows only.

    Summary (Short Explanation)
    Looking for Al Dar Hospital (Quba) for settle batch from Jan 2015 untill Dec 2015 from Worksheets “Data” then copy data to Worksheets “Settlement”
    Look for Al Dar Hospital (Quba) for same batch based on batch no for the Resubmission Adjustment in worksheets “Resubmission Adjustment” then copy data to worksheets “Settlement”

    Copy of the sample file is attached for your reference with the output.
    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. [SOLVED] Merge multiple sheets data into one worksheet based on multiple criteria and date
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 02-03-2018, 04:19 AM
  2. [SOLVED] Need macro to copy data from 1 sheet to multiple sheets based on certain criteria
    By JudyF in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 11-08-2017, 10:34 AM
  3. [SOLVED] Merge multiple sheets data into one worksheet based on multiple criteria
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-05-2016, 10:32 AM
  4. list data on summary sheet from multiple sheets, based on parameters
    By tillyman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2015, 10:06 AM
  5. Simultaneously sorting data in ranges on multiple sheets based on criteria on one sheet
    By Chris Greensmith in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-10-2015, 06:40 AM
  6. [SOLVED] VBA Code to copy different data from one sheet to multiple sheets based on criteria
    By eharwood in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-08-2014, 02:22 PM
  7. Replies: 0
    Last Post: 02-28-2013, 07:28 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