Excel 2010 - Can excell do this? 1

[Snookless7]

Hello,

I have a simple spreadsheet that has all the same numbers in Column A1 through A9, for example 66555.

Then from A10 to A17 another identical set, example 39511.
This goes on and on, and the groups of numbers have all different qty of rows. all other columns have all different numbers

What I am looking to do is insert a blank row between each of these groups. I have been doing this manually...is there a Macro I can use?

The only thing consistent is the group of numbers in Column A.

Any Ideas?

thank you

 

[SkipVought]

hi,

is there a reason for inserting empty rows? this often destroys or greatly hampers the usefulness of tables and analysis features in Excel.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Andrzejek]

I am with Skip on this one, but if you are doing it by hand anyway...

Sub InsertBlankRows()
Dim i As Integer
Dim lngNo As Long

i = 1
lngNo = Range("A1").Value

Do Until Range("A" & i).Value = ""
    If lngNo <> Range("A" & i).Value Then
        lngNo = Range("A" & i).Value
        Range("A" & i).EntireRow.Insert
    End If
    i = i + 1
Loop

End Sub

Have fun.

---- Andy

 

[Snookless7]

Hello,

I need an empty row under each group because I need to sum all the numbers in all the other columns.

Does this make sense? Or is there an easier way to do this all together.

so for example.....A1 to A9 has an order ID number of 92392...in column b,c,d,e......and so on are numbers I need to sum for each of these orders.

 

[Snookless7]

Andrzejek....that worked great! Unfortunately I have no control of how I get the spreadsheet and I understand how it hampers the usefulness.

Is there a better way of doing what i am trying to do?

And thank you again...really appreciate it.

 

[SkipVought]

I need to sum all the numbers in all the other columns

What a tedious task!!!

Why not use the Data > Subtotal feature!!!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Snookless7]

Why not use the Data Subtotal Feature??

I did not know there was one. I know I know......I will look that up and see if I can figure that one out.

Thank you much
Todd

 

[Snookless7]

I think I got it...but is there a way to not make it create a whole new column to the left?

 

[SkipVought]

That's part of the feature.

Nice a quick, or tedious and messy.

YOUR CHOICE!!!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Snookless7]

Skip.........your right of course. I think I will choose Nice and Quick.
Thanks for your help

 

[Snookless7]

So Last Month I go the above Macro and it worked great, I did save the Macro but when i try to run it I get an "Run-Time Error Type MisMatch"

What am I doing wrong, the spreadsheet is the same except for the data within it.

Thanks

 

[SkipVought]

plese post your macro.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

okay, you are using Andy's macro AS WRITTEN?

You get Type missmatch on what statement?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Snookless7]

I got it...was user Error. i forgot to remove the header.
Thanks peeps.