Data Table Question?

[Bob]

I have a table(1) of data ("A1:B34"). Col "A" has names and Col "B" has values.
I wish to create another table(2) which only copies (names and values) data
from table(1) with values in col "B".

 

[Shane Devenshire]

Hi,

Are you talking a Data Table or a Table of Data. Also what version of Excel
are you using? And why not just do Copy?

 

[Bob]

Sorry Shane, having trouble with this site. As a reasult I have posted the
same question twice now, but to answer your question:

Copy col a and col b only if there is a value in col b.
ie

Table1
lindup 23
law 0
low 7

What I'm after in table is as follows:

Table2
lindup 23
low 7

I'm using excel 2003.