Copy list only with values?

H

hoyos

I have a table with names (col A) and values (col B). I am trying to create a
table using col C and D to list te names and values from table1 that only
have a value.
ie
Name Value Name Value
Jim 9 Jim 9
Joe Joe 1
sue 1 Ant 5
Ant 5 Bill 3
Hill
Bill 3

This table will change on a daily bases.
Can anyone help!!!
 
B

Bernd P

Hello,

Did you press ALT + F11, insert a new module, copy my macro into that
new module and go back to your worksheet?

If yes, how EXACTLY does your formula look like (please show the
complete formula)?

Regards,
Bernd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top