cweggleto81
New Member
- Joined
- Jan 11, 2018
- Messages
- 21
Hi all,
I am making a spreadsheet for work which consists of several Cells containing text relating to job that have to be accomplished during a night's work. I have these all listed down the sheet from B4 down. I want to colour these depending on the time the job needs to be completed by which is not an issue. What I am looking to do is make 4 more columns with peoples names e.g. John, Bill, Peter and Bob and then be able to click and drag the cell with the job I want to allocate to them underneath there name and have it move out of the list of jobs and re position under there name. Basically dragging jobs to people from the list until it is empty. Is their a simple way to do this?
Kind Regards
Chris
I am making a spreadsheet for work which consists of several Cells containing text relating to job that have to be accomplished during a night's work. I have these all listed down the sheet from B4 down. I want to colour these depending on the time the job needs to be completed by which is not an issue. What I am looking to do is make 4 more columns with peoples names e.g. John, Bill, Peter and Bob and then be able to click and drag the cell with the job I want to allocate to them underneath there name and have it move out of the list of jobs and re position under there name. Basically dragging jobs to people from the list until it is empty. Is their a simple way to do this?
Kind Regards
Chris