auto sort

[ttowncorp]

this will be a major help but i'm not sure if anybody can help me. I have a massive data sheet that i would like to sort out. I dump the raw data on sheet two and would like to type in the item i want to see the history on in sheet one. example below sheet two then sheet one.

ticket id	priority	date of service	vehicle id	user name	department	status	problem	corrective action	service date	comments	compliance
1	no	5/1/19	3201	robert	southern	completed	tires	replaced tires	5/1/19
2	yes	5/2/19	2200	bob	western	active	piston 4	n/a	n/a
3	no	5/2/19	2200	bob	western	completed	tires	replaced tires	5/2/19
4	no	5/2/19	2200	bob	western	completed	oil change	replaced oil	5/2/19

<tbody>
</tbody>

					2200
ticket id	priority	date of service	user name	department	status	problem	corrective action	service date	comments	compliance
2	yes	5/2/19	bob	western	active	piston 4	n/a	n/a
3	no	5/2/19	bob	western	completed	tires	replaced tires	5/2/19
4	no	5/2/19	bob	western	completed	oil change	replaced oil	5/2/19

<tbody>
</tbody>

 

[MickG]

Probably just this line, lengthen to 14.

With Sheets("Sheet1").Range("A3").Resize(c, [COLOR="#FF0000"][B]14)
[/B][/COLOR]

 

[ttowncorp]

that was the fix. thanks again.