Tech Support Guy banner
Status
Not open for further replies.

macro to copy rows based on cell value

793 views 2 replies 1 participant last post by  toofani 
#1 ·
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
 

Attachments

#3 ·
i forgot to add, my data also had headers and some of details in the above. Kindly help let me add another one for your view so that you can understand my problem better.

Data from all sheets should be compiled for different department on one respective sheet.

Will be very grateful for the help
 

Attachments

Status
Not open for further replies.
You have insufficient privileges to reply here.
Top