On Sep 12, 12:43*pm, "Ron de Bruin" wrote:
Maybe you like this add-inhttp://www.rondebruin.nl/merge.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



wrote in ...
I know how to link specific items from one workbook to another.

I needed information on how to transfer data between many workbooks.

I will have over 40 workbooks and I will need to consolidate all the
information into one central workbook which only I can access. All the
workbooks are password protected. there will be between 5-8 columns in
each workbook and also in the central workbook. now I dont know how
many rows will be in each workbook. If i select for example 100 rows
from workbook1 and input them into line 1 of the central workbook, and
select 100 rows from workbook2 and input them into line 2 of the
central workbook will it overwrite the lines from workbook1?

is there a way to have all the values consolidate from all 40
workbooks into 1 central workbook without losing/overwriting data?

Thanks in advance.- Hide quoted text -

- Show quoted text -

Hey Ron

I was using the add in that you suggested. I had one question for
you.
If I have for example 40 workbooks and I need to consolidate into 1 I
understand how to do that using your add in. But if each workbook has
a different password how do I enter in 40 different passwords into
just the 2 fields? Or would I have to Link each workbook individually?

Thanks for your help Ron.