Copy Columns from multiple workbooks to one workbook

[nwixx]

Hello! I am very new to VBA, and my stumbling block is this. I have three workbooks. Although they have other columns, the columns they have in common are apples, oranges, and grapes, and they are not in the same order in each of the workbooks. Is it possible to copy the information in apples, oranges, and grapes from each of these workbooks to a new workbook of just these columns?

Any help is much appreciated!

 

[Fluff]

Glad to help & thanks for the feedback.
If you need any help understanding the code, just ask

 

[My Aswer Is This]

See: nwixx I asked a few questions drew some attention and Presto you have an answer. I did not have to sort this out for you. But I did work on it some before going out for lunch.

 

[nwixx]

Since I'm just starting down the road to learn VBA, everything, questions included, has been very helpful. This community environment is a great resource! Thanks & much appreciated!

 

[My Aswer Is This]

Glad we were able to help you. Come back here to Mr. Excel next time you need additional assistance.

Since I'm just starting down the road to learn VBA, everything, questions included, has been very helpful. This community environment is a great resource! Thanks & much appreciated!