Hi Melanie

Try this example with aexample workbook
http://www.rondebruin.nl/copy2.htm

--

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




"Melanie" wrote in message ...
I have 13 worksheets that I need to consolidate onto one sheet. I've tried
using codes from VB and they error out or give unwanted results.

I want to use consolidate from the data tools group. I've followed the steps
provided by help and even though the function appears to execute; no results
show. Can someone help me out?

--
Melanie