Macro to move cell down a row based on criteria

[neilcarden]

Hi all, I would like a simple macro that would actually move a cell based on criteria. In my case it would be:

In row A, if a cell starts with 'Agent Name' then that cell needs to move down one cell replacing the contents of that cell...

Hope that makes sense?

[mewingkitty]

How many rows ?

[mewingkitty]

Please Login or Register  to view this content.

I'd go with something like that.

[neilcarden]

Hey thanks! Works fine!