Hi..
I’m new to anything ells than basic excel, and don’t know how to program in excel.
I have the same type of data from different persons with different values (See attached file, the worksheets are called: Anne, Tine and Per).
I want to copy the results from: Projects/Activity, Type of project, Total [min], Person and Week for the different persons into a new worksheet (gathered data), and it should be able to update automatically if I make changes in any of the worksheets (called Anne, Tine and Per).
In the end I would like to make a pivot, So I am able to see how many minutes there is used on each type of projects or project/activity, where I can select a specific week and person (As shown on the worksheet called type of project (only with the data from Anne).
But the main question is how can I copy more cells from different worksheets into one worksheet that updates automatically?
I really hope some one know the answer and can help me
Kind regards
Marie
Bookmarks