Insert Entire Row gets duplicated

[MIG285]

Hi I have an issue with the code below,

It inserts a new row if data is different when sorting out in column "B" it inserts another blank row which ic not needed is there any way around it that little issue

Looking forward to your response

MIG285


Platt Fishwick Core Rebuild 1st Jun - 30th Nov 2014 RAW.xlsx

Please Login or Register  to view this content.

[mehmetcik]

This looks at column b and inserts a blank line under each entry

It then does the same for column A

How did you want it to work?


under Column A

Please Login or Register  to view this content.

under Column b

Please Login or Register  to view this content.

[MIG285]

Hi mehmetcik,

What I need it to do is sort out column a first then repeat the process with column B but with out inserting an additional row if there is a blank row there already need it to move to next non blank row in column "B"

I have tried something out which actually works as an end result and may not need to do a two step sort, would what i have tried be an easier solution to the issue I am facing

Let me know

Mig285

Please Login or Register  to view this content.

[mehmetcik]

Please Login or Register  to view this content.