Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using data from multiple workbooks to generate a report
How can I automate collecting information from 30+ workbooks that all have
the same format (i.e. Cell B25 in all workbooks has the same type of information) and generating a report or another spreadsheet from the collected information. For example, all of my workbooks contain information about equipment at 30 different locations. I would like to query all of the workbooks and get a list of what is contained in Excel Cell B25. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using data from multiple workbooks to generate a report
Do the workbooks have a names that look like a series?
Like: Jan , Feb, Apr... Or: Book1, Book2, .... best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Dave Young" <Dave wrote in message ... How can I automate collecting information from 30+ workbooks that all have the same format (i.e. Cell B25 in all workbooks has the same type of information) and generating a report or another spreadsheet from the collected information. For example, all of my workbooks contain information about equipment at 30 different locations. I would like to query all of the workbooks and get a list of what is contained in Excel Cell B25. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using data from multiple workbooks to generate a report
No, the workbooks have names of the places where the equipment is located.
"Bernard Liengme" wrote: Do the workbooks have a names that look like a series? Like: Jan , Feb, Apr... Or: Book1, Book2, .... best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Dave Young" <Dave wrote in message ... How can I automate collecting information from 30+ workbooks that all have the same format (i.e. Cell B25 in all workbooks has the same type of information) and generating a report or another spreadsheet from the collected information. For example, all of my workbooks contain information about equipment at 30 different locations. I would like to query all of the workbooks and get a list of what is contained in Excel Cell B25. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using data from multiple workbooks to generate a report
Make a list of these names (the names of worksheets) in a range such as
A1:A30 Then use the INDIRECT function in the form =INDIRECT("'["&A1&".xls]Sheet1'!$B$25") This works only when the other file is open. However, Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ includes =indirect.ext() that allows you to return values from closed workbooks. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Dave Young" wrote in message ... No, the workbooks have names of the places where the equipment is located. "Bernard Liengme" wrote: Do the workbooks have a names that look like a series? Like: Jan , Feb, Apr... Or: Book1, Book2, .... best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Dave Young" <Dave wrote in message ... How can I automate collecting information from 30+ workbooks that all have the same format (i.e. Cell B25 in all workbooks has the same type of information) and generating a report or another spreadsheet from the collected information. For example, all of my workbooks contain information about equipment at 30 different locations. I would like to query all of the workbooks and get a list of what is contained in Excel Cell B25. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
generate report from date and obtaining all data in row | Excel Discussion (Misc queries) | |||
Compile report from multiple workbooks | Excel Discussion (Misc queries) | |||
Can I generate a report for my classroom? (I APPRECIATE YOUR HELP | Excel Worksheet Functions | |||
Generate Report | Excel Worksheet Functions | |||
How to generate a report from multiple lists in Excel 2003? | Excel Discussion (Misc queries) |