Data Extract from Multiple Workbooks.

**realdealsxbl** · 12-04-2008, 10:28 PM

I am looking to create an overview workbook that sumarizes data from multiple workbooks. In each work book there is 6 worksheets Labelled Monday, Tuesday, Wednesday, Thursday, Friday and Summary. From each of these i need the information from cell F15 and F17 on Monday-Friday and Cell F16 on the summary worksheet.

All of the workbooks are entitled "week *" the * being whatever week it is from so currently i have 49 workbooks. I want to extract those cells data into an overview workbook.

I am not sure how to do this, i've been looking into it and I have found similar things by searching through google. I have no coding experience, and I am a self-taught excel user, and I have learnt a lot in the past year from any help is appreciated.

**davesexcel** · 12-04-2008, 10:35 PM

Check out this thread..
http://www.excelforum.com/excel-misc...worksheet.html

**realdealsxbl** · 12-04-2008, 10:57 PM

I took a quick look through that, I have no coding experience so how would it look like to change it to my needs. I'm a quick learner, I just have no knowledge of VBA coding, but once i get something its there for good.

i did this and it deleted my "sheet 3" that i had tried to put the macro in.

Please Login or Register  to view this content.

**davesexcel** · 12-04-2008, 11:13 PM

Please wrap your code,
If you are running the code from sheet 3 the range will be deleted, run the code from sheets Monday, it's is supposed to clear the range before it runs so you don't keep adding the same data to the bottom of it.

Data Extract from Multiple Workbooks.

LinkBack

Thread Tools

Rate This Thread

Display

Data Extract from Multiple Workbooks.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions