Need help with working macro -data extraction

Hi,

I am an excel macro novice and need your help in fixing and making new addition to the macro if possible; the attached macro was earlier done by Jaslake.

How the macro works:

The attached personal.xlsb works when I copy paste data from the attached data sample excel file (copy data to personal.xlsb and press ctrl+z to see the result - it should create a output file)

Macro criterion - column headers should be in first row

First Issue.

I want to make sure this macro is available for all workbook hence I saved it as personal.xlsb and pasted into %appdata

%/microsoft/excel/xlstart but when I run the macro when in a different workbook it only brings up a blank userform.


Second objective

Once the above is fixed can we have the macro copy the columns from open workbook active sheet to another workbook active sheet(any

open workbook) else it should simply create an output like it always does.

Thanks!
4gurus

Hi Alan,

I did that and I now get a debug error. Please help.

Thanks!

4gurus

Hi Jaslake,

Wondering if you could help me with this.

Thanks!

4gurus