You can start here Sam
http://www.rondebruin.nl/copy3.htm

--

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


wrote in message oups.com...
Hello,
I am trying to look for some pointers to get me started with
macros in Excel. I have been assigned to create a macro which would
consolidate and pivot data from the excel files(particular worksheet)
present in a directory into a new excel file. I do apologize for
asking a vague question but that is all I got.

Thanks,
Sam.