Cannot filter combined workbook

[Michael Abrams]

I finally googled and found out how to combine multiple workbooks into one. I was amazed how easy it was - sure beat copy/pasting all of them into one

Here is my question:
The new workbook was saved as xlsx in My Documents. So far so good.

But when I tried to filter a single column, the filter was not available.
But if I wanted to filter the entire sheet, it did allow me.

I have a macro that bombs out here

Code: Select all

Selection.AutoFilter

and figured it must have to be due the filter not being available.

What do I need to do to have the filter available?

Here is the entire macro code:

Code: Select all

ActiveWindow.LargeScroll ToRight:=3
    Columns("BI:BI").Select
    Selection.AutoFilter
    ActiveSheet.Range("$BI$1:$BI$100000").AutoFilter Field:=1, Criteria1:="=N", _
        Operator:=xlOr, Criteria2:="="
    Rows("2:100000").Select
    Range("BF2").Activate
    Selection.Delete Shift:=xlUp
    Selection.AutoFilter
    Application.Run "Personal.xlsb!UHCMS_HOSPICE"
    Cells.Select
    Selection.ColumnWidth = 8.57
    Cells.EntireColumn.AutoFit
    Range("C12").Select
    Application.Run "Personal.xlsb!ADD_OUTCOME_COLUMN"

[HansV]

I'd have to see a copy of the sheet.

[Michael Abrams]

Here is the instruction I used.

eileen doc.docx

As happens to me too often, I missed a key element. The files workbooks I combined are all .csv - not sure if that matters.

It is apparently a Power Query - don't know how to convert it to xlsx through Power Query.

If you still need to see the workbook, I can post it.

[HansV]

You'll have to save the resulting workbook yourself.

[Michael Abrams]

OK thank you HansV.

Michael