Separate "Year" to several worksheets according to one column....
- by HACHI
hello! This task is driving me mad... please help!
Instead of manually type in the data, i have used VBA to find the year range, put into one column and delete all duplicate ones. But since excel could give more than 20 years, it would be tedious to do all the filtering manually. AND, now i need excel to separate the rows that contain the specific…