I am entering seminar selection data for 600 students and i have a spreadsheet with names and id numbers. there are 20 seminars that they may attend and they have "ranked" them 1-20. I would i have a data entry sheet with a VLOOKUP that will find the student (on the second sheet) and display the current choices. Now I want to send the data back (after modifying the list) back to the original spreadsheet and overwrite the results. Can someone help me with the Macro Logic for this update routine?
Layout would be:
Student Id - Choice 1 - Choice 2 - ... choice 20.
Again i can read the results spreadsheet using VLOOKUP and display the current results, but i can't figure out how to write changes back.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!