isotopes
08-08-2011, 09:23 AM
Hello all,
My organization is looking to build a database in excel(2007) that allows for detailed information to be stored for each sub-business on worksheets within separate large business workbooks. (Variable number of worksheets in 19 total workbooks stored on a shared drive.) The first worksheet of each workbook is a summary of that particular business lines key information. There will never be more than the current number of workbooks, though more worksheets may be added.
I need to come up with a way to consolidate the summary pages and have them update if new information is added or old information is changed. I also have to come up with a way to get all the information store on the worksheets into one large data pool.
I have a very limited knowledge of VBA and would greatly appreciate any and all help.
Thanks!
Jeff
*Attached is an example of the workbook - summary worksheet and detailed worksheet*
My organization is looking to build a database in excel(2007) that allows for detailed information to be stored for each sub-business on worksheets within separate large business workbooks. (Variable number of worksheets in 19 total workbooks stored on a shared drive.) The first worksheet of each workbook is a summary of that particular business lines key information. There will never be more than the current number of workbooks, though more worksheets may be added.
I need to come up with a way to consolidate the summary pages and have them update if new information is added or old information is changed. I also have to come up with a way to get all the information store on the worksheets into one large data pool.
I have a very limited knowledge of VBA and would greatly appreciate any and all help.
Thanks!
Jeff
*Attached is an example of the workbook - summary worksheet and detailed worksheet*