Macro to find-insert and Prompt user for Text Loop

[excellentlearner]

Hello. I am trying to write a macro that will search down column B, find a User Prompted Term, insert a blank row beneath it and continue this for all instances. I have managed to get this to work with the macro below.

HELP: What I am trying to achieve on my next step is to have the User Prompted again for the Text to have populated in the new, inserted rows ( all instances). Please let me know if this does not make sense. And the "Text" should go into the cell in column B. Thank you in advance for any help!

Please Login or Register  to view this content.

[patel45]

Attach a sample file with before an after macro run

[excellentlearner]

Book1-sample.xlsxHere is the sample file with before/after shapshots

[excellentlearner]

please let me know if the attachment doesnt open.

[excellentlearner]

I already have most of the macro working- i just need assistance in the last step. Getting a user prompted input into all newly inserted rows.

[excellentlearner]

are we allowed to *bump* ?

I am sorry if we cant

[Cutter]

Please limit 'bumping' to 1 per day.