importing specific data from another worksheet

[wendell45]

I frequently import data from an external worksheet into my worksheet. is there a way to specify which columns I want to import? Currently I import all data and then delete what I don't want. thanks for any help.

[NoSparks]

Have you tried using the macro recorder for an idea as to how VBA could be used to accomplish what you're currently doing manually ?

[wendell45]

I haven't. I'm not that deep into excel yet...if you think that there may be an answer there I'll check it out.

thanks

Wendell