Question, is it better to open mulitple workbooks or have one workboo
with multiple worksheets. I will be doing a lot of computation wit
these files/sheets in VBA, and I was wondering which would be mor
efficient.

If "multiple worksheets" is the answer, then how do I get the info fro
the other workbooks to the multiple-sheet workbook? The only way I ca
think of is writing a macro to copy and paste the info onto a ne
worksheet. Is that the only way?

I hope I am making sense.

Joh

--
Message posted from http://www.ExcelForum.com