Hi everyone

Hope this is the correct forum for this question and if not - pleas
accept my apologies. I have shown a small extract from a spreadsheet
What I need is a macro that I can run which goes first to the top o
column B (size) checks if the content is an F followed by 4 digits. I
yes, copy the cell and continue down column b until it reaches group.
then need it to go right to location and paste in the F#. It should the
move left again, back to column B on the same row and continue checking
Each time it finds an F#, it copies it and proceeds down column B unti
it finds group. and moves to the right, pastes it etc, then continue
down column B. I can't create a simple macro as the numbers of rows i
each group varies. If anyone can offer help or advice i would be mos
grateful. Thanks in advance to anyone who can help. subtotal for is i
column A and group is in column B.

type size weight number location
F1234






subtotal for group F1234

F1241


subtotal for grou

--
john gibso
-----------------------------------------------------------------------
john gibson's Profile: http://www.excelforum.com/member.php...fo&userid=3718
View this thread: http://www.excelforum.com/showthread.php?threadid=56895