I'm back. I'm having problems. When I add an entry, say Joe Friday/U001 at the end of the list, when I try to sort it is asking me how I want to move the data, up, down, left, right. Of course I want the data to move down but the last entry on row 50 in columns A, D, G should move up to Row 1 of the same columns and the last entry in Row 50 Column K should move to Row 51, Column A. Here's the Utility ID file I am trying to do. So here's how it should look after the sheet has been sorted.


Joe Friday - U001 should go after D-Coder-U001 in Column A row 26 and everything after Joe Friday should move down 1 row until it reaches row 50.


The entry that was in Column A Row 50(Proofreader - U002) will move to Column D Row 1 and move the data in that Column down 1 row.







The entry that was in Column D row 50(Paperclip - U013) would move to Column G Row 1 and move the data in that Column down 1 row.


The entry that was in Column G row 50(MLX - U018) would move to Column J Row 1 and move the data in that Column down 1 row.


Now the entry that was in Column J Row 50(Keybrd Buffer - U023) will be moved to Column A Row 51 and the process repeats itself until the end of the entries.


Of course the U### tags along with the entry name. ie; Column A1 and Column B1 and so forth are a pair.

Attached Files

Utility ID.xlsm (69.0 KB, 11 views)