this is an issue I am faced with.
Sheet 1 contains info of ~300 rows of data of individuals, with their names in Column A, their qualifications such as "Bachelor's Degree" or "Master's Degree" in Column B, graduation date in Column C.
These individuals can have up to 4 different types of qualifications eg. Bachelor's Degree 1 in Column B, graduation date 2 in Column C, Master's Degree 2 in Column D, graduation date 2 in Column E etc.
Sheet 2 contains columns named "Bachelor's degree 1", "Bachelor's degree 2", "Master's degree 1", and "Master's degree 2", along with their respective graduation dates.
My question is, how do I write a VBA script that automatically sorts the data in Sheet 1 into the right columns in Sheet 2, alongside their respective graduation dates?
https://stackoverflow.com/questions/65572237/vba-categorizing-info-correctly-into-columns-in-different-sheet January 05, 2021 at 10:01AM
没有评论:
发表评论