I suggest merging the sheets then removing duplicates

so set wb1 and wb2 to the two workbooks
loop through each sheet of wb2, copying the data to the same sheetname in
wb1

then for each sheet in wb1, delete duplicate rows

I'll do the code if you want, but first please answer these:

Q1: how many sheets in each workbook
Q2: do the sheets have identical names?
Q3: how many columns involved?
Q4: is there any single item on each row that can be used as a distinct
identity?




"Lynn" wrote in message
...
any help?

On Jul 25, 2:46 pm, Lynn wrote:
it shows the differences. but some issues to be fix to meet what i
want.

1. i need to be able to merge 2 xls workbook into 1. if there is data
in the same cell on both worksheets i will be prompted to select which
to overwrite
2. it needs to be able to compare all worksheets in the workbook, not
just sheet1

any idea?

On Jul 24, 10:36 pm, ryguy7272
wrote:



Many ways to 'skin the cat'. Try
this:http://www.softinterface.com/MD%5CDo...n-Software.htm

That is probably the most comprehensive and powerful...and free...
Let me know if you want to see some other solutions. Many ways to skin
this
cat.

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking
''Yes''.

"Lynn" wrote:
i have 2 identical excel files updated by 2 different people. How do
I
synchronise the data into 1 file?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -