How can I consolidate selected tabs from multiple workbooks into a single workbook?
There are about 10-12 workbooks in various network drives which get updated at a given point in time on Mondays. I would like to:
1) Selectively import values only versions of tabs into a single "master" workbook.
2) Have the system be portable enough so that when a new tab is added or deleted, I do not have to touch the actual code.
Is there an easy way to do this? Help is greatly apprecicated. :)
Re: How can I consolidate selected tabs from multiple workbooks into a single workbook?
Moved to Office Development
Re: How can I consolidate selected tabs from multiple workbooks into a single workbook?
Quote:
Originally Posted by kartickn
1) Selectively import values only versions of tabs into a single "master" workbook.
Could you explain a little more or give an example? I don't understand how you are going to determine which worksheets to copy.
