W
Walter Steadman
Greetings all,
I have a folder called 'Employees' and in the folder I have 4
spreadsheets, all with the same structure on sheet1. The spreadsheets are
called bobpay.xls, tompay.xls, stevepay.xls, and tammypay.xls
I have two questions:
1. I have created another spreadsheet and I want it to do a sum of the the
like fields in each spreadsheet. Is there a way to have it calculate
sheet1!A1 of all spreadsheets in a folder?
2. Really just a subset of question 1. If I add a new file to the folder
called Fredpay.xls, can it automatically pick that one up as well and do the
calculations?
TIA
I have a folder called 'Employees' and in the folder I have 4
spreadsheets, all with the same structure on sheet1. The spreadsheets are
called bobpay.xls, tompay.xls, stevepay.xls, and tammypay.xls
I have two questions:
1. I have created another spreadsheet and I want it to do a sum of the the
like fields in each spreadsheet. Is there a way to have it calculate
sheet1!A1 of all spreadsheets in a folder?
2. Really just a subset of question 1. If I add a new file to the folder
called Fredpay.xls, can it automatically pick that one up as well and do the
calculations?
TIA