• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extracting and combining data from specific sheet from multiple workbooks

A

aggies2010

New Member
I have searched and found similar answers, but haven't been able to get a code that works for my situation. I have multiple workbooks all containing several sheets, but only need certain data from one specific sheet in every workbook compiled into one sheet. All of the sheets containing the data are named the same (Unit Availability) as well as the cell location of the data.


Here are links to a sample workbook and sample output so you can see what I am trying to accomplish.


http://db.tt/4zE5Eo4c

http://db.tt/KUu8V9LB


I want to have all the files in one folder when I go to run whatever macro is created, so I don't have to enter all the workbooks names separately.


I think this is the closest I have come to what I am looking for:

http://stackoverflow.com/questions/11824939/extracting-data-from-multiple-sheeted-excel-workbooks-into-one-single-sheeted-wo

https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/merge-functions/consolidate-wbs-to-one-sheet


Thank you in advance for your help!
 
Check out Ron's add-in here:

http://www.rondebruin.nl/merge.htm


Looks to be pretty user friendly and should do what you need. If not, Ron has several other articles in the Copy/Paste/Merge section here that might do the trick:

http://www.rondebruin.nl/tips.htm
 
@Abhijeet
Hi!
I usually write "Would you please start a new topic instead of writing on another user's one? It might be seen as hijacking. More indeed when it's such and old topic. If needed you could add a reference in your new one.".
But as you've yet done that, please keep on all the comments and questions in the same thread and don't cross post.
Perhaps you'd want to read the red sticky posts at this forums main page so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on).
Regards!
PS: Please don't answer here at this thread.
 
You must log in or register to reply here.
Back
Top