See Ron de Bruin's site for code assistance.

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

Browse through the section on Copy/Paste/Merge examples


Gord Dibben MS Excel MVP

On Thu, 10 Jan 2008 22:15:21 -0800, Bill Needham
wrote:

I have created a workbook and save it as a differant file name each time. How
do I collect data from multiple those workbooks and collect it in a sumary
workbook? The sumarry workbook will be the running total for the year. I've
been typing formula strings and am getting no where. HELP : (