getting data from cells in wrksheet & importing in existing works
Here is the application...I have a master worksheet that needs to pull
information from specific sells in several different files (excel worksheets) in defferent directories. The filenames will change but the fields will be the same. I have been using manual links and cut&paste to place the information in the master worksheet. Is there a way to define a directory path and filename is some cell within the master worksheet to use as a reference for the linked cell to look so that it will automatically retrieve the information without manual intervention? |
hi,
=('C:\WOMonitor\FY03\[Jan.xls]MPX'!$A$4) here is one i use to create a summery sheet from 12 monthly files. you can use =sum and =count too. =SUM(COUNTA('C:\WOMonitor\FY03\[Jan.xls]MPX'!$Z$4:$Z$500)- COUNTA('C:\WOMonitor\FY03\[Jan.xls]MPX'!$AC$4:$AC$500)) -----Original Message----- Here is the application...I have a master worksheet that needs to pull information from specific sells in several different files (excel worksheets) in defferent directories. The filenames will change but the fields will be the same. I have been using manual links and cut&paste to place the information in the master worksheet. Is there a way to define a directory path and filename is some cell within the master worksheet to use as a reference for the linked cell to look so that it will automatically retrieve the information without manual intervention? . |
All times are GMT +1. The time now is 01:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com