Let me be more specific about my requirement. Sheet1 contains a table with field as Sl, Name, Course Attended, Trg Date.
There are about 40 Different names in the Name field. There are about 500 rows in the table.
Now I want to fetch the training record of individual name in separate worksheets each for every name. And, most importantly, I want it to be done automatically. I only need to update sheet1 and other sheets should be updated immediately.
Any help?? (without using MACROS or VBE - I'm scared of these two ghosts.