Determine Which Cell is N/A

[unknownymous]

Hi Guys,

Can you help me with the coding for this one? I have a long set of data but just need to figure this one out to help me save time (tab name is Data Sheet).

Code	Name	Quantity	City	State	Country	Group
001	Ben	100	London	N/A	United Kingdom	ECO
002	Sean	95	Boston	MA	United States	COR
003	Millie	83	N/A	N/A	N/A	ECO
004	Karl	78	Los Angeles	N/A	United States	COR
005	Amy	75	N/A	CA	United States	COR
006	Dom	60	N/A	N/A	Italy	ECO

<tbody>
</tbody>

The macro will create another tab (rename as "REVIEW") whereas it will determine the following:

1. N/A City & Country (Column A & B)

Code	Name
003	Millie

<tbody>
</tbody>

2. N/A City (Column D &E )

Code	Name
003	Millie
005	Amy
006	Dom

<tbody>
</tbody>

4. N/A Country

Code	Name
003	Millie

<tbody>
</tbody>

3. N/A City (US) (Column G&H)

Code	Name
004	Karl

<tbody>
</tbody>

Any help will be much appreciated.

 

[James006]

Hi,

Have you tried to use ... from the Menu ... Data Filter ?

HTH

 

[unknownymous]

I haven't.