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

Advanced Filter - When I posted the example, it has not appeared as I
typed it:

Please envisage that the four cells I want to select and move for item
DEF start in Column 5 and those for item GHI start in Column 4 - in
other words each block of four cells for each item can be found
anywhere in the spreadsheet.


Daisy10


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