Copy specific columns and save into another workbook

**stoey** · 09-12-2008, 11:31 AM

Hi,

I would like to know how do I go about copying specific columns and save it to another workbook. I have a worksheet with 31 columns. I have a Userform too. On my Userform, I have 2 textbox and 1 command button. Textbox 1 is use to enter the start column to copy and Textbox 2 contains end column to copy. click on command button and it will generate the results of copying. Anyone can help me about this?

Thanks,

Stoey

**aravindhan_31** · 09-12-2008, 11:51 AM

Check this thread,
check for richards reply,
http://www.excelforum.com/excel-prog...mns-forms.html

from this u can select columns which you want to copy to another sheet, from there you can save only that sheet as a file...

Arvind

**stoey** · 09-12-2008, 12:00 PM

Hi Arvind,

Thank you very much for the info. I did check richard's sample file and seemingly I can make use of the extract example. However, I would like to have the extracted file be automatically computed. Like if I extract column Sep 1 to Sep 5, I would like to total the value from each row. Any idea on how to do that?

Thanks,

Stoey

**stoey** · 09-12-2008, 04:02 PM

Hi,

Can someone help me on copying the contents of the column selected? The file works by extracting the selected columns from a different worksheet. My problem is the dates selected are being extracted exept for the contents. I would like all information to be extracted including the dates and the contents of every column selected.

Thanks,

Stoey