Sort highlighted cells

[Emilybuhman]

Hello!

I have been trying to figure out the code for the following type of data:

Bi-monthly, I export from quickbooks. There is not much I can do with how this is exported.

the data look like this:

col A: staff name - this is ONLY on the top row
Col b: (starts on the second row) hours worked in a specific class
Col C: class name

I want to sort by column C, but only for the specific staff. These change monthly, so the area also changes staff may leave, amount of classes etc so I can’t set up a sort by defined range because it changes.

currently - I select the area to sort, and sort by column c. I would love a short cut but i cant figure it out.

Let me know if I don’t make sense, and thanks!

 

[Legacy 456155]

So, if I am understanding you, if we were able to align the data, the sort would work. Right? Please post a screen shot sample if I missed it.

Staff Name	Hours	Class
Some Name
	8.5	Algebra
	7.5	Gym
	8.25	Geometry

to this enabling you to sort by Staff Name, Class.

Staff Name	Hours	Class
Some Name	8.5	Algebra
Some Name	7.5	Gym
Some Name	8.25	Geometry