View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Giles Giles is offline
external usenet poster
 
Posts: 11
Default 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.