Moving data from mutiple workbooks to one
Well you can't move them.
but a copy, by simply having
='C:\My Documents\[Book5.xls]Sheet1'!$A$2
edt as required
Steve
On Mon, 01 Jan 2007 20:40:00 -0000, Mike C <Mike
wrote:
I have several workbooks that I need to pull data from and place it in
to a
single workbook. The data is identified by a logical cell, after it is
identified I need to move just 5 specific cells to the new workbook.
Each
workbook has a unique name and is stored in it's own folder on a network
drive.
Any help would be apperciated.
Thanks
|