I have data on Sheet1 Range A5:E25, A contains text B:E contains
values.

I want to copy the data from Sheet1 to Sheet 2 dependent on the text in
Sheet 1 Column A.

Example:

If A5 on Sheet 1 is < than "Other Publisher Groups" I want to copy
A5:E5 to Sheet 2 cell B4:F4.

If A5 on Sheet 1 is ="Other Publisher Groups" I want to drop down a row
and copy A6:E6 to Sheet 2 cell B4:F4.

In short If the value in A is < to "Other Publisher Groups" I want to
copy

Sheet1 A5:E5 to Sheet 2 B4:F4 Then
Sheet1 A6:E6 to Sheet 2 B5:F5
Sheet1 A7:E7 to Sheet 2 B6:F6

If Sheet1 A8 = "Other Publisher Groups" I would jump a row i.e.

Sheet1 A9:E9 to Sheet 2 B7:F7

Hope that makes sense.


--
Timbo
------------------------------------------------------------------------
Timbo's Profile: http://www.thecodecage.com/forumz/member.php?userid=24
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98084