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.
Bookmarks