write macro to fetch particular column in workbook to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
VBA insert column with two workbooks open 1
Unwanted workbooks on startup 2
Macro shortcuts are running macros in different open workbook 3
Open Workbook Macro - with a twist 1
selecting more than one cell 3
can I use code to make code in another book 3
Call routines of other workbooks? 1

Back
Top