Sort question

[Richard]

I have a strange sort question. In column B there is information every
7 rows. Then you skip 1 row (Blank) Then there is the same information
but with different dates in the next 7 rows and so on. Is it possible
once there is information in All seven rows to delete that information
and move everything thats below it up. Keeping everything together.
Without cut, copy and pasting. I know some VB. Is there a good VB
newsgroup that can help? Thanks in advance.

 

[PatriceRoy]

I have a strange sort question. In column B there is information every
7 rows. Then you skip 1 row (Blank) Then there is the same information
but with different dates in the next 7 rows and so on. Is it possible
once there is information in All seven rows to delete that information
and move everything thats below it up. Keeping everything together.
Without cut, copy and pasting. I know some VB. Is there a good VB
newsgroup that can help? Thanks in advance.

Hi Richard,

There might be an easier way. Create a simple macro with the relative
option on.

Place the cursor on the row you want to remove.
Go to View tab.
Select Macro and Record Macro.
Activate Use Relative References.
Give it a name and maybe a number to go with the CTRL + shortcut.
Select the row and delete it.
Move the cursor seven rows down.
Close the macro.

Repeat it a couple of times to remove all the rows you don't want. I
suggest you use CTRL and another character (2, 3, 4 ...) to make it
faster.

Simple and fast.

Patrice Roy