Thread: [Solved] Linking cells: can sub-cells move with their master-cell when sorting?
View Single Post
 
Old 06-17-2015, 03:35 AM
kw01 kw01 is offline Windows 7 32bit Office 2013
Novice
  
Join Date: Jun 2015
Posts: 1
kw01 is on a distinguished road
Default Linking cells: can sub-cells move with their master-cell when sorting?
I hope I can explain myself, but is there a way of linking 'sub-folders/lines' with their respective 'folder/line' so that when you do an alphabetical sort, the 'sub-folder/lines' stay with their respective 'folder/line/master'? I have attached a before and after example (I hope you can see it). The table basically looks like the one below, but sorted by City. If I were to sort by Rep, how could I design it so the entries University, Shop, Hotel, etc stay with their respective 'master'? I apologise if this is difficult to understand.

Rep 1 Oxford
University
Hotel

Rep 2 Glasgow
Hotel
Shop

Rep 1 London
Office
Boat
Attached Files
File Type: xlsx Excel example.xlsx (8.9 KB, 12 views)
Last edited by kw01; 06-17-2015 at 06:16 AM.
Reply With Quote