Stock codes cleaning up

[makinmomb]

if cell a is not in the format 000.000.00

Delete the rows they are junk

Once it has deleted those , it should
create row between each series

This means if it trims as required ,
The result sheet will have 4 lines ,
the header , one line with code 101
than a empty row , than codes 102
start , I have series 103 104 running to
300 , and each series has e.g.

103.000.01
103.000.02
and so on

[makinmomb]

In short i need a row between when each new series start

100.000.01
100.000.02

101.000.01
101.000.02

103.000.01
103.000.02
103.000.03

and so on

[makinmomb]

This is a macro

[makinmomb]

work data 7500 rows

[makinmomb]

separator in short

[makinmomb]

I have found the formula to clean unwanted
codes , I thus only need a separator macro

[makinmomb]

I had not attached expected results prior

In case this helps

[makinmomb]

The macro should find the first 101.000.
then insert row
then 102.000.
then insert row
and so on upto 300.000.

[apo]

Hi..

A simple loop will do it..

Please Login or Register  to view this content.

Note: You could also use the Left function instead of Split.

[makinmomb]

Its not working when I press ALT F8 for run ?

I have pasted your code through ALT F11 , insert module

[makinmomb]

I don't know the abc of macros , thus
I made a wild guess

I edit the first line of the macro to

Sub InsertRow()

[makinmomb]

Thanks apo , I needed it very badly
finally i got the answer