oharris
07-18-2006, 09:09 AM
Hello all, I hate to ask a question on a first post, but that appears to be what this forum is for.
I have a schedule in Excel that I have to keep up. Each item has a unique number associated with it. Each day, I get in an Excel sheet, a list of changes which can range anywhere from one line to hundreds of lines. For changes, the change list includes the unique numbers. I'd like to be able to filter for the numbers in the new sheet, so I can easily remove them and insert the changes, but I cant figure out any way to do this. I can't post the actual files, but for example, lets say my schedule contains 100 items numbered 1-100. The change file has changes listed to lines 22, 37, 53, 62, 73. How can I filter the main list to only show the same line numbers as the change file? Is there an easy way to do this I am overlooking? Thanks in advance.
I have a schedule in Excel that I have to keep up. Each item has a unique number associated with it. Each day, I get in an Excel sheet, a list of changes which can range anywhere from one line to hundreds of lines. For changes, the change list includes the unique numbers. I'd like to be able to filter for the numbers in the new sheet, so I can easily remove them and insert the changes, but I cant figure out any way to do this. I can't post the actual files, but for example, lets say my schedule contains 100 items numbered 1-100. The change file has changes listed to lines 22, 37, 53, 62, 73. How can I filter the main list to only show the same line numbers as the change file? Is there an easy way to do this I am overlooking? Thanks in advance.