Dear microsoft.public.excel.programming,
I have about 50 files each with 30 sheets. Files are all similarly named
e.g. File112008-01, File122008-01 etc. and all sheets are named as dates
(e.g. first sheet is 11.01.2008, second is 11.02.2008 etc.), I'd like to
copy all E columns from all the sheets from all the files on one sheet,
column by column (after all place is taken, that it goes to another sheet).
How can I easily solve this? (I recently started to learn how to solve
easier problems with VBA but one this solution are some other problems I
have based, and I couldn't find myself how to solve it). I hope it's not too
much a newbish question in this group.
Thank you in advance