View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default 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