I would start at Ron de Bruin's site:
http://www.rondebruin.nl/tips.htm
Look for: Copy/Paste/Merge examples

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

If you're going to run this on demand, I would just open that workbook and
invoke the macro. But you could name your macro Auto_Open and it'll run each
time the workbook opens. You can use a scheduling program to open it when you
want.

Kevin wrote:

Hi

I want to write a macro to take information from approx 3/4 spreadsheets and
input into one other. I also want to schedule this as a task to run
daily/weekly.

Any help out there??

Cheers
--
Kevin Donnelly

--

Dave Peterson