loop through multiple spread sheets mejiasmarlon[ at ]gmail.com 10.07.2006 20:18:09 I have 6 years of data I would like to process. Each day is saved as its own spreadshhet. They are all saved in one folder; naming convention 08-01-00 to 07-0106. I would like to copy the same cell from each spreadsheet into a new spread sheet. Can some one point me in the right direction please.

Re: loop through multiple spread sheets "macropod" <invalid[ at ]invalid.invalid> 11.07.2006 01:11:29 It would be best to ask this sort of question in one of the Excel newsgroups (eg microsoft.public.excel.misc). Cheers -- macropod [MVP - Microsoft Word] <mejiasmarlon[ at ]gmail.com> wrote in message news:1152562689.502724.297920[ at ]p79g2000cwp.googlegroups.com... [Quoted Text] > I have 6 years of data I would like to process. Each day is saved as > its own spreadshhet. > They are all saved in one folder; naming convention 08-01-00 to > 07-0106. > > I would like to copy the same cell from each spreadsheet into a new > spread sheet. > > Can some one point me in the right direction please. >