I am trying to create a table that will work with a CSV file that I am getting from UPS. There are multiple values spread over multiple rows that I would have to pull from for each shipment. I would like to be able to just drop each weeks CSV into the spreadsheet and have it automatically calculate for each package shipped.
Spreadsheet Sample.xls
Here is the legend for the above sample.
For Shipment 1 there are 3 rows of information; 1,2, & 3. Only 1 & 2 are important.
J1 = Freight Discount Amount
K1 = Billed Freight
G2 = Published Charge
J2 = Published Fuel Surcharge
K2 = Billed Fuel Surcharge
I would like to be able to pull the information for this shipment to another worksheet on the same spreadsheet on the same row. I could easily copy and paste this information if it wasn't for the size of my file, over 3,000 entries over 25 different accounts.
Is there an easy way to do this?
Bookmarks