tcambridge
11-06-2015, 01:46 PM
:hi::banghead:
Hi,
I have the attached workbook, which I have to log-in to UPS website than download data to one tab. Then I have to manually filter the data and then copy to each desired worksheet tab. Then it being link and summarize to the Summary sheet. I just wonder if we can use VBA to automate and expedite this manual process. I love to attache the workbook for your reference but the website keeps giving me error page.
Here is the link to the file:
https://www.dropbox.com/s/1h7c05cllmahuq9/UPS%20charges%20template.xlsx?dl=0
The Adjustment tab is for any service fee that is NOT a shipping charge.
Other tabs is filtered data colunms in the data tab.
Thanks for all your helps.
Hi,
I have the attached workbook, which I have to log-in to UPS website than download data to one tab. Then I have to manually filter the data and then copy to each desired worksheet tab. Then it being link and summarize to the Summary sheet. I just wonder if we can use VBA to automate and expedite this manual process. I love to attache the workbook for your reference but the website keeps giving me error page.
Here is the link to the file:
https://www.dropbox.com/s/1h7c05cllmahuq9/UPS%20charges%20template.xlsx?dl=0
The Adjustment tab is for any service fee that is NOT a shipping charge.
Other tabs is filtered data colunms in the data tab.
Thanks for all your helps.