Hello Excel wizards!
Thank you in advance for your help! I have created an example file that explains what I need to do. I need to do this using formulas not VBA.
TASK: Automate the copying of names (col C) from Tab 1 (RAW DATA) to a specific, 2 column range on Tab 2 (GRID), based on value of Col B on TAB 1, such that,
1) Names are placed in the right position on the "grid" on Tab 2
2) Are sorted in alphabetical order
3) Wrap to 2nd column within the quadrant if necessary
4) Automatically update/shift position when data in the RAW DATA tab is modified
RESTRICTIONS:
RAW DATA file cannot be re-sorted
THANK YOU!!!!
Bookmarks