Consolidating many workbooks into one
Posted by Susan on February 02, 2002 9:07 AM
I hope someone can help. I am trying to write a macro that will accumulate or consolidate all open workbooks into one. It would be like using the "move or copy sheet" function but would combine all sheets of all open (AND UNHIDDEN-i.e.not personal.xls running in background) workbooks at the same time. Ideally, I am thinking copy all open sheets to a new workbook-but I will work with any ideas!!
Thanks in advance!