Hi there,
I've recently compiled a 'workload' sheet at work which is laid out with dates along the top row (actually row No. 6) and employee names down left column (actually column C). Currently I have a userform set up to run when a cell within the grid is double clicked so that the form pops up and there are 3 entry boxes for site reference, job number and hours worked. The way it is set up at the moment is that for every individual cell, data must be entered which is obviously very time consuming especially when a single job spans several weeks and it applies to several members of staff.
The way I want the setup to work is that the userform has start date and finish date entry boxes and for the code to automatically fill in the information entered in the other entry boxes into the cells on that row that correspond to the dates on row 6. Is there a way this can be done and if so does anybody have any code?
Please feel free to ask if there is more information you need to answer.
Many thanks in advance.
Bookmarks