Force action when data is entered

Hi there!

 

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?

Warm regards

Rick

 

By: Rick

Leave a Reply

Your email address will not be published. Required fields are marked *