I want to write a macro that need to fetch the particular column of one
workbook to another workbook.

Hi Nizam:

Where is your problem?

Is it with writing the macro (ie how to use excel and VBA editor?)
Is it the VBA code (ie what do I have to write?)
Is it a problem with the data ( it changes and the workbook is not open?)

Give the group some more information and maybe you request will be answered.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Nizam" wrote:

I want to write a macro that need to fetch the particular column of one
workbook to another workbook.

Hi Nizam,

The easiest way to achieve this is to simply record the action, i.e. go to
Tools - Macro - Record new macro..
and perform the action you want the macro to do. When finished recording, go
to Tools - Macro - Macros and select your new one for edit. If necessary, you
can the make the commands a little more flexible.

Hope this helps.
--
Gerd


"Nizam" wrote:

I want to write a macro that need to fetch the particular column of one
workbook to another workbook.