Multiple Workbooks

  • Thread starter Thread starter Walter Steadman
  • Start date Start date
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
 
Sorry about this posting here. Clicked wrong news group, was meant for
Excel.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel shortcut options 0
Alt codes 4
Excel Import Comments 3
Different Number of Workbooks each week 2
Cell shows the last typed text, no matter where it is typed 0
Excel Excel Formula - IF Function with percentages 1
Scrabble Value calculation for Welsh words 0
Lookups - how to obtain data from a master spreadsheet into another 5

Back
Top