Macro to import list automatically from a workbook to another workbook

[danish6061]

I have 2 workbooks with various columns I want to import some columns automatically from workbook A to workbook B. Is it possible?

 

[danish6061]

OK, I understood. I applied all your steps as told and at last i saved both workbooks as macro enabled workbook and then closing it
but when i am reopening these workbooks then it shows at the top that "Macros have been disabled"
What am I missing or what should I do?

 

[Mel Smith]

You should see an option that will allow you to permit the macros to run in the workbook. This will happen each time you open the workbook.
Mel

 

[alansidman]

If you post sample data from the workbook you wish to copy and indicate what is to be imported (pasted) to the second workbook, I am sure we can assist with specific code. Use the XL2BB function provided at this site to copy and paste to the forum. Help us to help you by providing us with specific details. Your request is very vague so try to be specific.