communication between Excel files
 

I've created a logsheet for employees that calculates the hours and
pay. The supervisor would like to know if it's possible that her
spreadsheet would be able to load all the total pays of her
subordinates and show the result without copying and pasting.

Currently the total is located in one cell of the spreadsheet. I wonder
if I can create a macro that reads the number of one specific cell of
all the files in one folder and use the file names as the employee
names?

Thanks for any pointer,

cpliu

communication between Excel files
 

I think I'd just dedicate a worksheet in the supy's workbook that has formulas
that retrieve the value from each of the workbooks.

If the workbooks don't change location (or names), it would work ok.

I'd build the formulas by opening an employee's workbook
then select the cell with the value you want
edit|copy

Back to the supy's worksheet
edit|paste special|paste link

Close that employee's workbook and you'll see the formula now includes the path
to the workbook.

Repeat for the other employees.

cpliu wrote:

I've created a logsheet for employees that calculates the hours and
pay. The supervisor would like to know if it's possible that her
spreadsheet would be able to load all the total pays of her
subordinates and show the result without copying and pasting.

Currently the total is located in one cell of the spreadsheet. I wonder
if I can create a macro that reads the number of one specific cell of
all the files in one folder and use the file names as the employee
names?

Thanks for any pointer,

cpliu

--

Dave Peterson