linking many workbooks


M

mulji.hafeez

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.
 
Ad

Advertisements

J

Joel

The best wsay is with a macro. The macro can open each of the workbooks,
extract data and put them into a new workbook without overwriting any data.
the best way to set it up is to put all the workbooks in one folder and then
just open up each file in the folder. You also want to put the filename
(workbook name) in a new column so you know where each piece of data came
from.
 
M

mulji.hafeez

Maybe you like this add-inhttp://www.rondebruin.nl/merge.htm

--

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









- 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.
 
R

Ron de Bruin

40 different passwords

You make it not easy for yourself

The only way is to make a table with workbook name and password
and loop through the list.
Is that a option for you ?


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Maybe you like this add-inhttp://www.rondebruin.nl/merge.htm

--

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









- 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.
 
Ad

Advertisements

M

mulji.hafeez

You make it not easy for yourself

The only way is to make a table with workbook name and password
and loop through the list.
Is that a option for you ?

--

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






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.- Hide quoted text -

- Show quoted text -

Well the reason I need 40 different passwords is because each workbook
is dedicated to one team. I need to have an overall scope of what's
going on but they should not be able to open each others files to
modify. Therefore the 40 different passwords are necessary.

I will try what you have suggested and hope for the best.

Thanks Ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top