Hi,
At work we have Office 2013. I use it to keep records of my work.
There are seven columns. The first is where I enter the claim number. The second and third are columns with drop down lists to add actions. The fourth is text where I put what I did, The fifth is the time, the sixth is a drop down list for action taking and the seventh is for extra text notes.
The first of the two things I’d like to do is when the third column has data entered into it from the drop down list it will automatically add the time to the fifth column.
The sixth column has four items in the drop down. This is a list on how I went about to complete the work. Simple text, ‘Call’, ‘WEB’, ‘REV’, ‘ACT’. The final one’ ACT’ would be null for the next action.
This action is to move simple information to another sheet in the workbook. All I need is information from that days work. There would be two columns in the second sheet grabbing the claim numbers from the first column. On the second sheet the first column would be for claim numbers that were indicated with ‘Call’, the second column would be for ‘WEB’ or ‘REV’.
To run whatever action required could be simply enough by me selecting the area that was worked on the day.
Thanks in advance - Phil
At work we have Office 2013. I use it to keep records of my work.
There are seven columns. The first is where I enter the claim number. The second and third are columns with drop down lists to add actions. The fourth is text where I put what I did, The fifth is the time, the sixth is a drop down list for action taking and the seventh is for extra text notes.
The first of the two things I’d like to do is when the third column has data entered into it from the drop down list it will automatically add the time to the fifth column.
The sixth column has four items in the drop down. This is a list on how I went about to complete the work. Simple text, ‘Call’, ‘WEB’, ‘REV’, ‘ACT’. The final one’ ACT’ would be null for the next action.
This action is to move simple information to another sheet in the workbook. All I need is information from that days work. There would be two columns in the second sheet grabbing the claim numbers from the first column. On the second sheet the first column would be for claim numbers that were indicated with ‘Call’, the second column would be for ‘WEB’ or ‘REV’.
To run whatever action required could be simply enough by me selecting the area that was worked on the day.
Thanks in advance - Phil