Insert Rows based upon value in cells

[forknowledge]

Hi y'all.

I'm trying to create a macro that will ultimately insert rows based upon a particular value in a range of cells. What I would like to know if there is any way to make active only those cells that contain the letter "X"? Then I would be able to insert rows at that point. I hope I'm making this clear. An example of data is listed:

X ANDY 57.00
X DAVE 43.93
DAVE 92.00
X FRED 4.66
X GREG 23.55
GREG 84.21
GREG 8.69
X MIKE 83.50
X SETH 41.33

to look like:

X ANDY 57.00

X DAVE 43.93
DAVE 92.00

X FRED 4.66

X GREG 23.55
GREG 84.21
GREG 8.69

X MIKE 83.50

X SETH 41.33

Any help on this will save me a ton of time and will be much appreciated.

Thank you,
John

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[forknowledge]

Works perfect! Thank you very much John.

John

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.