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.
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.
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.
[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.