Hello,
I'm sure this question has been answered in a million various forms but what I'm looking to do is pretty simple (based on other solutions I've seen for similar problems).
Here is the problem: I have 106 excel workbooks (each in the same format) that I need to combine as tabs into one master workbook. Each tab should be named whatever is in cell E2 of the associated workbook. I am using Excel 2007 but all workbooks are in 2003 format; not sure if this makes a difference or not.
Would someone be able to give me script that would do this?
I appreciate any help!!
Bookmarks