UPS Ship Log
 

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


--
JordanK
------------------------------------------------------------------------
JordanK's Profile: http://www.excelforum.com/member.php...o&userid=26698
View this thread: http://www.excelforum.com/showthread...hreadid=399634

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.


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=399634