Can anyone help with this formula? Its beyond me, but I have been told it can be achieved with Excel, I need a formula that I can input information to a specific job number, so when i change between jobs the information is store individually to the specific job number not sure if this a pivot table or a job look up but the information below is how far I have got, any help would be most appreciated!
