UPS Ship Log

[JordanK]

Hi and thank you all for your help in advance.

UPS (United Parcel Service) provides the ability to download logs of my shippments going back 45 days in a comma delimited format. I will then save it as an Excel workbook.

I will be downloading the information every 15 days (The information will be updated by tracking #). When I copy and paste the new information there will be overlaped updated data and brand new data.

Is there a way to automaticly delete the older record of the overlapped tracking numbers automaticly?

Thanks
Jordan

[Excel_Geek]

Using some VBA code, you could import the new data, and automatically delete the old vesions of tracking number records.

(I know this is like saying, "Yes, you can do that." and maybe YOU can't, but without the files, etc., it'd be hard for me to give you the code.)

Suffice it to say...it can be done.