Potential Macro Question

[hellokirsten]

Hi all! Very happy to find this resource
I will try to be as thorough/concise as I can be

- I have a CSV file that we download for a number of customers. I have created a macro to remove all of the unnecessary information from that CSV file
- Now, there is a field of audit notes that I am trying to divide into these different sections: Idle (notes that contain "idle"), Hardware (notes that contain "battery, heartbeat, transition, and transport"), and Install (notes that contain "initial" or "engine")
- For those three different sections, I am wanting to build something that will take that full file, and divide it into three different sheets

I've tried to record a macro - but the line items range from 20 - 700, so the recording of the macro did not work very well.
Any help would be greatly appreciated!

 

[hellokirsten]

Thanks!! Is this looking for if the field contains that idle, battery, etc. or is it looking for fields that are exactly "idle", etc.

 

[Fluff]

It's looking for contains

 

[hellokirsten]

The three different sheets are creating when I run that, but it isn't moving anything to those sheets.

 

[Fluff]

If you step through the code using F8, whilst looking at the sheet with the data, once it gets to apply the filter are there any visible row?

 

[hellokirsten]

once it hits: .Range("A1:K1").AutoFilter11, CritAry(Cnt)
I receive an error of Method 'AutoFilter" of object 'Range' failed

 

[Fluff]

Try recording a macro to filter the data & post the resulting code.

 

[hellokirsten]

Sub test()
test Macro
Keyboard Shortcut: Option+Cmd+g
    Columns("A:F").Select
    Selection.AutoFilter
End Sub

I'm not sure if that's what you're looking for, sorry for my ignorance!

 

[Fluff]

Could you do that again, but actually filter one of the columns.
Just trying to check if there are any differences between PC & Mac

 

[hellokirsten]

Sub Macro6()
Macro6 Macro
Keyboard Shortcut: Option+Cmd+u
    Columns("F:F").Select
    Selection.AutoFilter
End Sub

there we go

 

[Fluff]

Did you apply the filter, eg to filter on the word Idle?