Macro to Export Variable columns from One Excel Work Sheet to another

**naresh73** · 08-20-2013, 08:45 AM

Hi All,
I am a started in VBA, Please any help in regards is uch appreciated,

I have a work sheet as Data Base with data such as Name, Age, Process, Education and so on,
And I am in need of a macro code with User Form and ComboBox so that I can export any selected columns to a new worksheet using ComboBox.

Please help.
Thanks

**arlu1201** · 08-20-2013, 02:31 PM

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**naresh73** · 08-21-2013, 11:01 AM

Hi arlu1201,

Please find the attahcement of a sample copy that you were looking.

Out of which what I was looking is, I should be able to export any specific column (Variable) with row data Specification

Such as If I want to export only that data with Column A, B and D and that too only rows with P&S in Column D.

And in this example the export file must be with only one row i.e Row No:3 and 3 columns i.e. A, B and D.

Please help me arlu1201.

Any help in regards is much appreciated.