罗嗦点实现吧 用表b的值逐一遍历,跟a的值逐一比较,如果相同的就清楚。
大概 dim c as range
dim c2 as range
for each c in range("a1:yy")--表b的数据区域
for each c2 in range("a1:xx")--表a的数据区域
if c.value=c2.value then
c2.value=''
next
next
大概 dim c as range
dim c2 as range
for each c in range("a1:yy")--表b的数据区域
for each c2 in range("a1:xx")--表a的数据区域
if c.value=c2.value then
c2.value=''
next
next
sql语句中又怎样来实现呢?