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).

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Code[/TD]
[TD]Name[/TD]
[TD]Quantity[/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Country[/TD]
[TD]Group[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]Ben[/TD]
[TD]100[/TD]
[TD]London[/TD]
[TD]N/A[/TD]
[TD]United Kingdom[/TD]
[TD]ECO[/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]Sean[/TD]
[TD]95[/TD]
[TD]Boston[/TD]
[TD]MA[/TD]
[TD]United States[/TD]
[TD]COR[/TD]
[/TR]
[TR]
[TD]003[/TD]
[TD]Millie[/TD]
[TD]83[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]ECO[/TD]
[/TR]
[TR]
[TD]004[/TD]
[TD]Karl[/TD]
[TD]78[/TD]
[TD]Los Angeles[/TD]
[TD]N/A[/TD]
[TD]United States[/TD]
[TD]COR[/TD]
[/TR]
[TR]
[TD]005[/TD]
[TD]Amy[/TD]
[TD]75[/TD]
[TD]N/A[/TD]
[TD]CA[/TD]
[TD]United States[/TD]
[TD]COR[/TD]
[/TR]
[TR]
[TD]006[/TD]
[TD]Dom[/TD]
[TD]60[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]Italy[/TD]
[TD]ECO[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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

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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Code[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]003[/TD]
[TD]Millie[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Code[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]003[/TD]
[TD]Millie[/TD]
[/TR]
[TR]
[TD]005[/TD]
[TD]Amy[/TD]
[/TR]
[TR]
[TD]006[/TD]
[TD]Dom[/TD]
[/TR]
</tbody>[/TABLE]

4. N/A Country
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Code[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]003[/TD]
[TD]Millie[/TD]
[/TR]
</tbody>[/TABLE]


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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Code[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]004[/TD]
[TD]Karl[/TD]
[/TR]
</tbody>[/TABLE]

Any help will be much appreciated.

 

[James006]

Hi,

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

HTH

 

[unknownymous]

I haven't.