is it possible to open a dir on c drive which contains loads of work books of which each work book has 10 sheets on which 1 sheet contains the data i need to copy and then turn into a data base in a new book using a macro.
each book has an is named the same but has a diffrent number (eg returns number 33 and so on) and the sheet which contains the data is called 'return blank'
Bookmarks