Forum

Thanks Philip the advice. The point is I want to keep the macro module in the Excel file for some one use; but if in xlsx format, macro module ...

Cells at random in each worksheet. Anyway I master the tips you so kind share, Velouria, and the small VB tools should work fine..

Thanks, understand. Macro work on selected cells. I need to modiy if work on others cells.

Kindly review the Macro module per attach to see if any things goes wrong, now doesn't work at all..

Tied but the macro doesn't work pls refer attached sample.

Thanks Velourla , will have a go on that...

It works perfectly, thank Sunny! With Sunny Excel works always become sunny..

Thanks Sunny will have a go on that..

THANKS MILLIONS SUNNY WILL GIVE A TRY ..

Thanks Sunny so sorry for the messy data. But what i really want is to use a macro to joint the Tables data together base on common field PO # and I...

Pls refer attached again!

I want to compare Two Tables data base on PO and Item No. [ both fields exist in two tables] to find out the discrepancy between two System record fo...