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 m
shippments going back 45 days in a comma delimited format. I will the
save it as an Excel workbook.

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

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

Thanks
Jorda

 

[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.