Removal of multi lines via macro

[ukphoenix]

Hi All

I have a dilemma.

I need to be able to hide multi customer lines within a spreadsheet via a macro. Ive uploaded a sample.
The macro needs to look at a column and then hide any multi customer lines it finds

In the sample the offending multi customer is Interactive. I know this is a multi as in column B, B3 is blank which would indicate it is the same load number as B2 and therefore needs to hide/filter out lines 2 & 3

Hope ive explained it well enough

[xladept]

Here's a hide and recover tandem:

Please Login or Register  to view this content.

[Fluff13]

Another option

Please Login or Register  to view this content.

This will toggle between hiding & unhiding.

[ukphoenix]

Another option

Please Login or Register  to view this content.

This will toggle between hiding & unhiding.

Thanx, this seems to be the easier code to use and does hide the blank line in question (line 3), but it also needs to hide the first line of the multi with the order number on it aswell (line 2)

Attachment 679240
Attachment 679241

[xladept]

Thanks for the rep!:

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[Rick Rothstein]

Expanding on Fluff13's "no loop" idea...

Please Login or Register  to view this content.

Note: We cannot use Fluff's "Not .Hidden" idea in case the last cell in Column B is blank, so you will still need separate code to unhide all the rows (as xladept offered).

[jindon]

it also needs to hide the first line of the multi with the order number on it aswell (line 2)

Please Login or Register  to view this content.

[ukphoenix]

Please Login or Register  to view this content.

Can you elaberate on your code as I cant seem to get it to work. Keeps debugging at 'With Union' line
The code below is what was supplied by Fluff13 with a few modifactions and indeed does hide the lines with the blank cells but with all the coding supplied cant see how to alter it to hide the line above the blank.

Any help of rewrite would be appreciated

Please Login or Register  to view this content.

[Fluff13]

How about

Please Login or Register  to view this content.

[jindon]

See................

[ukphoenix]

Thanx Fluff13, Jindon working.

[Rick Rothstein]

Expanding on Fluff13's "no loop" idea...

Please Login or Register  to view this content.

Note: We cannot use Fluff's "Not .Hidden" idea in case the last cell in Column B is blank, so you will still need separate code to unhide all the rows (as xladept offered).

I was wrong when I said we cannot use Fluff13's idea... I implemented it incorrectly. Fluff13 used Column B and I changed it to an offset from Column A. If we use his original Column B suggestion, this is how my version of his code, expanded to hide the row above the blank as well, would look...

Please Login or Register  to view this content.

[Fluff13]

You're welcome & thanks for the feedback.

[jindon]

You are welcome.