Off-setting entries

[Yathish.d]

Hi,

Is there any shortcut or macro to find the off-setting entries.

Please find the attached file in which there are two instances, in the first tab i have the original data and in the second tab I have manually highlighted the off-setting values based on the Journal number. The second instance is where I have given the original values in the third tab and the off-setting in the fourth tab, here the base is Journal number and document number, only when both matches, the amounts has to be checked if they are off-setting.

Thanks,
Yathish

[JieJenn]

Try and apply the same concept to Original 1 worksheet

Please Login or Register  to view this content.

[Yathish.d]

Thanks for your help.

This is working fine for tab "Original" but not for tab "Original 1" where there are two criteria to be matched.

[JieJenn]

I said try and apply the same concept to original 1 worksheet. I am not here to do your work for you.

[Yathish.d]

I doesn't know much about programming and coding, I doesn't know how to edit the code to suit my need. Anyways thanks for your help with the first one.

Can any one help me to perform the same task if there are two different criteria's.

Thanks in advance.