ExcelBanter - Advanced filter

Advanced filter is not working for me - my spreadsheet has about 4000
rows and 20 columns. Item 1 takes up the first 2 rows, item 2 the next
2 rows and so on like this:

ID COL2 COL3 COL4 COL5 COL6
COL21 COL22
ABC xxxx xxxx
ABC xxxx xxxx
DEF xxxx xxxx
DEF xxxx xxxx
GHI xxxx xxxx
GHI xxxx xxxx

I want to move the data in four adjacent cells for each ID (as shown by
the xxxx) to COL21 and COL22. The trouble is those four adjacent cells
are all over the place. The other problem is a there are a lot of blank
cells.
There is a constant (text) in the top left cell of each block of 4
adjacent cells.

Auto filter works OK in identifying the constant on a column by column
basis but there does not appear to be any way of also selecting the
cell immediately below and the 2 immediately to the right. I envisage
that Advanced filter might allow this selection (and moving) of the 4
cells. Trouble is I can't get Advanced Filter to work at all. Not even
to find that key top left cell.

Any help greatly appreciated

Daisy10

--
Daisy10
------------------------------------------------------------------------
Daisy10's Profile: http://www.excelforum.com/member.php...o&userid=37003
View this thread: http://www.excelforum.com/showthread...hreadid=567284