Hi there all,
I have this macro to create a time sheet from a template for each member of staff, what I need it to do after it is created is populate the time sheet from a list of projects in a separate worksheet:
I tried this, but it doesn't work 
Can anybody help pleeeeeeeeeease?
EDIT: OK, it seems to be something to do with the counting the number of Staff/Projects that's buggering it up.... the Staff members start in A4 of the Staff sheet, so I am trying to count the non-blank cells after that.
Bookmarks