Replies

I prefer the most recent date.

Steve: I had answered, sorry you did not get. I have been using the most recent date, however, that is not as important as isolating the one record. These are trouble tickets, and they may be re-reported on different days, so multiple instances may occur. I only need one instance per unique record of the name/letter/number combination.

Steve: I had answered, sorry you did not get. I have been using the most recent date, however, that is not as important as isolating the one record. These are trouble tickets, and they may be re-reported on different days, so multiple instances may occur. I only need one instance per unique record of the name/letter/number combination.

I just want one record. If the other 3 columns make the row unique, the date does not matter, but I still need to capture the date as it is associated to the rest of the row.

I just want one record. If the other 3 columns make the row unique, the date does not matter, but I still need to capture the date as it is associated to the rest of the row.

Getting error when try to copy to another location. See attached. Getting around it when I copy just visible cells and move to another location

Getting error when try to copy to another location. See attached. Getting around it when I copy just visible cells and move to another location

I think the advanced filter will work for me! Thanks!

I think the advanced filter will work for me! Thanks!

See my reply to your other post. I still need assistance with macro.

See my reply to your other post. I still need assistance with macro.

Can you guys help me out with a macro? I know nothing about writing the code. See post 345004.

Can you guys help me out with a macro? I know nothing about writing the code. See post 345004.

Dave: It has a CD drive Icon………….I think I may just need to change the label of the drive to reflect the TDK External DVD burner that is connected via firewire. It IS in the device manager, but is not reflected in ‘My Computer’. How do I change the label of the drive?

Dave: It has a CD drive Icon………….I think I may just need to change the label of the drive to reflect the TDK External DVD burner that is connected via firewire. It IS in the device manager, but is not reflected in ‘My Computer’. How do I change the label of the drive?