Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating Excel sheets within Office Binder in Windows 2000
I want to (yearly) consolidate about 20 worksheets (from within workbooks)
that are saved in a binder. This is possible by entering one after another the Reference for each sheet in the Data Consolidation dialog box, but requires careful use of ' and [] and ! signs to separate the cell_range from the sheet name from the workbook name from the path. Is there an easier way to specify the Reference ranges? (Picking them from within the Binder would be perfect, but that doesn't work). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can u Import Macintosh 2.1 Excel file into Windows Office 2000? | Excel Discussion (Misc queries) | |||
office pacakge in windows 2000 NT | Excel Discussion (Misc queries) | |||
Excel Programs developed in Office 2000 on Windows 2000 | Excel Discussion (Misc queries) | |||
can i use office 2000 on windows XP and what is the pricing of 20. | Excel Discussion (Misc queries) | |||
Office 2000 and Windows XP | Excel Discussion (Misc queries) |