Dear Fellows
I am looking for help for a macro which can copy data to other sheet based on adjacent cell value which i define.
For example i have data attached in a sheet.
i want to copy data based on value present in E column to different sheets. if it is ES then all ES rows should be copied to sheet ES with roll number name father per and dept.
Same is for other departments, on different sheets. There will be 9 departments overall.
Looking for response
I am looking for help for a macro which can copy data to other sheet based on adjacent cell value which i define.
For example i have data attached in a sheet.
i want to copy data based on value present in E column to different sheets. if it is ES then all ES rows should be copied to sheet ES with roll number name father per and dept.
Same is for other departments, on different sheets. There will be 9 departments overall.
Looking for response