Sorting Organisation Data?

[sungod1205]

Hello all, what a wonderful place this is...loads to learn here, just need a bit more time to browse the posts.

In the mean time, I have a question to pose of my own, it has so far caused me to waste a huge amount of time, and effort...and I have got nowhere.

I hope you may be able to help.


I am trying to organise my organisations personnel data.

The data I am using has only has 5 columns (for ease in the org chart I hope to make later).

Post Reference - an 8 digit number stored as text (as many start '00......).
Employee Name - Text string.
Post Title - Text String.
Reports To Ref - an 8 digit number (again stored as text for the same reason) - these match against existing Post Ref's.
Location - Text String.

I am trying to organise my data within the spreadsheet so that it flows down in line management chains.
Like the example below...at the moment it is sorted numerically (for all 2900 posts) by the Post Ref Nos.
I have emboldened the CEO and two department heads below to indicate different departments.

Post Ref	NAME	POST TITLE	REPORTS-TO	LOCATION
00104025	Fred	CEO	00212343	London
00204022	Jeff	Deputy Head	00104025	London
00213193	Pete	AH Field	00204022	London
00204023	Jenny	Chief Operating Officer	00104025	Reading
00204021	Gemma	COO Change Mgmt	00204023	Reading
00211020	Mike	COO Change Officer	00204021	Reading
00222468	Paul	COO Project Mgmt	00204023	Reading
00222469	Dirk	COO Finance Mgmt	00204023	Reading
00209378	Liz	COO Finance Officer	00222469	Reading
00222470	Bev	COO Operations Mgmt	00204023	Reading
00218527	Ben	COO Operations Officer	00222470	Reading
00215849	Tracey	Head of People	00104025	London
00104368	Tina	HR Manager 1	00215849	London
00104368a	Tony	HR Manager 2	00215849	London
00205730	Richard	HR Manager 3	00215849	London
00210518	Rob	HR Manager 4	00215849	London
00216739	Rachel	HR Manager 5	00215849	London
00104209	Julie	HR Advisor 1	00216739	London
00104234	Victoria	HR Advisor 2	00216739	London
00109959	Jacqui	HR Advisor 3	00216739	London
00217861	Jeremy	HR Advisor 4	00216739	London

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

Any help VERY gratefully received - at the moment I am manually copying rows from one sheet to another after searching the filtered 'reports-to' column...slow and incredibly painful!!!


Very Many Thanks in Advance.

 

[Dryver14]

Not sure how we can help with this.

We would need at least to see a section of the unfiltered data (fictional or otherwise) to see if the process could be automated or if we can advise on quicker sorting and filtering methods