ObiWanBaloney
New Member
- Joined
- May 10, 2012
- Messages
- 23
Hi All,
Here's an example of what I'm trying to do. Here's 3 columns of data:
Yes No Maybe
Yes Yes Maybe
Yes No Maybe
No Maybe Yes
...and so on for ~15000 rows. What I would like to do here is to use VBA to add a blank row above all rows that have "No" in column 2 and only column 2. The end result would look kind of like this:
(new row)
Yes No Maybe
Yes Yes Maybe
(new row)
Yes No Maybe
No Maybe Yes
Thanks!
Here's an example of what I'm trying to do. Here's 3 columns of data:
Yes No Maybe
Yes Yes Maybe
Yes No Maybe
No Maybe Yes
...and so on for ~15000 rows. What I would like to do here is to use VBA to add a blank row above all rows that have "No" in column 2 and only column 2. The end result would look kind of like this:
(new row)
Yes No Maybe
Yes Yes Maybe
(new row)
Yes No Maybe
No Maybe Yes
Thanks!