1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

macro to copy rows based on cell value

Discussion in 'Business Applications' started by toofani, Mar 15, 2016.

Thread Status:
Not open for further replies.
  1. toofani

    toofani Thread Starter

    Joined:
    Jun 15, 2012
    Messages:
    36
    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
     

    Attached Files:

  2. toofani

    toofani Thread Starter

    Joined:
    Jun 15, 2012
    Messages:
    36
    It will be highly appreciated that the macro could extract the data from different sheets based on the dept. there are different sheets where the department wise data is present
     
  3. toofani

    toofani Thread Starter

    Joined:
    Jun 15, 2012
    Messages:
    36
    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
     

    Attached Files:

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1168014

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice