| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking cells from workbooks in a folder
Hi all,
I am trying to create a sheet that will sum all the values from a given cell reference from each workbook contained in a particular folder, the workbook names in the folder change and the number of them varies as they are moved to another folder when finished with. The cell reference remains constant. any help would be greatly appreciated. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking cells from workbooks in a folder
See
http://www.rondebruin.nl/summary2.htm Or http://www.rondebruin.nl/copy3.htm The add-in is very easy -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Giles" wrote in message ... Hi all, I am trying to create a sheet that will sum all the values from a given cell reference from each workbook contained in a particular folder, the workbook names in the folder change and the number of them varies as they are moved to another folder when finished with. The cell reference remains constant. any help would be greatly appreciated. Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking cells from workbooks in a folder
Excellent !
I used your RDBMerge add in, very easy and exactly what I wanted. Thanks very much. May your helpfulness return to you multiplied. Giles. "Ron de Bruin" wrote: See http://www.rondebruin.nl/summary2.htm Or http://www.rondebruin.nl/copy3.htm The add-in is very easy -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Giles" wrote in message ... Hi all, I am trying to create a sheet that will sum all the values from a given cell reference from each workbook contained in a particular folder, the workbook names in the folder change and the number of them varies as they are moved to another folder when finished with. The cell reference remains constant. any help would be greatly appreciated. Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking cells from workbooks in a folder
You are welcome
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Giles" wrote in message ... Excellent ! I used your RDBMerge add in, very easy and exactly what I wanted. Thanks very much. May your helpfulness return to you multiplied. Giles. "Ron de Bruin" wrote: See http://www.rondebruin.nl/summary2.htm Or http://www.rondebruin.nl/copy3.htm The add-in is very easy -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Giles" wrote in message ... Hi all, I am trying to create a sheet that will sum all the values from a given cell reference from each workbook contained in a particular folder, the workbook names in the folder change and the number of them varies as they are moved to another folder when finished with. The cell reference remains constant. any help would be greatly appreciated. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking multiple cells between workbooks | Excel Worksheet Functions | |||
| Linking Merged Cells in Different Workbooks | Excel Discussion (Misc queries) | |||
| Linking snaps in a folder to cells | Excel Discussion (Misc queries) | |||
| Linking cells from different workbooks | Excel Discussion (Misc queries) | |||
| Linking cells to files in a folder | New Users to Excel | |||
Linear Mode
