No video but,

You can use this add-in
http://www.rondebruin.nl/merge.htm

Or use code
http://www.rondebruin.nl/copy3.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jake" wrote in message ...
Hi,
Im looking for a video or visual guide that shows me how to use the
consolidate button. I read the Microsoft help for this but honestly I
couldnt understand it. That is why Im looking out for a video or screenshot
help.
For your reference I have a file where I need 10 different contacts to
provide me some data. I have sent the file (exactly the same file) and now I
need to put that in just one single file (worksheet).

Thank you in advance