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?
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?