merge, compare and update spreadsheets

[Diane]

Hi All

does anybody know of a way to combine several different
workbooks, compare the data and update the master with
changes?

We are sending out 150 books to team leaders, we want them
to update their team details and then send it bak to us.
We then want to merge all the sheets into one book with
the amendments. Is it possible to do and if so, can we do
it without using VBA?

I hope that somebody can help

Thanks in advance

Diane

 

[Frank Kabel]

Hi
you may have a look at
http://www.rondebruin.nl/copy3.htm