Copy cell to new tab from another tab but skip empty cells

[Trislu]

Hi,

Please HELP!

I am trying to create a 2nd tab where it looks for text "OFF" in ColumnB from ColumnA, and copy "Name" in ColumnA to 2nd tab. At the same time, the function skips blank cell.


TAB 1
(ColumnA) (ColumnB)
[TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Name[/TD]
[TD="class: xl65, width: 64"]Amount[/TD]
[/TR]
[TR]
[TD="class: xl66"]Anne[/TD]
[TD="class: xl66"]OFF[/TD]
[/TR]
[TR]
[TD="class: xl66"]Amy[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"]Mike[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"]Doe[/TD]
[TD="class: xl66"]OFF[/TD]
[/TR]
[TR]
[TD="class: xl66"]Anne[/TD]
[TD="class: xl66"]OFF[/TD]
[/TR]
[TR]
[TD="class: xl66"]Mike[/TD]
[TD="class: xl66"]OFF[/TD]
[/TR]
[TR]
[TD="class: xl66"]John[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"]Doe[/TD]
[TD="class: xl66"]OFF[/TD]
[/TR]
</tbody>[/TABLE]


Ideal Tab2
[TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Name[/TD]
[TD="class: xl65, width: 64"]Amount[/TD]
[/TR]
[TR]
[TD="class: xl66"]Anne[/TD]
[TD="class: xl66"]OFF[/TD]
[/TR]
[TR]
[TD="class: xl66"]Doe[/TD]
[TD="class: xl66"]OFF[/TD]
[/TR]
[TR]
[TD="class: xl66"]Anne[/TD]
[TD="class: xl66"]OFF[/TD]
[/TR]
[TR]
[TD="class: xl66"]Mike[/TD]
[TD="class: xl66"]OFF[/TD]
[/TR]
[TR]
[TD="class: xl66"]Doe[/TD]
[TD="class: xl66"]OFF[/TD]
[/TR]
</tbody>[/TABLE]

I tried to use IF function, but it doesn't skip blank cell.

 

[Trislu]

Be more specific, I want the 2nd tab only pick up values with "OFF" in column B, the Tab 1 can be

TAB 1
(ColumnA) (ColumnB)
[TABLE="class: cms_table, width: 128"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 64"]Name[/TD]
[TD="class: cms_table_xl65, width: 64"]Amount[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]Anne[/TD]
[TD="class: cms_table_xl66"]OFF[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]Amy[/TD]
[TD="class: cms_table_xl66"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]Mike[/TD]
[TD="class: cms_table_xl66"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]Doe[/TD]
[TD="class: cms_table_xl66"]OFF[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]Anne[/TD]
[TD="class: cms_table_xl66"]OFF[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]Mike[/TD]
[TD="class: cms_table_xl66"]OFF[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]John[/TD]
[TD="class: cms_table_xl66"]ON[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]Doe[/TD]
[TD="class: cms_table_xl66"]OFF[/TD]
[/TR]
</tbody>[/TABLE]

 

[Trislu]

Problem solved.