Intercompany Reconciliation

**sibyxa** · 08-27-2009, 09:35 AM

Anybody can help me to reconcile two data sets (matching).

I have attached a spreadsheet with samples and requirements.

Hope you will understand

Thanks

**royUK** · 08-27-2009, 09:39 AM

very brief, the Thread Title isn't very helpful either!! Can you ask a question in the body of the post, don't expect members to simply download your attachment - not everyone can!

**ravishankar** · 08-28-2009, 12:32 AM

Hi
I could not follow the logic.try the macro.
Ravi

**sibyxa** · 08-28-2009, 03:34 AM

Morning Ravi

Thank you

Second part of your macro is not working

Xco working fine but nothing hpnd in Yco sheet

Can you please look at it

**royUK** · 08-28-2009, 03:57 AM

I cn't see how you can reconcile these figures. There is no matching document number and you cannot reconcile on the strength of matching values, you have two amounts of 879.00 and you are likely to have other duplicate values. You need a unique reference number that applies to the document on each sheet.

**sibyxa** · 08-28-2009, 04:25 AM

Opzz ....I didn't notice before

Is it possible to avoid duplicate amounts frm matching because there is no matching document number in my data sheet, amount is the only option I do

Thanks