Macro to Find, Copy and Insert

Closed
Reimertoad Posts 2 Registration date Wednesday 17 May 2017 Status Member Last seen 20 May 2017 - 17 May 2017 à 11:34
Reimertoad Posts 2 Registration date Wednesday 17 May 2017 Status Member Last seen 20 May 2017 - 20 May 2017 à 22:25
Greetings,

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!

Cheers
Related:

1 response

Reimertoad Posts 2 Registration date Wednesday 17 May 2017 Status Member Last seen 20 May 2017
20 May 2017 à 22:25
Still stuck! Anyone able to shed any light or offer assistance?