importing data from other worksheets within a different workbook

E

Eric Thompson

I am trying to track the progress of 50-60 people on a single worksheet.
What would be easier; giving each person their own workbook, or making one
workbook with 50-60 worksheets and one master worksheet? The problem is I
need the master worksheet to be updated as easily as possible. When a new
member joins the team, I don't want to have the master worksheet be told
where to go and look. Is there an option in Excel to have it locate all the
worksheets within all the workbooks in a given folder, and display the data
within certain cells, and arrange it on a master list?
 
F

Frank Kabel

Hi
I would go for a different application. Use for example a database
application which can be accessed via your network and not an Excel
workbook
 

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

Top