Re: Inserting a bunch of rows at once.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David McRitchie (dmcritchie_at_msn.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 16:40:55 -0400

Hi Alan,
> No "normal" way that I can think off.

That was in answer to my posting? Perhaps ExcelTips Forum
references any message in a newsgroup thread rather than the one
you think you are replying to.

Beside taking much longer than a macro, I don't think your
solution would be very usuable. I assumes that the records
can be sorted, and that only one entry per sort key would have been
 in the original -- very dangerous assumptions.

But it's up the poster to determine if a solution works for them, and
to test on a copy of file first, rather than risk their data.

Not meant as anything personal it's just part of learning. A lot of
learning is from mistakes.

And Ken posted a similar solution but it would work a lot better as
one would sort on the added column, so the records would not be
put into the wrong order by sorting, but is still a heck of a lot more
work and slower than using a macro. Would still add extra blank
rows if none were needed.. 

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm
"otium >" <<otium.16gw1l@excelforum-nospam.com> wrote in message news:otium.16gw1l@excelforum-nospam.com...
> No "normal" way that I can think off.
>
> One "long winded solution" would be to ...
> 1) Copy all the rows
> 2) Sort data by column A (you should now have pairs of duplicates where
> the duplicate is where you want the blank row)
> 3) Add a new column with the formula =MOD(ROW(A1),2)
> 4) Assuming that your first data cell is A2 this should put a 1 into
> the "duplicate" rows.
> 5) Filter the new column by "1"
> 6) Highlight all these rows and pres the delete key
> 7) Remove the filter - you should have desired result
>
> Alan
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Relevant Pages