LaFlame
04-09-2007 21:10:14
I have a column, with about 669 cells filled with info(Y's) and 719 cells empty...total of 1388 cells...im trying to make a new empty row to separate them...separates every time a Y comes up, so it becomes like a group. and im not sure what formula to use, either =left or =isblank.
heres an example
[b3a4b8fc52b]from this[/b3a4b8fc52b][b3a4b8fc52b]
col 1 [/color3a4b8fc52b] col 2[/color3a4b8fc52b]
BTC [/color3a4b8fc52b] Y[/color3a4b8fc52b]
BTC[/color3a4b8fc52b]
BTC[/color3a4b8fc52b]
BTC [/color3a4b8fc52b] Y[/color3a4b8fc52b]
BTC [/color3a4b8fc52b] Y[/color3a4b8fc52b]
BTC
[/color3a4b8fc52b][/b3a4b8fc52b]
[b3a4b8fc52b]to this[/b3a4b8fc52b][b3a4b8fc52b]
col 1 [/color3a4b8fc52b] col 2[/color3a4b8fc52b]
BTC [/color3a4b8fc52b] Y[/color3a4b8fc52b]
BTC[/color3a4b8fc52b]
BTC[/color3a4b8fc52b]
<--empty row
BTC [/color3a4b8fc52b] Y[/color3a4b8fc52b]
<--empty row
BTC [/color3a4b8fc52b] Y[/color3a4b8fc52b]
BTC [/color3a4b8fc52b]
[/b3a4b8fc52b]
can anyone help me out?
moviemadnessman
04-09-2007 21:34:09
Rightclick on the row that you want the space in front of.
In your example, you would rightclick on what would be rows 4 and 6.
ILoveToys
05-09-2007 12:47:57
[quote0bf12c9751="moviemadnessman"]Rightclick on the row that you want the space in front of.
In your example, you would rightclick on what would be rows 4 and 6.[/quote0bf12c9751]
hahahahahaha....that would take forever for the size sheet he is working with.
What you can do is go to tools >> Macros >> Record a Macro.
Then do it a couple times by hand then hit stop on the macro toolbar. Then go into the VBA code and make a for loop to do it a bunch of times, and then run that macro. It will give you an error when it can't find anymore Y's but should do it for you.
moviemadnessman
05-09-2007 12:56:25
Lol ... sure, it might take longer my way, but it works. But using your way, will it only do it for the "y" rows, or will the macro record the spaces (inserting a new row every 4th and 6th, for example, rather than at the ones with a "y")?
I only ask that to be clarified because I can't remember, and it would be annoying to do it only to have it work incorrectly ;)