Macro to Find, Copy and Insert [Closed]

Report
Posts
2
Registration date
Wednesday May 17, 2017
Status
Member
Last seen
May 20, 2017
-
Posts
2
Registration date
Wednesday May 17, 2017
Status
Member
Last seen
May 20, 2017
-
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

1 reply

Posts
2
Registration date
Wednesday May 17, 2017
Status
Member
Last seen
May 20, 2017

Still stuck! Anyone able to shed any light or offer assistance?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!