+ Reply to Thread
Results 1 to 6 of 6

Automatically have data copy from a sheet onto another sheet according to certain criteria

  1. #1
    Registered User
    Join Date
    06-20-2012
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    4

    Automatically have data copy from a sheet onto another sheet according to certain criteria

    I have a spreadsheet that is used to track status (progress) of certain jobs. I would like to be able to update the original sheet and as the status' change per project the data (row) will still be present on the original sheet but will also automatically be copied over into another sheet. I dont know if I would have to have a seperate sheet for each status criteria to copy to or if I could have the data copy over to a single sheet that would then be automatically be sorted or filtered by that certain status? Is this possible?

    Thanks
    Misty

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,256

    Re: Automatically have data copy from a sheet onto another sheet according to certain crit

    Hi misty, welcome to the forum

    would it bpossible for you to upload a sample of what you are trying to achieve? ideally it should show what you have, what you want, and how you arrive at what yoy want. that will give us a much better understanding of your needs
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    06-20-2012
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Automatically have data copy from a sheet onto another sheet according to certain crit

    Thank you so much for your quick response in trying to help me with this issue. Here is a copy of the spreadsheet. Trying to figure this out has completely wrecked me brain for the last day.

    Thanks again,
    Misty
    Attached Files Attached Files

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,256

    Re: Automatically have data copy from a sheet onto another sheet according to certain crit

    i was playing around with filters on your file, and think that may be a very simple, yet dynamic, way of giving you what you want. have you tried to use filters yet?

    1 thing i did notice was that you do not have all your "overall priority" and "project priority" numbers in, so filtering on that doesnt work too well. but when i filtered on status, it did

    let me know if this will work for you, or if we need to look at another approach? (simple is often better)

  5. #5
    Registered User
    Join Date
    06-20-2012
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Automatically have data copy from a sheet onto another sheet according to certain crit

    I did play around with the filters, but was not able to come up with what I was trying to achieve. The master list is actually available to several depts to maintain, to which you leaves the information in there looking a jumbled mess. I need to have the information copy over to another sheet so that our mgr would be able to view it @ any & all hours of the day from his phone.

    Thanks
    Misty

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,256

    Re: Automatically have data copy from a sheet onto another sheet according to certain crit

    hi again. im not even sure where this might be going, but i have been playing around with a pivot table to see if it will get you what you want. take a look and let me know.

    what info specificaly will you be wanting to see on teh "summary" pages anyway?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1