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]

Sub Macro7()
Macro7 Macro
Keyboard Shortcut: Option+Cmd+t
    Selection.AutoFilter
    ActiveSheet.Range("$F$1:$F$272").AutoFilter Field:=1, Criteria1:="*idle*"
End Sub

 

[Fluff]

Try changing that line to

         .Range("A1:K" & UsdRws).AutoFilter Field:=11, Criteria1:=CritAry(Cnt)

 

[hellokirsten]

Changed that line, ran into the same issue of the sheets being blank
Ran the step through again, same error on that same line after I changed it

 

[Fluff]

Unfortunately I can't understand why that is happening, unless there is something different between Mac & PC when using Autofilter

 

[hellokirsten]

Appreciate all your help!

 

[Fluff]

Sorry I couldn't help further

 

[hellokirsten]

Completely forgot I also have a windows work laptop as well - I'm getting the same error on windows excel if that makes any difference

 

[Fluff]

Ok this is the test data that I'm working with. Is this the same layout & positioning that you have?

Excel 2013 32 bit
	A	B	C	D	E	F	G	H	I	J
1	EW Asset Name	Equipment Type	ESN	Device MIN	FW	Last Transmitted	Device Model	Currently Coupled	First Coupled	Audit Notes
2	166801	Smooth Roller	C5S00210		-	Dec 15 2017 05:54AM	AEMP	Jun 01 2014 12:00AM	Jun 01 2014 12:00AM	Last transmission was AEMP on 12/15/2017, is the device still installed?
3	169200	Scraper	DBW00130		-	Dec 15 2017 11:43AM	AEMP	Jun 01 2014 12:00AM	Jun 01 2014 12:00AM	Last transmission was AEMP on 12/15/2017, is the device still installed?
4	169201	Scraper	DBW00131		-	Dec 15 2017 11:44AM	AEMP	Jun 01 2014 12:00AM	Jun 01 2014 12:00AM	Last transmission was AEMP on 12/15/2017, is the device still installed?
5	141508	Wheel Loader	4642007212	A100003690ABCB	2.82	Jan 10 2018 01:57PM	GS-280	May 12 2015 12:00AM	May 12 2015 12:00AM	Last transmission was Transition to Sleep on 01/10/2018, is the device still installed? Equipment has been idle 71.43% during 01/04/2018 - 01/11/2018
6	18200	Transport Detach Trailer	3143037674	A10000438633CE	7.4	Dec 28 2017 04:10PM	GS-720t	Oct 20 2015 12:00AM	Oct 20 2015 12:00AM	Last transmission was Initial Power Up on 12/28/2017, is the device still installed?
7	19227	Enclosed Cargo Trailer	3143038420	A10000438640DE	-	Jan 10 2018 05:50PM	GS-720t	Oct 28 2015 12:00AM	Oct 28 2015 12:00AM	Last transmission was Heartbeat Sleep on 01/10/2018, is the device still installed?
8	19221	Enclosed Cargo Trailer	3143046224	A1000043849219	7.4	Sep 12 2017 12:00PM	GS-720t	Dec 03 2015 12:00AM	Dec 03 2015 12:00AM	Last transmission was Initial Power Up on 09/12/2017, is the device still installed?
9	101002	Truck Crane	4642015384	A100004386D792	2.83	Jan 10 2018 04:26PM	GS-280	Jun 17 2016 12:00AM	Oct 07 2015 12:00AM	Last transmission was Transition to Sleep on 01/10/2018, is the device still installed?
10	10265	All Terrain Crane	4642018313	A100004386C658	2.83	Nov 15 2017 10:20AM	GS-280	Dec 31 2015 12:00AM	Dec 31 2015 12:00AM	Last transmission was Transition to Sleep on 11/15/2017, is the device still installed?
Ranking

Also do you have any merged cells, blank rows?

 

[hellokirsten]

delete column c, d, e, h, and i
there is one column that is proprietary info (so I have a total of 6 columns - A-F)
i am so sorry - I forgot that I removed all of those

 

[hellokirsten]

no merged cells or blank rows