I made a detailed budget for a client of mine in which we keep track of hours spend. During the assignment I can image that some taks requires more hours than foreseen. There is a colum in which these extra hours needed can be entered. I want excel to force an action, namely: when a numbers of hours (doesn’t matter how much) in inserted in a cell in this colum that a additional explanation is given on another sheet called issue-log. I would be great if when additional hours are entered a some data from the budget (task, topic, teammember – which is all on the same row) is also copied to the sheet with the issue log.
Is something like this even possible?