Time report for projects.

[KBergmar]

Hi all,

Hope you can help me out with this issue.

I want to create a time report where the employee make input of its "Name", "Week", "Project" and "Hours" spended in one sheet. Then, after pressing the "Registrera tid" button all other sheets should be updated.

So here is what I want to do with the sheet Iīm attaching.

1. An employee makes input of itīs "Week", "Name", "Project", "Hours" in the sheet "Blad 1".
2. Pressing the "Registrera tid" button.
3. First the VBA should find the correct name of the "Project" from sheet "Blad 1" in the sheet "Project". I think this function works now by a Application.WorksheetFunction.VLookup. But please change if you want.
4. When the correct name of the "Project" is found in the sheet "Project" this should be the sheet where we want to make input of the "Hours". For example the employee can choose project P195C in the sheet "Blad 1", while the specific project sheet has the name "P195".
5. When for instance P195 is found ,10 Hours should be put into correct cell based on the "Name" and the "Week".
6. Finish.

Hope you understand my issue. Really thankful for your help!

/Kristofer

[DBY]

Hello Kristofer welcome to the forum.

Here is some code which seems to work ok on your sample file:

Please Login or Register  to view this content.

However, this has no Error Handling, so you would need to tighten up the validation on the input cells or introduce some Error Handling Code. Not sure which approach would be suitable for you. You would need checks for the 'Name'; 'Week'; 'Sheet' and perhaps 'Hours' for a numeric input.

DBY

[KBergmar]

Thanks a lot DBY!

It works now. Really appriciate your help, great forum!

Best Regards
Kristofer