Consolidate multiple worksheets into new sheet
 

I would like to automatically copy data from 2 sheets into a new sheet. Row
4 will be the same in each sheet but the range may change.

Any suggestions?

Thanks
Angie

Consolidate multiple worksheets into new sheet
 

http://www.rondebruin.nl/tips.htm


look under the Copy/Paste/Merge examples


--
Regards,

Peo Sjoblom


"Angie" wrote in message
...
I would like to automatically copy data from 2 sheets into a new sheet.
Row
4 will be the same in each sheet but the range may change.

Any suggestions?

Thanks
Angie