Would you consider using an Advanced Filter?

Try this example:

A5:E9 contains these values
Ref......Field1...Field2.....Field3..Field4
(blank)..2643F....pg 2 of 3..Orange..Friday
abc......1111a....pg 1 of 3..Red.....Monday
(blank)..2643F....pg 3 of 3..Orange..Friday
abc......1111a....pg 2 of 3..Red.....Monday

A1: Ref
A2: <*

H1:K1 contains these column headings
Field1...Field2...Field3...Field4

Select A5:E9
Then....from the Excel main menu
<data<filter<advanced filter
Check: Copy to another location
List Range: $A$5:$E$9
Criteria: $A$1:$A$2
Copy to: $H$1:$K$1
Click the [OK]

In the example, this table is returned
Field1...Field2.....Field3..Field4
2643F....pg 2 of 3..Orange..Friday
2643F....pg 3 of 3..Orange..Friday

Note: With some minor tweaking, you can use that technique to pull the
values to another sheet in the same workbook. Post back if you have
questions.

Is that something you can work with?

----------------------------
Regards,

Ron
Microsoft MVP - Excel

"plb2862" wrote in message
...
I have a sheet with (6) columns and (306) rows. I would like to search for
empty cells in column (6) and return the values in columns {2, 3, 4 & 5}.
And continue until the last row 308 is processed.

For Example:
G307 is empty returns
B307 2643F
C307 pg 2 of 3
D307 Orange
E307 Friday

= 2643F pg 2 of 3 Orange Friday

The empty Cell is
G308
B308 2643F
C308 pg 3 of 3
D308 Orange
E308 Friday

= 2643F pg 3 of 3 Orange Friday

Is there a non VBE/VBA solution?

TIA,
Phil