Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Choices made available dependent on another selection? | Excel Worksheet Functions | |||
Not Sure Which Function to Use for This | Excel Worksheet Functions |