ExcelBanter - Workbooks consoaldation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Workbooks consoaldation (https://www.excelbanter.com/excel-worksheet-functions/124901-workbooks-consoaldation.html)

Jay

Workbooks consoaldation

How do i merger the data from multiple workbooks into one giving totals for
specfic cells?

CLR

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?

All times are GMT +1. The time now is 01:31 AM.