Despite being completely new to macros, I'm attempting to create one 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 that was just inserted with the copied data - and continue to search that column and repeat the above fro every time it finds that same value in that entire column.
I've had very limited success and any help/advice/solutions would be greatly appreciated!
