Please help! I have 6 worksheets in a workbook, for 6 people who enters the projects and hours they spent on the projects on a daily basis. The data therefore keeps changing, lines are added/removed etc. How do I create a summary - off all 6 worksheets - on a separate worksheet indicating the names, projects and hours worked? Keeping in mind the following: two persons may have worked on the same project and it must be dynamic, so that it changes as the source data changes.
My problem is to combine the data from the six worksheets to get one set of source data for a pivot table. There must be a way of doing something like this?
Your help will be much appreciated!!
My problem is to combine the data from the six worksheets to get one set of source data for a pivot table. There must be a way of doing something like this?
Your help will be much appreciated!!