| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workbooks consoaldation
How do i merger the data from multiple workbooks into one giving totals for
specfic cells? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Workbooks consoaldation
='D:\[Reciepts.xls]Sheet1'!$C2
.....will return the value in the workbook Reciepts.xls from cell C2 of Sheet1, located in the D:\ directory. Vary the values to get what you need......... Vaya con Dios, Chuck, CABGx3 "jay" wrote: How do i merger the data from multiple workbooks into one giving totals for specfic cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Links auto update on some workbooks but not others | Excel Worksheet Functions | |||
| Consolidate different sheets to different workbooks | Excel Worksheet Functions | |||
| Workbooks...I'll try this again... | Excel Discussion (Misc queries) | |||
Linear Mode
