Greetings,

I'm attempting to create a macro that will search a range of values, and insert a row directly underneath any of the values found - via an input box.

In column F, I have a list of employees' 'Start Times'. I want to create an input box that prompts me to enter a specific start time (there are 37), and once it finds an exact match of that particular value it will A) copy the row in which it was found, B) insert the entire row directly underneath (including the formulas), and C) shade the new row in yellow.

I've had very limited success and any help would be greatly appreciated!!