Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking many workbooks
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking many workbooks
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. " wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking many workbooks
Maybe you like this add-in
http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking many workbooks
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 - Thanks for the responses Joel and Ron. That helped alot. It is up and running. Thanks again. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking many workbooks
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking many workbooks
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 wrote in message ... 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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking many workbooks
On Sep 13, 7:41*am, "Ron de Bruin" wrote:
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 Bruinhttp://www.rondebruin.nl/tips.htm wrote in ... 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.- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Workbooks | Excel Discussion (Misc queries) | |||
Linking Workbooks | Excel Discussion (Misc queries) | |||
LInking workbooks | Excel Worksheet Functions | |||
linking workbooks | New Users to Excel | |||
Linking several workbooks | Excel Discussion (Misc queries) |