Sorting Organisation Data?

sungod1205

New Member
Joined
Mar 19, 2018
Messages
1
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. :confused:
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.

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

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.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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
 
Upvote 0

Forum statistics

Threads
1,223,229
Messages
6,170,881
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top