Reconciling data from two sheets

[francisdias69]

I need to reconcile Invoice sheet with the download sheet.
- All the 4 fields should match, Nominal, Trade date, Currency and Amount.
- All the matched data should be copied in Matched sheet, data should tell you whether its from invoice or download sheet.
- Unmatched data only from invoice should be highlighted in Unmatched sheet.

Please note that the data is very huge in the download sheet, some 60k data in Download sheet.

Please,Please,Please,Please,Please,Please some help me

[teylyn]

francisdias69,

do not, I repeat: not, report a post just because you have not received any replies to your question.

Your description of the issue is very vague. Nobody is able to figure out what you want as a result.

Manually mock up some data that you want to see as the result and then explain the rules that lead to those results.

If you still don't get a response, consider that your explanations are not sufficient for the experienced helpers here to understand. Explain your problem better.

[royUK]

Thanks Teylyn

francisdias69,

Read the Forum Rules
Check that your explanation is clear
Read the Forum Rules

[francisdias69]

Here comes the explanation.. hope this should help....
I need to reconcile two sets of data which is in the same file:-
- It should pick up the data(i.e. Nominal, Trade date, Currency and Amount) from 2nd row till the end of the data from the "invoice sheet" and match with the same fields from "download sheet"(i.e. Nominal, Trade date, Currency and Amount).

If all the 4 fields from "Invoice sheet" matches with all the 4 fields from the "download sheet", it should copy the entire row from "Invoice sheet" and also copy the entire row from "download sheet" and paste it in the "Matched sheet" one below the other.
There should be a field where it should reflect the source data (as seen in the sample file)

All the unmatched data, only from the "Invoice sheet" should be copy pasted in the "Unmatched sheet"

At times there are 60K rows in download sheet due to which the task becomes much more difficult....
Appreciate if someone can please help me out...

[francisdias69]

Hi...

Missed out on reading the forum rules......
Can someone please help me with the macro codes......
I am working on a project and this macro will really help me......

Let me know if i am not clear with the explanation....

Regards,
Francis

[JieJenn]

My Suggestion is use concatenate then do a vlookup as the file attached.

[francisdias69]

My Suggestion is use concatenate then do a vlookup as the file attached.

Thanks for the suggestion of CONCATENATE... it really worked and I created a macro based on combination of Vlookup and CONCATENATE.

I have a problem... a slight modification with the output that i want.
With reference to the attached sheet, I have to match the Amount from "Invoice sheet" with any of the amount in "Download sheet", the combination of Vlookup and CONCATENATE is not working here.

Request, someone to please help as I am running a project and I am stuck with the problem. We have a deadline to meet.
Appreciate all the efforts.

Regards,
Francis

[francisdias69]

Thanks for the suggestion of CONCATENATE... it really worked and I created a macro based on combination of Vlookup and CONCATENATE.

I have a problem... a slight modification with the output that i want.
With reference to the attached sheet, I have to match the Amount from "Invoice sheet" with any of the amount in "Download sheet", the combination of Vlookup and CONCATENATE is not working here.

Request, someone to please help as I am running a project and I am stuck with the problem. We have a deadline to meet.
Appreciate all the efforts.

Regards,
Francis