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.

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.

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.

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.