Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summary from unopened workbooks
Hi
I have 20 workbooks, all the same, with one summary sheet in each named "Summary" . The "summary" sheet is the first sheet in each workbook What i require is one new workbook, that adds all those summaries together File for all those workbooks is J / Distribution KPI / "then the appropriate workbook name" Range in the "summary" sheet is A1:N44, (this range does include header row and there are a few blank rows used to break-up the data (formating) I have limited macro knowledge, but i can copy/paste or tweek if not too complicated Hope this makes sense Any suggestions Excel 2002 Regards Brian -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summary of data from several workbooks in another | Excel Discussion (Misc queries) | |||
Summary Worksheet from Multiple Workbooks | Excel Worksheet Functions | |||
Multiple Workbooks Summary | Excel Worksheet Functions | |||
Creating multiple workbooks from summary workbook | Excel Discussion (Misc queries) | |||
Functions referencing unopened workbooks | Excel Worksheet Functions |