Thread
:
How can I insert a row in MS Excel using a formula?
View Single Post
#
5
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
How can I insert a row in MS Excel using a formula?
Yes. Or you could have an input box asking the user which column.
And, if you want to run for multiple columns that can be done to make one
mouse click.
But, are you sure you want to do that cuz you might get rows inserted that
you don't want.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Pman" wrote in message
...
Thanks a lot Don :)
Also if I want to repeat it for other columns, I just have to run the
macro
again but replace the "b" in the code with the corresponding column name
right?
Thanks again, You made my day :)
-Pman
"Don Guillett" wrote:
copy this macro into a module.
Sub insertspaces()
For i = Cells(Rows.Count, "b").End(xlUp).Row To 2 Step -1
If Cells(i - 1, "b") < Cells(i, "b") Then Rows(i).Insert
Next i
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Pman" wrote in message
...
Hi,
I have an excel file which goes like this in my first 2 columns:
PRODUCT PUBLICATION
NAME
Product 1 publication 1
publication 1
publication 2
Product 2 publication 1
publication 1
publication 2
Product 3 publication 3
Product 4 publication 2
This file runs in 20k + rows.....and I need to insert a new row
whenever I
encounter a new product or publication. The end result as I want is
below:
PRODUCT PUBLICATION
NAME
Product 1 publication 1
publication 1
publication 2
Product 2 publication 1
publication 1
publication 2
Product 3 publication 3
Product 4 publication 2
Notice that there's a row between new products and new publications.
Can
someone tell me an easier way to do it , or than doing it manually for
20,000+ rows?
Thanks :)
P
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett